Fusion: SQL Script to Clear Pending Transactions

The SQL script is below and literally just sets the PENDING transaction to ABANDON to clear the pending status of it. See below for script.

SET VERIFY OFF
WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR EXIT FAILURE ROLLBACK;

UPDATE fusion.hrc_txn_data
SET status = 'ABANDON'
WHERE transaction_id IN (300000016372312);

COMMIT;