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


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