Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Query to get PO Change History details which have Been Purged.

in Reporting and Analytics for SCM 2 comments

Summary:

There is a requirement by the business to fetch the details of the archived history for POs

Content (please ensure you mask any confidential information):

To replicate the issue: click on any one of the below: "Submit Purchase Order Approval"

The user is getting the following message:

They want to fetch such PO change history details via BIP reporting.

I have come across a document provided by Oracle: Doc ID 2798990.1

If anyone has the joins using all such tables to get the desired result, then it would be really helpful.

Thanks in advance,

Abhijeet

Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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