ASCP - 101
A Beginners Guide to Implementing ASCP
Sandeep Gandhi Independent Consultant
Agenda
Scope ASCP v/s MRP ASCP Data Flow Setups Item Attributes Plan Options Execute Plan Q&A
2
Advanced Supply Chain Planning
Oracle Advanced Supply Chain Planning (ASCP) is a comprehensive planning solution that decides when and where supplies should be deployed within an extended supply chain.
Key Capabilities
Plan all supply chain facilities simultaneously Short-term detailed scheduling and long-term aggregate planning are supported within a single plan Plans that consider both resource and material constraints Configure Oracle ASCP to optimize specific business criteria Allows many types of changes to supply, demand and resources to simulate changing business conditions Integrated solution
3
ASCP v/s MRP
Oracles focus product Productivity enhancing UI
Plan alt. sources and alt. resources Plan with optimization rules (inv turns / ontime delivery) and penalty factors Constrained plan (ECC / EDD / lead time constraints) VMI Support New reports Powerful simulations Different calendars for shipping / manufacturing / receiving Multiple instance planning
4
QOH shown in supply/demand screen Multi-level pegging Ability to define queries and publish to planners Vertical Plan / Gnatt Chart
ASCP Data Flow
Application Data Store (ADS) Items, BOM, Routing, Sales Orders,MDS, Forecast, Inventory Planning ODS Load Operation Data Store (ODS) Cleaned up Operation Data Store (ODS) Planning Data Store (PDS)
Planning Data Pull
Staging tables
Custom programs
Plan Run
C re
ate Re Requ sch i si t edu ions le P / D O / R i scr eqs ete /Jo Job bs s
le Re
a se
m e co
me
a nd
tion
WIP Mass Load / Requisition Import / Reschedule PO / Reschedule Requisitions
Initial Setups
Decide configuration Centralized v/s Distributed
Apply latest Rollup Collections RUP #25 (patch Patches #6751704) (Note 223026.1) Planning Engine RUP #30 (patch # 7286961) Get Advanced Supply Chain responsibilities Planner Advanced Planning Administrator
Initial Setups Contd.
Define Instance
Define Orgs Assign Collection Groups
Initial Setups contd.
Run full data collection
Initial Setups contd.
Gather schema stats on MSC Grant Org access
Key Item Attributes
10
Key Item Attributes Contd.
11
Collecting Sales Orders
Define Demand class Define Master Demand Schedule (MDS) Refresh MDS
12
Define Plan
13
Plan Options Main Tab
14
Plan Options Org tab
15
Plan Options Constraints Tab
16
Execute Plan
Refresh MDS Run Data Collection Run Custom Data Cleanup Programs Run plan Consider creating request set Access Planners workbench
17
Planners Workbench
18
Release
19
Gotchyas
Sales order demand duplicated Inactive items coming over to plan Can not release configured items Planning Data Pull very slow
ODS Load takes a long time
Run Refresh Collection Snapshots often Run Net change collection Set MSC:Purge Stg Tbl Cntrl to Yes Set MSC: Share Plan Partitions to No Set MSC:Write MBP Flat Files to Yes
Plan takes a long time to run
File space issues
Schema stats
20
Q&A
21
