Search 800 + Posts

May 6, 2023

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) TableApproved Transaction TableArchive Table

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.

No comments:

Post a Comment