AP Invoices Deleted in the Oracle E-Business Suite are not Deleted in the Business Analytics Data Warehouse (Doc ID 987190.1)

Last updated on MARCH 08, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version: 10.1.3.4.1 [1900] and later   [Release: and later ]
Payables Analytics - Version: 7.9.6 [1340] and later    [Release: V7 and later]
Information in this document applies to any platform.

Symptoms

An AP Invoice that was originally uploaded to the Oracle BI Applications 7.9.6 data warehouse from the Oracle E-Business Suite (source system / application) was subsequently deleted from the Oracle E-Business Suite system, however it was not automatically deleted from the Oracle Business Analytics Data Warehouse.  This lead to analytical reports / results that were out of sync with the source system.

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