My Oracle Support Banner

OOTB Expense Reports Shows Null Because LOC_EXCHANGE_RATE Is Not Mapped (Doc ID 2314101.1)

Last updated on OCTOBER 04, 2017

Applies to:

Business Intelligence Applications Consumer - Version and later
Information in this document applies to any platform.


OOTB Expense Reports shows Null because LOC_EXCHANGE_RATE is not mapped on ODI Expense Mapping

LOC_EXCHANGE_RATE column @ W_EXPENSE_F loaded "Null" values & all Employee Expense related dashboard reports shows No Results. Further Analysis shows, on SDE_ORA_EmployeeExpenseFact -> SDE_ORA_EmployeeExpenseFact.W_EXPENSE_FS (Interfaces) -> LOC_EXCHANGE_RATE (Mapping) column is not mapped


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.