Oracle ASCP Techno-Functional Consultant

Candidates who receive an offer will be required to successfully complete a background check and drug test as a condition of employment.

Role: Oracle ASCP Techno-Functional Consultant
Remote
5 Months+

Primary Skills: Oracle EBS, ASCP, Supply Chain Planning, SQL/PLSQL
Summary
We are looking for an experienced Oracle ASCP Techno-Functional Consultant with approximately 10–12 years of Oracle EBS Supply Chain experience, including strong hands-on expertise in Oracle Advanced Supply Chain Planning (ASCP). The consultant will be responsible for supporting, enhancing, and troubleshooting Oracle ASCP solutions, working closely with business planning, supply chain, manufacturing, and IT teams. The ideal candidate should combine strong knowledge of supply chain planning processes with the technical ability to analyze planning data, integrations, customizations, and underlying Oracle EBS tables.

Key Responsibilities

• Provide techno-functional support for Oracle EBS ASCP and supply chain planning processes.

• Work with business teams to understand requirements related to demand planning, supply planning, material planning, capacity planning, and inventory planning.

• Configure and support ASCP plans, plan options, collections, sourcing rules, assignment sets, calendars, resources, and planning parameters.

• Analyze ASCP planning results and troubleshoot issues related to planned orders, demand-supply pegging, planning exceptions, forecast consumption, lead times, and capacity constraints.

• Support make/buy decisions, sourcing strategies, safety stock, replenishment, and planned purchase requisitions.

• Perform technical analysis using Oracle SQL and PL/SQL to investigate planning data and resolve system issues.

• Troubleshoot ASCP collections, data synchronization, and integration issues across Oracle EBS modules.

• Support integrations, custom reports, interfaces, conversions, extensions, and concurrent programs.

• Collaborate with functional, technical, DBA, infrastructure, and integration teams to resolve complex issues.

• Participate in SIT, UAT, regression testing, and production validation.

• Provide production support, perform root cause analysis, and drive issues through resolution.

Required Skills & Experience

• 10–12 years of overall Oracle EBS Supply Chain experience.

• Strong hands-on experience with Oracle Advanced Supply Chain Planning (ASCP).

• Strong techno-functional expertise in Oracle EBS R11/R12.

• Good understanding of:

  • Demand and supply planning

  • Forecasting and forecast consumption

  • MRP/MPS concepts

  • Supply-demand balancing

  • Inventory and replenishment planning

  • Bills of Materials (BOM) and Routings

  • Manufacturing and capacity planning

  • Sourcing rules and lead-time calculations

  • Purchasing and procurement

• Experience with Oracle EBS modules:

  • Inventory (INV)

  • Bills of Material (BOM)

  • Work in Process (WIP)

  • Purchasing (PO)

  • Order Management (OM)

• Strong experience with ASCP collections and planning-data troubleshooting.

• Ability to analyze ASCP plan outputs, exceptions, pegging, and demand-supply data.

• Hands-on expertise in Oracle SQL and PL/SQL.

• Experience analyzing Oracle EBS base tables, interface tables, concurrent programs, logs, and data issues.

• Experience supporting Oracle EBS interfaces, conversions, extensions, and custom reports.

• Strong production support and root cause analysis experience.

Preferred Skills

• Experience working in large-scale manufacturing or distribution environments.

• Experience with Oracle EBS implementations, upgrades, rollouts, and enhancement projects.

• Exposure to integrations with external planning, manufacturing, warehouse, and supplier systems.

• Knowledge of Oracle APIs and open interfaces.

• Familiarity with XML Publisher, BI Publisher, Oracle Forms, and Reports.

Metasys Technologies is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identify, national origin, veteran or disability status.