Issue With ODI Lookup Function LKP_W_EXCH_RATE
(Doc ID 2245296.1)
Last updated on NOVEMBER 07, 2018
Applies to:Oracle Retail Merchandising Insights - Version 13.3.8 and later
Information in this document applies to any platform.
When the transaction date matches the end date of the exchange rate the lookup will return a null. This issue impacts all the fact tables that have the column LOC_EXCHANGE_RATE.
Steps To Recreate:
- Login to ODI.
- Verify ODI User Lookup Function LKP_W_EXCH_RATE return null When the transaction date matches the end date of the exchange rate
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document