Tuesday 22 March 2016

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.


Setting Up ASCP


Hardware configuration:
The first step in the setup process is to decide on the overall hardware configuration and this depends totally on the volume of data which is the system going to process and plan.

We can also call it as Centralized and De-centralized based on the EBS and VCP box whether lying on same box or different boxes.

One-Machine Implementation:
Two-Machine Implementation:




Three-Machine Implementation:


Four Machine Implementation:




Process related in setting up Source and Destination Instances:







Setup Steps for the Source:

  1. Install the required patches on the source instance.
  2. Create database link on the source instance which would connect to the planning instance, later this database link will be used during setting up instances in planning server.
            Profile Option Name : MRP: ATP Database Link
  1. Create Advanced Supply Chain Planner responsibilities in the source instance
             related to the collections process.
  1. Run the Create Planning Flexfields in source instance through Advanced Supply Chain Planner responsibility.
           The Create Planning Flexfields concurrent program creates new segment definitions
            in existing descriptive flexfields to hold data that may be required for constrained
            and/or optimized planning. The program also populates profile values with the
            value corresponding to the descriptive flexfield attribute number for each attribute
            (planning parameter) created.
  1. Execute the refresh snapshot Advanced Supply Chain Planner.

Setup Steps for the Destination:

  1. Install the destination patches on the destination instance.
  2. For the Source instance connection, create a database link pointing to each source, this will be given in instance setups.
  3. Define the source instances in MSC Instances.
  4. Also setup the organizations in the source instance setups for which planning is required. Note : make sure to add the Master Organization.
  5. Run the Collections.




Business Flows in ASCP


Business Data Flow in ASCP