My Oracle Support Banner

Transaction is Committed Even Though IKM Commit Option Set to False in ODI 12.2.1.x (Doc ID 2233753.1)

Last updated on APRIL 16, 2019

Applies to:

Oracle Data Integrator - Version 12.2.1.0.0 to 12.2.1.3.2 [Release 12c]
Information in this document applies to any platform.

Symptoms

A transaction is committed in the ODI 12.2.1.x although the IKM COMMIT option is set to FALSE. This works correctly in ODI 12.1.3.

For instance, in a mapping which is using IKM Oracle Incremental Update and setting option COMMIT=FALSE and including this mapping as part of a package, if for some reason the package doesn't complete successfully, the transaction is expected to rollback when COMMIT=FALSE. On the other hand, if the COMMIT=TRUE then the mapping result is kept regardless of package failure. 

In 12.2.1.x COMMIT=FALSE is ignored and the transaction is committed.  

This issue varies depending on the type of IKM, and it has been confirmed for the IKM Oracle xxxx:
"IKM Oracle Control Append"
"IKM Oracle Incremental Update"

 

Changes

 

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!


In this Document
Symptoms
Changes
Cause
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.