Transcript ASCP - 101
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 Oracle’s focus product Productivity enhancing UI QOH shown in supply/demand screen Multi-level pegging Ability to define queries and publish to planners Vertical Plan / Gnatt Chart 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 ASCP Data Flow Application Data Store (ADS) Items, BOM, Routing, Sales Orders,MDS, Forecast, Inventory Planning Data Pull Staging tables Planning ODS Load Operation Data Store (ODS) Custom programs Cleaned up Operation Data Store (ODS) Plan Run Planning Data Store (PDS) 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 R m e co me a nd tion s WIP Mass Load / Requisition Import / Reschedule PO / Reschedule Requisitions 5 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 6 Initial Setups – Contd. Define Instance Define Orgs Assign Collection Groups 7 Initial Setups – contd. Run full data collection 8 Initial Setups – contd. Gather schema stats on MSC Grant Org access 9 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 Planner’s workbench 17 Planner’s 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 Set MSC: Share Plan Partitions to No File space issues Set MSC:Purge Stg Tbl Cntrl to Yes Plan takes a long time to run Run Refresh Collection Snapshots often Run Net change collection Set MSC:Write MBP Flat Files to Yes Schema stats 20 Q&A Sandeep Gandhi [email protected] 513-325-9026 21