Oracle EBS SCM Techno-functional Consultant

Role Type: Freelancing Role

Shift Time: Rotation Timing in UK and US Hours (1:00 - 9:00 PM and 4:00 - 2:00 AM)

We are seeking an experienced Oracle EBS SCM Techno-Functional Consultant to join our global support team. This role is responsible for end-to-end incident resolution, issue triaging, defect analysis, and ensuring seamless operation of core SCM processes within Oracle E-Business Suite R12.2.x. The ideal candidate should possess deep functional process knowledge combined with strong technical troubleshooting skills, especially in complex, integrated environments involving WMS, 3PLs, and external platforms.

Key Responsibilities:

Functional Support:

Serve as the primary point of contact for Oracle SCM modules including Order Management, Inventory, Purchasing, Shipping, and Planning.

Troubleshoot and resolve functional issues such as incomplete orders, failed shipments, PO errors, and planning exceptions.

Analyze business process deviations and data inconsistencies impacting Order-to-Cash (O2C) and Procure-to-Pay (P2P) flows.

Collaborate closely with business users, planners, and fulfillment teams to provide proactive support and process continuity.

Participate in issue triage bridges, identify workarounds, and validate business-impacting fixes.

Support period-close and quarter-close operations, ensuring timely resolution of critical issues.

Technical Support:

Investigate and resolve technical issues in custom objects, interfaces, workflows, and concurrent programs.

Perform code analysis of PL/SQL packages, Oracle Forms/Reports, BI Publisher outputs, and workflows to identify root causes.

Troubleshoot SOA/OSB middleware-based integrations with external platforms such as High Jump WMS, 3PLs, B2B, and eCommerce systems.

Work with DBAs and infrastructure teams for performance tuning, concurrent request delays, and database-level investigations.

Apply approved scripts for data correction in compliance with change control policies.

Document root causes and develop knowledge base articles for repeat issue prevention.

Required Skills & Experience:

Functional Proficiency:

Strong domain knowledge in Supply Chain business processesOrder Management, Procurement, Fulfillment, Inventory, Advanced Pricing.

Familiarity with SCM setups, transaction flows, and approval of workflows within Oracle EBS.

Experience with cross-functional support (SCM-Finance-Retail) and managing upstream/downstream process impacts.

Technical Expertise:

Proficiency in PL/SQL, Oracle Reports, Forms, BI Publisher, and Workflow Builder.

Strong troubleshooting skills for customizations, interfaces, and concurrent program failures.

Experience with integration troubleshooting via SOA Suite, OSB, and file/API-based interfaces (XML, JSON, UCM).

Understanding of Oracle application architecture, concurrent manager performance, and logging/debugging tools.

Tooling & Compliance:

Hands-on experience with ServiceNow (or similar ITSM tools) for ticket lifecycle, incident, and change management.

Familiarity with ITIL processes, including Incident, Problem, and Change Control.

Comfortable working in SOX-compliant environments with strict access control and audit requirements.

Strong documentation and communication skills for global stakeholder interaction.

Mandatory Qualifications:

68 years of functional and technical experience supporting Oracle EBS SCM modules.

Strong proficiency in:

o PL/SQL, SQL

o Oracle Forms, Reports, Workflow

o BI Publisher, ADF, OAF

Hands-on experience supporting interfaces and integrations via SOA Suite, OSB, WebLogic.

Solid understanding of SCM data models and business processes (Order to Cash, Procure to Pay).

Proven ability to troubleshoot integration failures between Oracle EBS and external systems (e.g., WMS, 3PL).

Familiarity with SOAP/REST APIs, XML, and file-based integrations.

Experience in multilingual environments

Experience using ServiceNow, Microsoft Teams, and documentation platforms.