You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
11
Views
1
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!