My Oracle Support Banner

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.



To view full details, 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 a vibrant support community of peers and Oracle experts.