Error: 12069 - OCITransRollback failed with ORA-1013 (4284947)

Blocking on STP

Event_log output

Error: 12069 - OCITransRollback failed with ORA-1013. [sp_opst(osp)/9211]
 Internal error: Error rolling back transaction for session 5: ORA-01013: user requested cancel of current operation.

OPO output

24708 1 Blocked on table "schema"."table_name" at session 5
24708 1 blocking sid = 8672
24708 1 blocked waiting on external sid 8672
24708 1 sigalrm
24708 1 Blocked on table "schema"."table_name" at session 5

1) The OPO output shows that the session is being blocked by the the sid 8672

2) Check the target database  for information on  sid 8677. You are checking to see if it's a session that can be cancelled, such as user or       application DML.

kill the oracle session and the post queue should start moving again.

Please also see Solution SOL17443 as well.