My Oracle Support Banner

'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.

Symptoms

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:

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.