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 MAY 23, 2023

Applies to:

Oracle Data Integrator - Version to [Release 12c]
Oracle Data Integrator Cloud Service - Version 17.1.3 to 17.2.1
Information in this document applies to any platform.


A transaction is committed when executed using Oracle Data Integrator (ODI) 12.2.1.x even though 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"





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.