Ok Aditya/Jacques , thanks for the clarifications .
On Fri, Sep 1, 2017 at 1:40 PM, Aditya Sharma < [email protected]> wrote: > Hi Rajesh, > > 2 ways to do that > > 1. Just like Jacques mentioned, you can change the DB values directly using > entity engine > https://demo-trunk.ofbiz.apache.org/webtools/control/ > FindGeneric?entityName=SystemProperty > > 2. You can prepare the data(if more than 1 value) just like it is done in > data files & import it here > https://demo-trunk.ofbiz.apache.org/webtools/control/EntityImport > > Thanks and Regards, > > *Aditya Sharma* | Enterprise Software Engineer > HotWax Systems <http://www.hotwaxsystems.com/> > <https://www.linkedin.com/in/aditya-sharma-78291810a/> > > On Fri, Sep 1, 2017 at 1:30 PM, Jacques Le Roux < > [email protected]> wrote: > > > Either edit the DB value or remove it from DB and change it in the > > property file. If the data is only emptied in DB it still prevails the > > property in file. > > > > Jacques > > > > > > > > Le 01/09/2017 à 09:52, Rajesh Mallah a écrit : > > > >> Hi Aditya , > >> > >> Suppose the seed,seed-initial,demo data is already loaded. > >> > >> Question is under current stable version , what options does an > >> end user have if he/she has to change a property value > >> like currency.uom.id.default ? > >> > >> > >> regds > >> mallah. > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> > >> On Fri, Sep 1, 2017 at 12:16 PM, Aditya Sharma < > >> [email protected]> wrote: > >> > >> Hello Rajesh, > >>> > >>> I think you misunderstood that. > >>> > >>> (1) I observed that when I changed the file system configuration > >>> > >>>> settings the restarted the server the value in SystemProperty > >>>> remained the same. I am not sure if this is the expected behaviour. > >>>> > >>> System configuration file will not change SystemProperty value. > >>> > >>> Values in SystemProperty entity overrides file system configuration > >>> settings. > >>> > >>> For Example, CurrencyUomId in configuration file is USD & > SystemProperty > >>> entity is IN. It will pick IN as current setting. > >>> > >>> Thanks and Regards, > >>> > >>> *Aditya Sharma* | Enterprise Software Engineer > >>> HotWax Systems <http://www.hotwaxsystems.com/> > >>> <https://www.linkedin.com/in/aditya-sharma-78291810a/> > >>> > >>> On Fri, Sep 1, 2017 at 11:38 AM, mallah.rajesh < > [email protected]> > >>> wrote: > >>> > >>> Changes to the general.properties files were not getting picked . As > >>>> mentioned in past email The value in the rdbms were remaining the > same > >>>> . > >>>> I do not know about the proper usage Of that file. An end user will > >>>> definitely Be confounded by this. > >>>> The idea of changing the file came from searching ml archives. May be > >>>> > >>> some > >>> > >>>> of those info is outdated. > >>>> RegdsMallah > >>>> > >>>> > >>>> > >>>> > >>>> Sent from my Samsung Galaxy smartphone. > >>>> -------- Original message --------From: Arun Patidar < > >>>> [email protected]> Date: 9/1/17 10:36 (GMT+05:30) To: > >>>> [email protected] Cc: [email protected] Subject: Re: setting > >>>> up > >>>> TAX in ofbiz [ SOLVED ] > >>>> Hi Rajesh, > >>>> > >>>> Both ways are alternative to each other and not auto linked. You may > >>>> need > >>>> to use either file system configuration or SystemProperty data > >>>> configuration. Usually, data configuration is essential with multi > >>>> > >>> tenancy > >>> > >>>> environment. > >>>> > >>>> > >>>> > >>>> -- > >>>> Thanks & Regards > >>>> --- > >>>> Arun Patidar > >>>> Manager, Enterprise Software Development > >>>> > >>>> HotWax Systems Pvt Ltd. > >>>> > >>>> www.hotwaxsystems.com > >>>> > >>>> > >>>> On Thu, Aug 31, 2017 at 8:07 PM, Rajesh Mallah < > [email protected] > >>>> > > >>>> wrote: > >>>> > >>>> Dear Arun , > >>>>> > >>>>> Thanks for clarifying that . > >>>>> > >>>>> (1) I observed that when I changed the file system configuration > >>>>> settings the restarted the server the value in SystemProperty > >>>>> remained the same. I am not sure if this is the expected behaviour. > >>>>> > >>>>> In My setup I use a remote postgresql server . > >>>>> > >>>>> I verified (1) just now. > >>>>> > >>>>> regds > >>>>> mallah. > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> On Thu, Aug 31, 2017 at 7:46 PM, Arun Patidar < > >>>>> [email protected]> wrote: > >>>>> > >>>>> Hi Rajesh, > >>>>>> > >>>>>> SystemProperty entity is used to override file system configuration > >>>>>> settings. This also gives flexibility of changing values on runtime > >>>>>> > >>>>> without > >>>>> > >>>>>> restart. System, first checks in the database and then go to file > >>>>>> > >>>>> system > >>>> > >>>>> if > >>>>> > >>>>>> value not found. > >>>>>> > >>>>>> > >>>>>> -- > >>>>>> Thanks & Regards > >>>>>> --- > >>>>>> Arun Patidar > >>>>>> Manager, Enterprise Software Development > >>>>>> > >>>>>> HotWax Systems Pvt Ltd. > >>>>>> > >>>>>> www.hotwaxsystems.com > >>>>>> > >>>>>> > >>>>>> On Thu, Aug 31, 2017 at 6:41 PM, Rajesh Mallah < > >>>>>> > >>>>> [email protected]> > >>>> > >>>>> wrote: > >>>>>> > >>>>>> Hi List , > >>>>>>> > >>>>>>> At last I managed to get my setup pick up the prices specified in > >>>>>>> > >>>>>> non-USD > >>>>>> > >>>>>>> currency (i.e INR in my case) . > >>>>>>> > >>>>>>> From what I could understand , the system attempts to get the the > >>>>>>> value of "currency of handling" from multiple sources as currency > >>>>>>> > >>>>>> attribute > >>>>>> > >>>>>>> itself can be specified at multiple places. > >>>>>>> > >>>>>>> [ Source of above info: > >>>>>>> ./applications/product/src/main/java/org/apache/ofbiz/ > >>>>>>> product/price/PriceServices.java > >>>>>>> Lines: 80-567, Func: calculateProductPrice ] > >>>>>>> > >>>>>>> If for whatever reasons (or set of reasons) the currency could not > >>>>>>> be determined > >>>>>>> > >>>>>>> (1) it attempts to get the value of property > >>>>>>> > >>>>>> 'currency.uom.id.default' > >>>>> > >>>>>> in > >>>>>> > >>>>>>> general resource/category , > >>>>>>> (1.1) if that also cannot be got it uses the hard coded > >>>>>>> > >>>>>> default > >>> > >>>> USD [ > >>>>>> > >>>>>>> PriceServices.java:148 ] > >>>>>>> > >>>>>>> 142 String currencyDefaultUomId = (String) > >>>>>>> context.get("currencyUomId"); > >>>>>>> 143 String currencyUomIdTo = (String) > >>>>>>> context.get("currencyUomIdTo"); > >>>>>>> 144 if (UtilValidate.isEmpty(currencyDefaultUomId)) { > >>>>>>> 145 if (productStore != null && > >>>>>>> UtilValidate.isNotEmpty(productStore.getString(" > >>>>>>> > >>>>>> defaultCurrencyUomId"))) > >>>>> > >>>>>> { > >>>>>> > >>>>>>> 146 currencyDefaultUomId = > >>>>>>> productStore.getString("defaultCurrencyUomId"); > >>>>>>> 147 } else { > >>>>>>> 148 currencyDefaultUomId = > >>>>>>> EntityUtilProperties.getPropertyValue("general", > >>>>>>> "currency.uom.id.default", > >>>>>>> "USD", delegator); > >>>>>>> 149 } > >>>>>>> 150 } > >>>>>>> > >>>>>>> > >>>>>>> The reason why it took so long to track it down is that > >>>>>>> the system property 'currency.uom.id.default' itself can be > >>>>>>> > >>>>>> specified > >>>> > >>>>> in 2 places: > >>>>>>> > >>>>>>> (1) ./framework/common/config/general.properties > >>>>>>> (2) ./framework/common/data/CommonSystemPropertyData.xml > >>>>>>> > >>>>>>> and the entity table (RDBMS) is : SYSTEM_PROPERTY > >>>>>>> which seems to be loaded from (2) only and not (1) > >>>>>>> ( at least for the property currency.uom.id.default ) > >>>>>>> > >>>>>>> I had been making changes to (1) and expecting the system to > >>>>>>> use it. However the system uses the table SYSTEM_PROPERTY > >>>>>>> that seems to be getting loaded only from (2). > >>>>>>> > >>>>>>> > >>>>>>> Although i have marked this thread as solved , I am yet to analyze > >>>>>>> why at all the flow control reached to the stage of last resort for > >>>>>>> determining the handling currency from system property > >>>>>>> currency.uom.id.default > >>>>>>> > >>>>>>> It should have been determined much earlier through information > >>>>>>> > >>>>>> provided > >>>>> > >>>>>> end user using WEB-UI controls. > >>>>>>> > >>>>>>> > >>>>>>> I would update this thread at a later time when i am able to > >>>>>>> > >>>>>> investigate > >>>>> > >>>>>> that. > >>>>>>> > >>>>>>> regds > >>>>>>> mallah. > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> On Thu, Aug 31, 2017 at 11:39 AM, Rajesh Mallah < > >>>>>>> > >>>>>> [email protected] > >>>>> > >>>>>> wrote: > >>>>>>> > >>>>>>> > >>>>>>>> I wonder why a query on a table should be run looking for > >>>>>>>> rows where the primary key of table is null. > >>>>>>>> > >>>>>>>> the sole filter on the below query on ProductStore is: > >>>>>>>> WHERE ((PRODUCT_STORE_ID IS NULL)) > >>>>>>>> > >>>>>>>> Note: this query is just run *before* looking in the ProductPrice > >>>>>>>> table. > >>>>>>>> > >>>>>>>> more context here: https://pastebin.com/raw/sSh1sNWb > >>>>>>>> > >>>>>>>> BTW: what is the way of altering logging config in OfBiz > >>>>>>>> to include Filenames and Line number? > >>>>>>>> > >>>>>>>> regds > >>>>>>>> mallah. > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> 2017-08-31 10:45:18,180 |http-nio-8080-exec-5 > >>>>>>>> |GenericDAO |T| Ran query in 3 milli-seconds: > >>>>>>>> EntityName: ProductStore Sql: SELECT PRODUCT_STORE_ID, > >>>>>>>> PRIMARY_STORE_GROUP_ID, STORE_NAME, COMPANY_NAME, TITLE, > >>>>>>>> > >>>>>>> SUBTITLE, > >>> > >>>> PAY_TO_PARTY_ID, DAYS_TO_CANCEL_NON_PAY, MANUAL_AUTH_IS_CAPTURE, > >>>>>>>> PRORATE_SHIPPING, PRORATE_TAXES, VIEW_CART_ON_ADD, > >>>>>>>> > >>>>>>> AUTO_SAVE_CART, > >>> > >>>> AUTO_APPROVE_REVIEWS, IS_DEMO_STORE, IS_IMMEDIATELY_FULFILLED, > >>>>>>>> INVENTORY_FACILITY_ID, ONE_INVENTORY_FACILITY, CHECK_INVENTORY, > >>>>>>>> RESERVE_INVENTORY, RESERVE_ORDER_ENUM_ID, REQUIRE_INVENTORY, > >>>>>>>> BALANCE_RES_ON_ORDER_CREATION, REQUIREMENT_METHOD_ENUM_ID, > >>>>>>>> ORDER_NUMBER_PREFIX, DEFAULT_LOCALE_STRING, > >>>>>>>> > >>>>>>> DEFAULT_CURRENCY_UOM_ID, > >>>> > >>>>> DEFAULT_TIME_ZONE_STRING, DEFAULT_SALES_CHANNEL_ENUM_ID, > >>>>>>>> > >>>>>>> ALLOW_PASSWORD, > >>>>>> > >>>>>>> DEFAULT_PASSWORD, EXPLODE_ORDER_ITEMS, CHECK_GC_BALANCE, > >>>>>>>> RETRY_FAILED_AUTHS, HEADER_APPROVED_STATUS, ITEM_APPROVED_STATUS, > >>>>>>>> DIGITAL_ITEM_APPROVED_STATUS, HEADER_DECLINED_STATUS, > >>>>>>>> > >>>>>>> ITEM_DECLINED_STATUS, > >>>>>>> > >>>>>>>> HEADER_CANCEL_STATUS, ITEM_CANCEL_STATUS, AUTH_DECLINED_MESSAGE, > >>>>>>>> AUTH_FRAUD_MESSAGE, AUTH_ERROR_MESSAGE, VISUAL_THEME_ID, > >>>>>>>> STORE_CREDIT_ACCOUNT_ENUM_ID, USE_PRIMARY_EMAIL_USERNAME, > >>>>>>>> REQUIRE_CUSTOMER_ROLE, AUTO_INVOICE_DIGITAL_ITEMS, > >>>>>>>> REQ_SHIP_ADDR_FOR_DIG_ITEMS, SHOW_CHECKOUT_GIFT_OPTIONS, > >>>>>>>> SELECT_PAYMENT_TYPE_PER_ITEM, SHOW_PRICES_WITH_VAT_TAX, > >>>>>>>> > >>>>>>> SHOW_TAX_IS_EXEMPT, > >>>>>>> > >>>>>>>> VAT_TAX_AUTH_GEO_ID, VAT_TAX_AUTH_PARTY_ID, > >>>>>>>> > >>>>>>> ENABLE_AUTO_SUGGESTION_LIST, > >>>>>> > >>>>>>> ENABLE_DIG_PROD_UPLOAD, PROD_SEARCH_EXCLUDE_VARIANTS, > >>>>>>>> DIG_PROD_UPLOAD_CATEGORY_ID, AUTO_ORDER_CC_TRY_EXP, > >>>>>>>> AUTO_ORDER_CC_TRY_OTHER_CARDS, AUTO_ORDER_CC_TRY_LATER_NSF, > >>>>>>>> AUTO_ORDER_CC_TRY_LATER_MAX, STORE_CREDIT_VALID_DAYS, > >>>>>>>> > >>>>>>> AUTO_APPROVE_INVOICE, > >>>>>>> > >>>>>>>> AUTO_APPROVE_ORDER, SHIP_IF_CAPTURE_FAILS, > >>>>>>>> > >>>>>>> SET_OWNER_UPON_ISSUANCE, > >>> > >>>> REQ_RETURN_INVENTORY_RECEIVE, ADD_TO_CART_REMOVE_INCOMPAT, > >>>>>>>> ADD_TO_CART_REPLACE_UPSELL, SPLIT_PAY_PREF_PER_SHP_GRP, > >>>>>>>> > >>>>>>> MANAGED_BY_LOT, > >>>>> > >>>>>> SHOW_OUT_OF_STOCK_PRODUCTS, ORDER_DECIMAL_QUANTITY, > >>>>>>>> > >>>>>>> ALLOW_COMMENT, > >>> > >>>> STYLE_SHEET, HEADER_LOGO, HEADER_MIDDLE_BACKGROUND, > >>>>>>>> HEADER_RIGHT_BACKGROUND, LAST_UPDATED_STAMP, > >>>>>>>> > >>>>>>> LAST_UPDATED_TX_STAMP, > >>> > >>>> CREATED_STAMP, CREATED_TX_STAMP FROM ofbiz.PRODUCT_STORE WHERE > >>>>>>>> ((PRODUCT_STORE_ID IS NULL)) where clause:[] > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> On Thu, Aug 31, 2017 at 11:23 AM, Rajesh Mallah < > >>>>>>>> > >>>>>>> [email protected] > >>>>>> > >>>>>>> wrote: > >>>>>>>> > >>>>>>>> Hi Arun , > >>>>>>>>> > >>>>>>>>> I checked PartyAcctgPreference which was USD and changed it to > >>>>>>>>> > >>>>>>>> INR > >>> > >>>> yesterday only. After changes i do logout and login and restart > >>>>>>>>> > >>>>>>>> the > >>>> > >>>>> tomcat > >>>>>>> > >>>>>>>> to ensure there are no caching issues. > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> ofbiz_redgrape=> SELECT PTYACCPREF.PARTY_ID, > >>>>>>>>> PTYACCPREF.BASE_CURRENCY_UOM_ID, PTYGROUP.GROUP_NAME, > >>>>>>>>> PTYROLE.ROLE_TYPE_ID FROM (ofbiz.PARTY_ACCTG_PREFERENCE > >>>>>>>>> > >>>>>>>> PTYACCPREF > >>> > >>>> INNER > >>>>>> > >>>>>>> JOIN ofbiz.PARTY_GROUP PTYGROUP ON PTYACCPREF.PARTY_ID = > >>>>>>>>> > >>>>>>>> PTYGROUP.PARTY_ID) > >>>>>>> > >>>>>>>> INNER JOIN ofbiz.PARTY_ROLE PTYROLE ON PTYACCPREF.PARTY_ID = > >>>>>>>>> PTYROLE.PARTY_ID WHERE (((PTYROLE.ROLE_TYPE_ID = > >>>>>>>>> > >>>>>>>> 'INTERNAL_ORGANIZATIO'))); > >>>>>>> > >>>>>>>> -[ RECORD 1 ]--------+---------------------------------- > >>>>>>>>> party_id | Company > >>>>>>>>> base_currency_uom_id | INR > >>>>>>>>> group_name | REDGRAPE TECHNOLOGIES PRIVATE LTD > >>>>>>>>> role_type_id | INTERNAL_ORGANIZATIO > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> The relevant field ProductStore is also INR > >>>>>>>>> > >>>>>>>>> https://pastebin.com/raw/mM2j6kiE > >>>>>>>>> > >>>>>>>>> ...... > >>>>>>>>> > >>>>>>>>> requirement_method_enum_id | > >>>>>>>>> order_number_prefix | > >>>>>>>>> default_locale_string | en_US > >>>>>>>>> default_currency_uom_id | INR > >>>>>>>>> default_time_zone_string | Asia/Kolkata > >>>>>>>>> default_sales_channel_enum_id | > >>>>>>>>> allow_password | Y > >>>>>>>>> > >>>>>>>>> ......... > >>>>>>>>> > >>>>>>>>> regds > >>>>>>>>> mallah. > >>>>>>>>> > >>>>>>>>> > >>>>>>>>> On Thu, Aug 31, 2017 at 11:05 AM, Arun Patidar < > >>>>>>>>> [email protected]> wrote: > >>>>>>>>> > >>>>>>>>> Hello Rajesh, > >>>>>>>>>> > >>>>>>>>>> ProductStore and PartyAcctgPreference entities also have fields > >>>>>>>>>> > >>>>>>>>> to > >>>> > >>>>> store > >>>>>>> > >>>>>>>> currency UOM. > >>>>>>>>>> > >>>>>>>>>> -- > >>>>>>>>>> Thanks & Regards > >>>>>>>>>> --- > >>>>>>>>>> Arun Patidar > >>>>>>>>>> Manager, Enterprise Software Development > >>>>>>>>>> > >>>>>>>>>> HotWax Systems Pvt Ltd. > >>>>>>>>>> > >>>>>>>>>> www.hotwaxsystems.com > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> On Thu, Aug 31, 2017 at 9:17 AM, Rajesh Mallah < > >>>>>>>>>> > >>>>>>>>> [email protected]> > >>>>>>> > >>>>>>>> wrote: > >>>>>>>>>> > >>>>>>>>>> looks like too many messages has already been > >>>>>>>>>>> exchanged in past at various point in time. > >>>>>>>>>>> > >>>>>>>>>>> http://ofbiz.markmail.org/search/?q=changing+default+ > >>>>>>>>>>> currency#query:changing%20default%20currency > >>>>>>>>>>> > >>>>>>>>>>> it will be beneficial to new users if it is given attention > >>>>>>>>>>> > >>>>>>>>>> . > >>> > >>>> regds > >>>>>>>>>>> mallah. > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> On Thu, Aug 31, 2017 at 8:01 AM, Rajesh Mallah < > >>>>>>>>>>> > >>>>>>>>>> [email protected]> > >>>>>>>>>> > >>>>>>>>>>> wrote: > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>>> > >>>>>>>>>>>> @Deepak , @Rishi / List , > >>>>>>>>>>>> > >>>>>>>>>>>> Additional SQL tracing reveals that the ProductPricing > >>>>>>>>>>>> entities are being queried with CURRENCY_UOM_ID=USD > >>>>>>>>>>>> and hence the USD pricing is being picked up. I am not sure > >>>>>>>>>>>> why USD currency is being picked. I have changed in almost > >>>>>>>>>>>> all places including properties file. > >>>>>>>>>>>> > >>>>>>>>>>>> -- ./framework/common/config/general.properties > >>>>>>>>>>>> > >>>>>>>>>>>> # -- unique instance id (20 char max) > >>>>>>>>>>>> unique.instanceId=ofbiz1 > >>>>>>>>>>>> # -- the default currency to use for prices, etc > >>>>>>>>>>>> currency.uom.id.default=INR > >>>>>>>>>>>> # These values override the _NA_ DEFAULT values in user > >>>>>>>>>>>> > >>>>>>>>>>> preferences > >>>>>> > >>>>>>> for > >>>>>>>>>> > >>>>>>>>>>> the GLOBAL_PREFERENCES userPrefGroupTypeId > >>>>>>>>>>>> # -- the default organizationPartyId for used in dropdowns > >>>>>>>>>>>> > >>>>>>>>>>> and > >>>> > >>>>> reports > >>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>>> 2017-08-31 07:52:15,412 |http-nio-8080-exec-9 |GenericDAO > >>>>>>>>>>>> |T| Ran query in 1 milli-seconds: EntityName: ProductPrice > >>>>>>>>>>>> Sql: SELECT PRODUCT_ID, PRODUCT_PRICE_TYPE_ID, > >>>>>>>>>>>> > >>>>>>>>>>> PRODUCT_PRICE_PURPOSE_ID, > >>>>>>>>>> > >>>>>>>>>>> CURRENCY_UOM_ID, PRODUCT_STORE_GROUP_ID, FROM_DATE, > >>>>>>>>>>>> > >>>>>>>>>>> THRU_DATE, > >>>> > >>>>> PRICE, > >>>>>>>>>> > >>>>>>>>>>> TERM_UOM_ID, CUSTOM_PRICE_CALC_SERVICE, PRICE_WITHOUT_TAX, > >>>>>>>>>>>> > >>>>>>>>>>> PRICE_WITH_TAX, > >>>>>>>>>>> > >>>>>>>>>>>> TAX_AMOUNT, TAX_PERCENTAGE, TAX_AUTH_PARTY_ID, > >>>>>>>>>>>> > >>>>>>>>>>> TAX_AUTH_GEO_ID, > >>>> > >>>>> TAX_IN_PRICE, > >>>>>>>>>>> > >>>>>>>>>>>> CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, > >>>>>>>>>>>> LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, > >>>>>>>>>>>> > >>>>>>>>>>> LAST_UPDATED_TX_STAMP, > >>>>>>>>>> > >>>>>>>>>>> CREATED_STAMP, CREATED_TX_STAMP FROM ofbiz.PRODUCT_PRICE > >>>>>>>>>>>> > >>>>>>>>>>> WHERE > >>>> > >>>>> ((PRODUCT_ID = ? AND (PRODUCT_PRICE_PURPOSE_ID = ? OR > >>>>>>>>>>>> > >>>>>>>>>>> PRODUCT_PRICE_PURPOSE_ID IS NULL) > >>>>>>>>>>> > >>>>>>>>>>>> AND CURRENCY_UOM_ID = ? AND PRODUCT_STORE_GROUP_ID = ?)) > >>>>>>>>>>>> ORDER BY FROM_DATE DESC > >>>>>>>>>>>> > >>>>>>>>>>>> where clause:[PRODUCT_ID=10000, PRODUCT_PRICE_PURPOSE_ID= > >>>>>>>>>>>> > >>>>>>>>>>> PURCHASE, > >>>>>>> > >>>>>>>> CURRENCY_UOM_ID=USD,PRODUCT_STORE_GROUP_ID=_NA_] > >>>>>>>>>>>> > >>>>>>>>>>>> Full Log: > >>>>>>>>>>>> https://pastebin.com/raw/smdQX84B > >>>>>>>>>>>> > >>>>>>>>>>>> > >>>>>>>>>>>> Looking forward to further comments and > >>>>>>>>>>>> guidance. > >>>>>>>>>>>> > >>>>>>>>>>>> regds > >>>>>>>>>>>> mallah. > >>>>>>>>>>>> > >>>>>>>>>>>> > >>>>>>>>> > > >
