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|
How data is moved from one table to the next is explained below.
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).
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.
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.