Transaction Console Job Requisition approval chain report

Summary:

The user can't access the transaction console and through administrative tasks in BPM, they can see only their job requisition.

We need a report to see the approval chain for a job requisition

Content (please ensure you mask any confidential information):

Report to see the approval chain for the job requisition.

It seems we have some populated attributes inside the table HRC_TXN_DATA, however, we haven't found a join to see the user who is assigned the req.

Version (include the version you are using, if applicable):

24 B

We can see the approval chain through the transaction console and BPM with admin access, however, the user can't have those privileges in their role, so we need a report to see the approval chain for the job requisition