OBIA 7963 DELETE ISSUE ON W_EXPENSE_F
Last updated on OCTOBER 09, 2017
Applies to:Siebel Finance Analytics - Version 22.214.171.124 [AN 1900] to 126.96.36.199 [AN 1900] [Release V7]
Information in this document applies to any platform.
Issue found with 7963 Expense fact mapping for EBS 11510 release.
Default mapping SDE_ORA_EmployeeExpenseFact should not used and all customers should use the SDE_ORA_EmployeeExpenseFact_FP mapping as default mapping for Expense full & incremental loads.
Here, integration_id is TO_CHAR(REPORT_HEADER_ID||'~'||REPORT_LINE_ID||'~'||REPORT_DISTRIBUTION_ID)
In the fact mapping, report_distribution_id popuated from AP_EXP_REPORT_DISTS_ALL table where as in SDE_ORA_EmployeeExpenseFact_Primary mapping, it has been populated from LINES table(AP_EXPENSE_REPORT_LINES_ALL).
And this will cause DELETED records to exist in W_EXPENSE_F table.
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