Change Orders in Oracle Fusion Purchasing (Part -3) Tables and Data Model

 

DATA MODEL for Oracle Fusion Purchasing Change Order

The following summarizes the tables where related data is stored, with each row showing how a common set of data can be located in several tables depending on its state. 

Change Order (Draft) Table	Approved Transaction Table	Archive Table
PO_HEADERS_DRAFT_ALL	PO_HEADERS_ALL	PO_HEADERS_ARCHIVE_ALL
PO_LINES_DRAFT_ALL	PO_LINES_ALL	PO_LINES_ARCHIVE_ALL
PO_LINE_LOCATIONS_DRAFT_ALL	PO_LINE_LOCATIONS_ALL	PO_LINE_LOCATIONS_ARCHIVE_ALL
PO_DISTRIBUTIONS_DRAFT_ALL	PO_DISTRIBUTIONS_ALL	PO_DISTRIBUTIONS_ARCHIVE_ALL
PO_GA_ORG_ASSIGN_DRAFT	PO_GA_ORG_ASSIGNMENTS	PO_GA_ORG_ASSIGNMENTS_ARCHIVE
PO_NOTIFICATION_CTRL_DRAFT	PO_NOTIFICATION_CONTROLS	PO_NOTIFICATION_CTRL_ARCHIVE

How data is moved from one table to the next is explained below.

Transaction Tables

These are the normal tables that capture the data of purchase documents. The data in these tables is not updated until the Change Order is completely Approved (and Acknowledged where required).

Draft Tables

Each transaction table has its corresponding draft table that captures the Change Order data. The draft table will contain all columns in the transaction table (except for the system maintained attributes). 
When change order is approved, the changes will be copied over to the transaction table.
Each Change Order is identified by Change Order Number. The system tracks the sequence of the change orders for a document by a column called Change Order Sequence.
This starts from 0 for initial version of the document, and is incremented by 1 every time a new change order is created.

Archive Tables

These store the history of the purchase document. In E-Business Suite an archive happens whenever a new revision is approved (if archive level is set to Archive on Approval) or communicated
to the supplier (if archive level is set to Archive on Transmission). In Fusion Procurement, except for the initial version of the document, it will be the Change Order document that gets archived.
Archiving happens in the following cases:

• When the initial version of the document gets approved.
• When a change order is approved.
• When a change order is canceled (i.e., the changes are discarded). This is to keep track of all the changes done on the document even if the change is not implemented.