Rollback Behaviour With Multiple, Nested EAI Transacton Service Calls (Doc ID 1075720.1)

Last updated on APRIL 04, 2025

Applies to:

Goal

Customer scenario is that a top level Workflow Process is invoked, which calls the EAI Transaction Service to begin a transaction. Within this Workflow, several other sub processes are called, each also with EAI Transaction Service calls to start new transactions (BeginTransaction) and commit (EndTransaction).

Expectation was that when a failure occurred in the top level Workflow, a rollback (EndTransaction, Is Abort=true) would undo all updates previously made in that Workflow. But this was not happening - the previous updates made in the top level Workflow were committed regardless.

Solution

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