Validate transaction console complex triggered approval rule on a completed transaction.

Summary:

I'm looking to review completed transactions details to see that the correct approval rule has been triggered in the change salary transactions we have had submitted. Due to our rules being created in the BPM worklist the functions are too complex to show which rule triggered in the TXNDiagnositcReport, I've also run the "Fetch Transaction Details" Diagnostic and it says "None of the rules got triggered for this transaction. Please check the error details."

I've been advised via an SR that I can get this detail from back end tables and  logs;

- select * from fusion.hrc_txn_header where transaction_id IN ('<txn_id>');