You are browsing the archive for Oracle Supply Chain Planning.

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.

Purge ODS Instance Entity data

 

NAME: Purge ODS Instance Entity data
SHORT CODE: MSCPURODSENT
MODULE: Oracle Advanced Supply Chain Planning

Description: Planning Data Pull
Navigation: Oracle ASCP Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • Instance :
  • Purge global tables :
  • Approved Supplier Lists :
  • ATP Rules :
  • BOM/Routings/Resources :
  • BOR/Bill Of Resources :
  • Calendars :
  • Demand Class :
  • End Item Substitutions :
  • Forecasts :
  • Items :
  • KPI Targets (BIS) :
  • Master Demand Schedule (MDS) :
  • Master Prod. Schdule (MPS) :
  • On Hand :
  • Planning Parameters :
  • Planners :
  • PO Receipts :
  • Projects/Tasks :
  • Purchasing Reqs (PO) :
  • Reservations :
  • Resource Avail Recalc (NRA) : Recalculate Net Resource Availavbility
  • Safety Stock :
  • Sales Orders :
  • Sourcing History :
  • Sourcing Rules :
  • Sub Inventories :
  • Supplier Responses :
  • Suppliers/Customers/Orgs :
  • Transportation Details :
  • Unit Numbers :
  • Unit of Measures (UOM) :
  • User Company Associ

 

Solve On Server

 

NAME: Solve On Server
SHORT CODE: MSCSCPSOLVE
MODULE: Oracle Advanced Supply Chain Planning

Description: Concurrent Program to Solve Models in server
Navigation: Oracle ASCP Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • SCP_PLAN_ID : Plan ID