@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.
