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 188.8.131.52 [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.
- What is the reason for not including the GL_JE_HEADERS & GL_JE_LINES table in the CDC logic?
- 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