My Oracle Support Banner

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

Last updated on OCTOBER 04, 2022

Applies to:

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


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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.