Oracle Transactional Business Intelligence
How to create a report containing past, current and future approvers of purchase requisitions?
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.
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):
I too have the same requirement,Please provide your inputs how to achieve this requirement
Have you checked the role_code column for the approver present under po_action_history?
@Paresh Sharma I can see the role_code. It shows data too. But how to associate that to a particular supervisor / HOD?
Hi could you please share any ex. of the Purchase requisition approval page and provide some additional screenshots to understand the exact requirement?