OBIA 7963 SDE_ORA_GLJournals Mapping Doesn't Extract Some Records While Running Incremental ETL (Doc ID 1959601.1)

Last updated on JUNE 11, 2015

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.3 [AN 1900] and later
Information in this document applies to any platform.

Symptoms

In the mapping SDE_ORA_GLJournals you find the incremental data is extracted based on LAST_UPDATE_DATE column in GL_JE_BATCHES table. If there was an update made only to GL_JE_HEADER / GL_JE_LINES and not to the Batches table those updates do not flow into BI. This is making the data out of sync between Source (i.e. EBS) & BI environments.

  1. What is the reason for not including the GL_JE_HEADERS & GL_JE_LINES table in the CDC logic?
  2. Is there is a patch that needs to be applied in either EBS / BI environments to fix this issue?

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