Oracle Supply Planning Consultant/(ASCP And Demantra)/ 100 %Remote
Location: Cleveland, Ohio 44122 (100 %Remote)
Duration: 6 months
Job Title
Oracle Supply Planning Consultant(ASCP And Demantra)
Skills: Oracle Demantra Demand Management (DM) and Real-Time Sales and Operations Planning (RTS&OP)
Experience Required: 6-8
Must Have Technical/Functional Skills
10+ years of experience in Oracle ASCP and Demantra solution implementations.
Comprehensive knowledge and strong hands‑on experience with Oracle EBS R12 ASCP, Demantra, and Production Planning
Consultant must have hands-on experience in Oracle R12, gathering and documenting business requirements, analyzing and mapping business processes, provide GAP analysis and design extensions to address them, configuring above listed modules, conducting conference room pilots and end user tests, planning and executing cut-over tasks, and providing post go-live support
Good understanding of Forecasting, Demand Planning, Supply Planning processes
Experience in ASCP plan setup (Standard, Constrained/Unconstrained, Net/New) and strong knowledge of MRP, BOM, Routings, Resources, Lead Times, Planning Parameters. Experience with ASCP exceptions, planner workbench, reschedules, shortages, Collections, planning data refresh, snapshots
Good understanding of Inventory, BOM, WIP, Purchasing integration with Planning
Ability to troubleshoot forecast issues, ATP issues, plan output exceptions
Strong knowledge in Advanced Planning command Center (APCC)
Knowledge of Oracle Demantra platform, architecture, and integration capabilities
Expertise in Demantra: Demand Management, Forecasting, Worksheets, Scenarios
Workbook development (Table-based, composite, data modification, alerts, hierarchies, filters, scenario hierarchy setup, series).
Planning engine knowledge and data model modification.
Troubleshoot worksheet issues, engine errors, interface failures, and batch jobs, workflows, methods, business modeler configurations.
Good to have skills:
Experience with:
Good SQL skills for data validation and planning diagnostics
Knowledge of S&OP, DRP, constrained planning, pegging analysis
Certification in Oracle Demantra Demand Management
Experience in manufacturing and supply chain heavy environments
Work with oracle vendor for standard problems.
Roles & Responsibilities
Configure and support ASCP, Demantra integrations, and Planning flows
Manage collections, planning runs, exceptions, planner workbench
Work with Manufacturing, Purchasing, and Inventory teams on planning issues
Prepare BRD/FRD, functional specs, test scripts, UAT documents
Support testing cutover, plan migration, UAT. go‑live, and hypercare
Troubleshoot forecasting, planning output, and supply constraints
Improve planning accuracy, master data, and lead‑time settings Troubleshoot issues in:
Never miss an opportunity! Create an alert based on the job you applied for.
