OBIA 7963 DELETE ISSUE ON W_EXPENSE_F (Doc ID 1459637.1)

Last updated on AUGUST 10, 2017

Applies to:

Siebel Finance Analytics - Version 7.9.6.3 [AN 1900] to 7.9.6.3 [AN 1900] [Release V7]
Information in this document applies to any platform.

Symptoms

 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.



Changes

 

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