OOTB Expense Reports Shows Null Because LOC_EXCHANGE_RATE Is Not Mapped
(Doc ID 2314101.1)
Last updated on AUGUST 15, 2019
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168.2 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