My Oracle Support Banner

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

Last updated on DECEMBER 23, 2019

Applies to:

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


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 OBIA. 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 / OBIA environments to fix this issue?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.