Oracle Solution for Error ora-24780

ORA-24780: cannot recover a transaction while in an existing transaction

What triggered the Error:

attempt was made to commit or roll back a transaction while in a different transaction, and the transaction for which the action is requested is in a recovery state (this happens if it is idle too long).

What should we do to fix it:

tach from the current transaction and retry the operation.