'ORA-00979' when Using the ODI CDC (Journalization) Feature with Knowledge Modules Including SQL Aggregate Functions
(Doc ID 424344.1)
Last updated on NOVEMBER 21, 2023
Applies to:Oracle Data Integrator - Version 3.2.03.01 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.
After having successfully tested an Oracle Data Integrator (ODI) Integration Interface / Mapping using an aggregate function such as MIN, MAX, SUM, it is necessary to set up Changed Data Capture operations by using Journalized tables.
However, during execution of the Integration Interface / Mapping to retrieve only the Journalized records, problems arise at the Load Data step of the Loading Knowledge Module and the following message is displayed in ODI Log:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!