My Oracle Support Banner

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

Last updated on JANUARY 27, 2020

Applies to:

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




Goal

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.

Solution

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
Goal
Solution
References

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