After the organizations which are to be planned are setup in VCP, the next step is to run Collections.
Collections
The process of getting data from source instance to Destination Instance (VCP) is called as Collections Process.
Collections process can be invoked by a request set by name - Planning Data Collection
There are two steps involved in collections process. Each step below will be discussed in detail.
A) Planning Data Pull
1) Refreshes the snapshots on Source Instance
2) Puts data into the staging tables of VCP.
B) Planning ODS Load
1) Performs validations on the staging tables data and inserts the data into the base tables of VCP.
2) Purges the staging table data.
Functional Details
Navigation - Service Supply Chain Administrator --> Collections --> Oracle Systems --> Standard Collection
Some of the entities that collections process brings in to VCP.
Bill of Materials (BOM), Routings, Calendars, Items, Supersession chians of the items, On Hand inventory details,Planners, Purchase documents, Sales Orders, Reservations, Suppliers, Customers, Organizations, Subinventories, Sourcing Rules, Shipping Methods,Currency conversion details, External/Internal Repair Orders, WIP orders, Install Base under contracts, Notes (Supersession notes details)
Technical Details
For each of the source instance, all the collected entities are stored in base tables of VCP with 'Plan_id = -1'
Collections
The process of getting data from source instance to Destination Instance (VCP) is called as Collections Process.
Collections process can be invoked by a request set by name - Planning Data Collection
There are two steps involved in collections process. Each step below will be discussed in detail.
A) Planning Data Pull
1) Refreshes the snapshots on Source Instance
2) Puts data into the staging tables of VCP.
B) Planning ODS Load
1) Performs validations on the staging tables data and inserts the data into the base tables of VCP.
2) Purges the staging table data.
Functional Details
Navigation - Service Supply Chain Administrator --> Collections --> Oracle Systems --> Standard Collection
Some of the entities that collections process brings in to VCP.
Bill of Materials (BOM), Routings, Calendars, Items, Supersession chians of the items, On Hand inventory details,Planners, Purchase documents, Sales Orders, Reservations, Suppliers, Customers, Organizations, Subinventories, Sourcing Rules, Shipping Methods,Currency conversion details, External/Internal Repair Orders, WIP orders, Install Base under contracts, Notes (Supersession notes details)
Technical Details
For each of the source instance, all the collected entities are stored in base tables of VCP with 'Plan_id = -1'
