Missing USD Exchange Rates In W_GLOBAL_EXCH_RATE_G When Configuring Other Global Currencies In BIACM
Last updated on FEBRUARY 23, 2018
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.2 and later
Information in this document applies to any platform.
On : 18.104.22.168.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'.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms