Oracle Solution for Error ora-24796

ORA-24796: operation completed; resume of original transaction rolled back

What triggered the Error:

e commit, rollback, or prepare completed successfully, but the current transaction for this thread was rolled back.

What should we do to fix it:

desired, retry the current transaction. If the operation was prepare, then end transaction appropriately with a commit or rollback operation.