Oracle Transactional Business Intelligence

Products Banner

How to create a report containing past, current and future approvers of purchase requisitions?

Received Response


I would like to create a report with the summarized version of Purchase Requisition's Action Detail that contains all the stages and participants/approvers from start to end of the approval flow, for all pending PRs.

Content (required):

I am considering using PO_ACTION_HISTORY and WFTASK tables to get the past and current approvers, but could not find the table for future approvers of purchase requisitions. What table can provide the future approvers of purchase requisitions?

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

Oracle Cloud Application 21B

Code Snippet (add any code snippets that support your topic, if applicable):