OBIA 220.127.116.11.1 Financial Analytics OOTB Reports With $ Amount Populating $0.00
Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168.1 and later
Information in this document applies to any platform.
OBIA 22.214.171.124.1 Financial Analytics OOTB reports with $ Amount are populating $0.00 due to LOC_EXCHANGE_RATE
You implemented OBIA 126.96.36.199.1 Financial Analytics & Procurement & Spend Analytics with EBS_R12.1.3 source system.
After completing data load, the LOC_EXCHANGE_RATE field is populating with a NULL value which causes OOTB reports with $ Amount (Example - Invoice Amount) to populate $0.00.
In addition you found W_EXCHANGE_G table is empty. W_EXCHANGE_G is empty because GL_DAILY_RATES table in the source system is empty because you have just one currency, USD, hence this table is empty.
SELECT * FROM W_GLOBAL_EXCH_RATE_G;
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