OBIA 184.108.40.206.1 Financial Analytics OOTB Reports With $ Amount Populating $0.00
(Doc ID 1956779.1)
Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.1 and later
Information in this document applies to any platform.
OBIA 18.104.22.168.1 Financial Analytics OOTB reports with $ Amount are populating $0.00 due to LOC_EXCHANGE_RATE
You implemented OBIA 22.214.171.124.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;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!