SQL Query to Retrieve List of Failed Approval Transactions

SELECT d.*
-- Alternatively, include specific columns for clarity:
-- h.transaction_id, d.state, d.status, h.module_identifier, h.creation_date
FROM HRC_TXN_HEADER h,
     HRC_TXN_DATA d
WHERE h.transaction_id = d.transaction_id
  AND h.transaction_id = 300000030249806;

SELECT d.*, h.transaction_id, h.module_identifier, h.creation_date
FROM HRC_TXN_HEADER h,
     HRC_TXN_DATA d
WHERE h.transaction_id = d.transaction_id
  AND d.state = 'ERROR';

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.