Last updated on JUNE 11, 2015
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11 [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 BI. 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 / BI environments to fix this issue?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms