Standard Collections in ASCP

Standard Collections

Oracle ASCP Standard Collections collects the data to be planned is from the transaction instance(s) to the planning server via a process called Collection.

Data Classification in Collection process:

Oracle Applications Data Store (ADS): 

The set of source data tables in each transaction instance that contain data relevant to planning.

Operational Data Store (ODS): 

The planning data tables in the planning server that act as destination for the collected data from each of the data sources (both ADS and Legacy).

Planning Data Store (PDS): 

The outputs of the planning process. The PDS resides in the same data tables as the ODS. However, PDS data are marked with plan IDs that show which plans they correspond to, while ODS data are marked with plan ID = -1.

The two types of collections process are standard and continuous :- 

• Standard collections process: Using the standard collections process, you can

manually run three types of collection methods including a complete refresh, a net

change refresh, or a targeted refresh on specific business entities.

• Continuous collections process: The continuous collections process is an automated

process of data collection that efficiently synchronizes the data on the planning

server by looking up the sources. If you opt for continuous collections, the system

automatically determine the type of collection that needs to be run on entities

selected by you. The continuous collections process collects data from the sources

with the least user intervention. The Continuous Collections concurrent program

performs continuous collections.

There are three collection methods:

• The Complete Refresh method clears all transaction data for all business entities from the planning server (for the source instance being collected), then copies over information about the user-selected entities. This method can be time consuming.

• The Targeted Refresh method clears transaction data for only the user-selected business entities from the planning server, and then copies the entity information over from the transaction instance. Information about unselected entities remains intact on the planning server. All planning business entities are supported by Targeted Refresh collections. When running targeted refresh for entity Trading partners, also collect entity Calendars. This ensures that the Oracle Project Manufacturing organizations are set up as organization type process so that the release process from Oracle Advanced Supply Chain Planning to Oracle Project Manufacturing succeeds.

• The Net Change Refresh method copies only incremental changes to business entities to the planning server (and is thus faster), but is supported mainly for demand and supply business entities only.

Staging Tables in VCP:

During collection process, Oracle first refreshes the snapshot on the EBS instance. 

Then the Planning Data Pull refreshes the st (staging) tables in ASCP.  The tables are too many to list but their names have st in it.

e.g. msc_st_system_items , msc_st_boms 

You can find them by

SELECT * FROM all_tables WHERE owner = 'MSC' AND table_name LIKE 'MSC_ST_%' order by 2

The Planning ODS Load processes the ST tables and loads into the MSC tables.  

Typically, the destination table name is similar to the st table (except for _st)

e.g. msc_st_system_items => msc_system_items 

msc_st_boms => msc_boms

etc.

Navigations to Run Collection programs in ASCP:

Enter the required parameters and submit the program. Check the staging and base tables in ASCP.

Planning data should be stored as plan_id = -1 in all the MSC tables.