OBIA 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 and later
Information in this document applies to any platform.


OBIA Financial Analytics OOTB reports with $ Amount are populating $0.00 due to LOC_EXCHANGE_RATE

You implemented OBIA 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.



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