Oracle EBS Technical Consultant SCM

Experience Required: 5+ Years

Role Overview

We are looking for a seasoned Oracle EBS Technical Consultant with strong expertise in RICEW (Reports, Interfaces, Conversions, Extensions, Workflows) to support a complex Oracle EBS R12.2.x environment. The role will focus on implementation of specific changes on SCM processes - P2P and O2C. This is a hands-on technical role, requiring deep skills in PL/SQL, Oracle APIs, debugging, and working with cross functional teams to address changes in business-critical processes.

The ideal candidate will be well-versed in end-to-end technical architecture, low level design, and implementation, with the ability to resolve complex issues.

Key Responsibilities

• Design, development and testing of custom RICEW components across SCM (Order Management, Inventory, Procurement, WMS)
• Troubleshoot and fix issues in:
• Custom Interfaces with OMS, WMS.
• Extensions using PL/SQL packages, Forms Personalization, OAF.
• Investigate data discrepancies, integration failures, and custom code bugs using PL/SQL, logs, and debug tools.
• Analyze and change custom APIs, triggers, procedures, and views.
• Monitor and improve performance of custom code through AWR/ASH analysis, SQL tuning, and indexing strategies.
• Collaborate with functional consultants to understand business impact and translate into technical resolution steps.
• Maintain and enhance documentation for custom components and their dependencies across business flows.
• Manage inbound and outbound integrations with OMS, WMS.
• Document all changes; ensure version-controlled, audit-ready artifacts.

Mandatory Qualifications

• Deep hands-on experience in:
• PL/SQL, SQL, APIs (standard & custom)
• Oracle Reports, BI Publisher
• Oracle Forms, Oracle Workflow
• OAF (Oracle Application Framework), ADF (preferred)
• Strong understanding of EBS data models across:
• SCM: Order to Cash, Procure to Pay, Shipping, Inventory, BOM, WMS
• Experience with file-based interfaces (CSV/XML/Flat Files), FTP/SFTP, SOAP/REST APIs
• Experience with middleware like Oracle SOA Suite & Boomi for integration

Business & Domain Exposure

• Strong understanding of EBS data models and transaction flows in:
• Order to Cash, Procure to Pay, Inventory & WMS
• Functional awareness to interact effectively with business/functional teams
• Knowledge of multi-org, localization, and multi-currency setups