0% found this document useful (0 votes)
305 views2 pages

ASCP Collection Methods

There are three methods for collecting data into Oracle Advanced Supply Chain Planning (ASCP): complete refresh, targeted refresh, and net change refresh. Net change refresh only imports changes since the last refresh and supports over 40 different planning objects. Continuous collection runs targeted or net change refresh based on a threshold, while legacy collection imports non-Oracle ERP data from flat files or staging tables using provided templates.
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
305 views2 pages

ASCP Collection Methods

There are three methods for collecting data into Oracle Advanced Supply Chain Planning (ASCP): complete refresh, targeted refresh, and net change refresh. Net change refresh only imports changes since the last refresh and supports over 40 different planning objects. Continuous collection runs targeted or net change refresh based on a threshold, while legacy collection imports non-Oracle ERP data from flat files or staging tables using provided templates.
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Oracle ASCP Collection Methods: There are three ways data can be collected into Oracle ASCP or APS

or Value Chain Planning suite.

1) Standard Collections:

Complete Refresh: In this all existing collected data will be purged and new data is imported. Targeted Refresh: Similar to Complete Refresh but for each object. You can selectively choose which objects require completed refresh, only those targeted objects will be refreshed. Net Change refresh: Imports only the changes that happened since last refresh. This methods work for supply / demand changes.

Objects supported under Net change mode.


Sales Orders Reservations Master Production Schedules demands Master Demand Schedules demands WIP Component Demands WIP repetitive item demands Forecast demands User demands Master production schedule supplies User supplies Purchase Order Supplies On-hand supplies Work orders in Oracle WIP Resource availability Supplier capacity Bill of Material Routing Operations Components needed for Routing Resources attached to Routing Resource requirements for WIP Jobs Resources for WIP Jobs Items Item categories Capacity

Not supported objects for Net change Method


Category sets Default item category

Simulation sets Department resources Resource shift setup Hard reservations Projects or project tasks UOM Sourcing rules Bills of Resources Calendars Shipping networks Parameters Planners Suppliers Resource groups Demand classes Available To Promise rules Trading Partners

2) Continuous Collections:
Continuous collections systematically decides whether to run targeted refresh or net change based on a given threshold value (parameter). It runs based on snapshot data.

3) Legacy Collections:
This method is useful to import data from non-oracle ERP systems. Data is imported from flat files or from staging tables. Oracle provides the templates for each data/transaction objects, if data uploaded in that format, oracle imports data into planning server.

You might also like