Missing USD Exchange Rates In W_GLOBAL_EXCH_RATE_G When Configuring Other Global Currencies In BIACM
(Doc ID 2354422.1)
Last updated on AUGUST 15, 2019
Applies to:Business Intelligence Applications Consumer - Version 188.8.131.52.2 and later
Information in this document applies to any platform.
On : 184.108.40.206.2 version, DataWarehouse EBS 12.2.2
Missing USD exchange rates in W_GLOBAL_EXCH_RATE_G when configuring other global currencies in BIACM
We observed that there are two different ETL interfaces to load data into W_GLOBAL_EXCH_RATE_G.
1. SDE_ORAR122_ADAPTOR_SDE_ORA_GLOBALEXCHANGERATEGENERAL_GENERATED maping is used when all the Global Currencies are configured as same. This loaded data from W_DAY_D.
2.SDE_ORAR122_ADAPTOR_SDE_ORA_GLOBALEXCHANGERATEGENERAL mapping is used when Global Currencies are different (atleast two). This loaded data from GL_DAILY_RATES.
We configured global1 as 'USD',global2 as 'EUR' and global3 as 'CAD' and found the SDE_ORAR122_ADAPTOR_SDE_ORA_GLOBALEXCHANGERATEGENERAL is being picked up and no records are flowing from W_DAY_D for USD currency. Hence Balance_Global1_amount in W_GL_BALANCE_F has all NULL for CURR_CODE='USD'.
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