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 18.104.22.168.0 to 22.214.171.124.2 [Release 12c]
Information in this document applies to any platform.
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"
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