You are browsing the archive for ASCP.

Oracle Advanced Supply Chain Planning Overview

Oracle Advanced Supply Chain Planning (ASCP) is the main planning engine Oracle is offering, it has advanced features than the traditional MRP module. Its plans the supply (POs, Requisitions, work orders) based on demand (forecasts, sales orders).

ASCP functional features:

  • Global Planning engine: ASCP can plan one inventory organization or all inventory organizations, it can consider all inter-plant supply/demand in one process.
  • Mixed modes of manufacturing: ASCP can support discrete, process, project & flow manufacturing in one plan.
  • Detail planning: ASCP can do short-term detail planning as well long term aggregate planning in one shot.
  • Constraint based planning: Traditional MRP is unconstrained, it plans for the future and raises exceptions if there are any constraints. Constraint based planning can be done by either capacity as a constraint or meeting demand is an constraint.
  • Optimzed Planning: Based on buisness rules setup, ASCP can plan the the output to optimize the criteria given by users.
  • Multiple versions of Oracle: The planning instance support multiple source ERP instances which are running on a different versions of Oracle (R10.7, R11, R12).
  • Plan Simulations: Planners can simulate the changes and review impact without actually making the necessary changes.

Data Collections: Data collections are set of programs that collect the base data (items, boms, routings, onhands, sales orders, purchase orders etc) from source ERP instance into planning instance to perform the supply chain planning.

ASCP Collection Methods

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.

ASCP Standard Collections

ASCP Standard Collections

Oracle ASCP Collections pull the data from source (ERP) system for planning purpose. If your source system (ERP) is Oracle Apps, then out of the box collections programs will collect the data without any custom interface. Oracle ASCP supports any version (10.7, 11i, 12) of Oracle Apps ERP to collect the data. After data is collected ASCP Plan must be run with refreshed data to review the latest recommendations.

Data collections are done in two stages. During first stage (1) Data is pulled from ERP system and kept in Staging tables. During second stage (2) Data is loaded into ASCP instance.

ASCP Collections – Data Pull Parameters:

ASCP Collections - Data Pull

ASCP Collections - Data Pull

  • Instance
  • Collection group
  • Number of workers
  • Timeout (Minutes)
  • Purge previously collected data
  • Collection Method
  • Analyze Staging Tables
  • Approved Supplier Lists (Supplier Capacities)
  • ATP Rules
  • Bills Of Materials/Routings/Resources
  • Bill Of Resources
  • Calendars
  • Demand Classes
  • End Item Substitutions
  • Forecasts
  • Items
  • Key Performance Indicator Targets
  • Master Demand Schedules
  • Master Production Schedules
  • On Hand
  • Planning Parameters
  • Planners
  • PO Receipts
  • Projects/Tasks
  • Purchase Orders / Purchase Requisitions
  • Reservations
  • Resources Availability
  • Safety Stock
  • Sales orders
  • Sourcing History
  • Sourcing Rules
  • Subinventories
  • Supplier Responses
  • Suppliers/Customers/Orgs
  • Transportation Details
  • Unit Numbers
  • Units of Measure
  • User Company Association
  • User Supplies and Demands
  • Work In Process
  • Sales Channel
  • Fiscal Calendar
  • Internal Repair Orders
  • External Repair Orders
  • Payback Demand/Supply
  • Currency Conversion
  • Delivery Details

ASCP Collections – ODS Load Parameters:

ASCP Collections - ODS Load

ASCP Collections - ODS Load

  • Instance
  • Timeout (Minutes)
  • Number Of Workers
  • Recalculate sourcing history
  • Purge sourcing history
  • Refresh collected data in APCC repository