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

Requisition Approval History Query

in Self Service Procurement

For business audit purpose. We built a data extract query to extract requisition approval history using the below join. However, we noticed that for few PRs the APPROVAL_INSTANCE_ID information is not available in the fnd_bpm_task_history_b table i.e. the query does not return any records. We are using the BPM table to get the 'assignment_context' which give the information about what rule was triggered. For these missing PRs we do see the details in document history about who approved the transaction.

So, we are unable to get the full data. Any insights on how we can mitigate this? Is this an oracle bug? Is there any other way we can get this information? PO_ACTION_HISTORY only provides the approval history I believe, we want to see the approval rule that got triggered.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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