Transaction is Committed Even Though IKM Commit Option Set to False in ODI 12.2.1.x
(Doc ID 2233753.1)
Last updated on OCTOBER 04, 2022
Applies to:
Oracle Data Integrator - Version 12.2.1.0.0 and laterInformation 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"
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 |
| Cause |
| Solution |
| References |