Scribd
Upload
561 views5 pages

Oracle ASCP Data Collection Overview

Oracle ASCP is a planning engine that analyzes demand data, processes it based on defined conditions, and recommends supply sources to meet that demand within a single optimized plan. It can plan for both short-term and long-term horizons. Data is collected from various sources and loaded into staging tables, then an operational data store, and finally the planning data store. Recommendations are then reviewed and released as requisitions, jobs, or purchase order reschedules. Data can be collected via complete refresh, net change refresh, targeted refresh, or continuous collection depending on the needs.

Uploaded by

sajeedmujawar
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 PDF, TXT or read online on Scribd
561 views5 pages

Oracle ASCP Data Collection Overview

Oracle ASCP is a planning engine that analyzes demand data, processes it based on defined conditions, and recommends supply sources to meet that demand within a single optimized plan. It can plan for both short-term and long-term horizons. Data is collected from various sources and loaded into staging tables, then an operational data store, and finally the planning data store. Recommendations are then reviewed and released as requisitions, jobs, or purchase order reschedules. Data can be collected via complete refresh, net change refresh, targeted refresh, or continuous collection depending on the needs.

Uploaded by

sajeedmujawar
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 PDF, TXT or read online on Scribd
You are on page 1/ 5

Understanding Oracle ASCP - Data Collections -

Oracle ASCP - a snapshot


Planning engine that looks at your demand, processes the information based on certain pre-defined conditions and suggests the supply sources Within a single plan, users can perform detailed planning for short-term and aggregate planning for long-term Can be configured to optimize in specific business environment based on resource and material constraints

Items, BOMs, Routings, Sales Orders, Forecasts

(ADS)

Planning Data Pull loads data in Staging tables

Planning ODS load brings in data in Operation Data Store

Plan run loads data in Planning Data Store

Recommendations are reviewed and released

Requisitions, Discrete Jobs, Reschedule POs, Jobs, Requisitions

Inputs to ASCP engine


Sales Order demand Order Management Inventory

WIP/OSFM/OPM Existing supply DP/Demantra Purchasing Forecas t demand Planning Engine Item/ BOM/ Sourcing Data Collection

Routing/ Resources

Data collection modes


Complete Refresh
Clears all data from the planning server and then copies over information.

Net Change Refresh


Copies only incremental changes to business entities

Targeted Refresh
Clears transaction data for only the user-selected business entities and then copies the entity information over from the transaction instance

Continuous Collection
Automatic selection of mode of collection for each entity New data for each entity > threshold = Targeted refresh New data for each entity < threshold = Net Change refresh No change in data = No collection for that entity

Legacy Collection

Thank you for viewing. It shall be a pleasure to hear from you !!

About the Author


SAM has been working on ERP solutions such as Oracle Applications & Microsoft Dynamics in Implementation & support for past 13 years. Worked with clients in various industry verticals such as manufacturing, distribution, education, construction, professional services, hospitality and aviation across geographies

If you would like to join our panel of authors to share your knowledge on areas of your expertise, please do write to us on [email protected]

You might also like