How To Terminate An Instance After A Transaction Rollback And Return Response To Caller (Doc ID 2449249.1)

Last updated on AUGUST 16, 2024

Applies to:

Goal

There is a requirement to roll back the transaction in an Async process in case there are any business exceptions.

This article describes the use case and provides a solution:  https://blogs.oracle.com/integration/how-to-terminate-an-instance-after-transaction-rollback-and-return-response-to-caller
 
This solution works well in 11g, however in 12c  the instance is aborted, but the overall status of Flow is marked in Recovery.

Solution

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