BIP Report Assistance - Transaction Console with Approvers (Job Requisition)
Summary:
Looking for assistance with creating a BIP report to audit pending actions from the Transaction Console.
I found most of the information needed in the following tables:
HRC_TXN_HEADER
HRC_TXN_CONSOLE_ENTRY
When researching in the community I've read that you can pull the approver information from FA_FUSION_SOAINFRA.WFTASK and to link the tables from FA_FUSION_SOAINFRA.WFTASK.IDENTIFICATIONKEY to HRC_TXN_HEADER.TRANSACTION_ID.
However, when doing this I am getting no results. (There are values for other transactions, just not for the Job Requisition approvals. So it doesn't look like it is an access issue?).