select * from dba_2pc_pending;

[marist89]

login as sys and
exec dbms_transaction.purge_lost_db_entry('the_local_tran_id');
or
exec dbms_transaction.purge_lost_db_entry('5.75.38968');