You are browsing the archive for ASCP.

Avatar of oracleguru

by oracleguru

ASCP Collection Methods

Home > Tutorial > ASCP

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.

Tags: , , , No Comments »

Avatar of oracleguru

by oracleguru

ASCP Standard Collections

Home > Tutorial > ASCP

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

Tags: , , No Comments »

Avatar of oracleguru

by oracleguru

Oracle ASCP forms

Home > Tutorial > ASCP

Oracle Advanced Supply Chain Forms:

FORM SHORT CODE ORACLE FORM NAME
MSCCHORG Change Organization
MSCFDDSR Define Sourcing Rules/Bills of Distribution
MSCFDSRA Assign Sourcing Rule/BOD
MSCFINST Define Application Instances
MSCFNSCW Planner Workbench
MSCFPCMN Define Plan Names
MSCFPPMR Define Plan Options
MSCFUDAY View Work Dates
MSCFUDPP Define Plan Parameters
MSCFVSAH View Sourcing Assignment Hierarchy
MSCFVSCB View Supply Chain Bill
MSCOSCWB ATP Inquiry
MSCSCHRS Define Priority Rules
MSC_MSCBALWB Order Backlog Workbench
MSCBALWB ORDER BACKLOG WORKBENCH
MSCPLDTL Planning Detailed Report
MSCATPSD Supply Demand
MSCFDARL Define Allocation Rule
MSCFAARL Assign Allocation Rule
MSCVWALC View Allocation
MSCCPPLN Copy Plan
MSCSLFLT Service Levels & Fulfillment Lead Time
MSCFPPSC Define Plan Options – Supply Chain
MSCFPCSC Define Plan Names – Supply Chain Plans
MSCRSPRM Resource Parameters
MSCDSPOP Define Schedule Options
MSCDSPNM Define Schedule Names
MSCITMNT Define Item Attributes Mass Maintenance for ASCP
MSCTRUPD Transportation Update
MSCFCRLS SRP Forecast Parameters
MSCFNSRP Service Planner Workbench
MSCSPPOP Define Service Plan Options
MSCSPPNM Define Service Plan Names
MSCFNSDA Supply Demand Analysis
MSCUSRGP Define SRP User Groups
MSCUPREF SRP User Preference
MSCPQLDR Define Criticality Matrix for SRP
MSCTRTIM Transit Times
MSCFNDRP Planner Workbench – DRP
MSCFPDRP Define DRP Options
MSCFPCDP Define DRP Names
MSCFSALC Supply Allocation Rules
MSCINVLV Enter Inventory Levels
MSCPRIRL Demand Type-Class Priority
MSCIOPOP Define Plan Options -Inventory Planner
MSCIOPNM Define Plan Names -Inventory Planner
MSCFBDGT Specify Budget

Tags: No Comments »