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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Want to know tables that store PO and Agreement Change Order history details

edited May 30, 2024 8:19PM in Purchasing 8 comments

Summary:

Want to know tables that store PO and Agreement Change Order history details.

Content (please ensure you mask any confidential information):

I am working on report where i need to show count of Change Orders created per day for POs and BPAs. I have verified PO_VERSIONS and PO_HEADERS_ARCHIVE_ALL tables and they are not covering all change orders. Please advice.

PO_VERSIONS has only Change Orders which resulted into a Revision change.
PO_HEADERS_ARCHIVE_ALL is not showing all Change Orders i can see difference or jump in 'FROM_CO_SEQ' column for POs.

I can see OTBI Subject Area# "Purchase Order Implemented Change Orders Header Detail" covering all the Change orders. But i want to know the tables, so that i can create BIP report.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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