Oracle Error ORA-02058: no prepared transaction found with ID string

Oracle Error Message

ORA-02058: no prepared transaction found with ID string

Reason for the Error

no transaction with local_tran_id or global_tran_id found in the pending_trans$ table in prepared state.

Solution

check the pending_trans$ table.