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

Need to fetch Transaction approver start date and the next level approver details

Summary:

We have a requirement to fetch the date the transaction was assigned to each level of approver and also the next level approver details. This is applicable for all transactions

Content (please ensure you mask any confidential information):

Transaction have multiple levels of approval, 
we are only able to retrieve information about past and current approvers from the workflow and BPM tables history tables. 
However, we are unable to obtain details about future approvers. 

Also, FND_BPM_TASK_HISTORY_B table contain same initiation date for different approvers(at different levels) for a particular transaction. The completion date reflects the actual completion date by each approver for that transaction.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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