OBIA 11g: Rollbacked Payroll Run Transactions Are Not Deleted In The Data Warehouse

(Doc ID 2371542.1)

Last updated on APRIL 12, 2018

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

OBIA: 11.1.1.7.1 and higher
OBIA module used: Financial
Source System: E-Business Suite (EBS) 12.1.1

When Rollback Payroll run happened in EBS, those lines are not removed for OBIA Data Warehouse (DW) which causes report variance between EBS source and BI target data.
For example, One employee got quick pay and payroll run and those transactions extracted into OBIA. Later Rollback took place in source EBS and those lines got deleted in EBS but it is not reflected on OBIA and those transactions which got rollbacked (Removed) in EBS are still available in OBIA DW and corresponding reports.


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