Role Name: Oracle EBS / Oracle Cloud WMS Functional-Technical Consultant
Work site: Albany NY, US (Onsite)
Contract: 12 Months
Oracle EBS / Oracle Cloud WMS Functional-Technical Consultant
We are looking for a Functional SME with deep expertise in Oracle EBS R12 and Oracle Cloud WMS who can design end-to-end business process flows, particularly across Inventory, Order Management, Lot Control, Cycle Counting, and Outbound Allocation processes. The ideal candidate should possess a working knowledge of Oracle Integration Cloud (OIC) and be able to collaborate effectively in integration design and troubleshooting activities.
Mandatory Technical Skills
Minimum 7+ years of hands-on Oracle EBS technical and functional experience
Strong expertise in Oracle EBS modules: Inventory (INV), Order Management (OM), Purchasing (PO), and WIP/BOM including configuration and extensions
Proficiency in PL/SQL development (packages, procedures, functions, triggers)
Experience with Oracle EBS Open Interfaces and standard APIs
Hands-on experience with FBDI templates and flat-file integrations
Working knowledge of Oracle Integration Cloud (OIC) integration design reviews, payload validation, defect triaging, and EBS adapter support
Experience consuming REST/SOAP web services within EBS
Functional SME Expertise (Required)
Ability to serve as a Functional SME for Oracle EBS R12 and Oracle Cloud WMS implementations and enhancements
Strong experience in designing and documenting end-to-end EBS/WMS business process flows
Deep functional knowledge of:
Inventory Management
Order Management (OM)
Lot Number Control
Lot Status Management
Cycle Counting
Outbound Allocation and Fulfillment Processes
Thorough understanding of process integration and transaction flows between Oracle EBS R12 and Oracle Cloud WMS
Working knowledge of Oracle Integration Cloud (OIC) to participate in integration design discussions, process mapping, troubleshooting, and solution reviews
Advanced OIC development skills are not mandatory; however, the resource must be able to collaborate effectively with technical integration teams
Preferred Qualifications
Oracle Certified Professional (OCP) in Oracle EBS
Experience supporting Oracle Cloud WMS / SCM Cloud integrations in an EBS environment
Exposure to GxP-regulated environments (validation protocols, IQ/OQ/PQ, 21 CFR Part 11 compliance)
Familiarity with Oracle WMS Cloud data model and transaction flows