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

Joan Fabi

Summary:

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):

Mahendran

Hi,

I too have the same requirement,Please provide your inputs how to achieve this requirement

mohamed_shahud

Any update?

PareshSharma

Have you checked the role_code column for the approver present under po_action_history?

mohamed_shahud

@Paresh Sharma I can see the role_code. It shows data too. But how to associate that to a particular supervisor / HOD?

PareshSharma

Hi could you please share any ex. of the Purchase requisition approval page and provide some additional screenshots to understand the exact requirement?