Oracle Solution for Error ora-02067

ORA-02067: transaction or savepoint rollback required

What triggered the Error:

A failure (typically a trigger or stored procedure with multiple remote updates) occurred such that the all-or-nothing execution of a previous Oracle call cannot be guaranteed.

What should we do to fix it:

rollback to a previous savepoint or rollback the transaction and resubmit.