My Oracle Support Banner

Constraints on Simple Journalization and Updates of Primary Key Fields in ODI (Doc ID 424071.1)

Last updated on DECEMBER 12, 2023

Applies to:

Oracle Data Integrator - Version and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.


In Oracle Data Integrator (ODI), after having activated Simple Journalization on a Datastore, the Journal table does not appear to reflect the changes that have been applied to the Journalized Datastore.

The problem is that an application automatically updates the data of my journalized Datastores and the updates are performed on columns that compose the Primary Key of my Datastore.

As a result, the content of the Journal table is incorrect.

The Primary Key is defined in the Oracle Data Integrator (ODI) Repository and not necessarily in the database.

The article applies to all releases of ODI like the current 12C as well as to previous releases.


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.