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

Symptoms


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

Cause

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