Oracle EBS SCM Techno Functional Consultant & Oracle EBS SCM Techno Functional Consultant with APEX Experience

Job Title: Oracle EBS SCM Techno Functional Consultant

Location: Remote (USA)

Duration: Contract 

Job Summary

We are seeking an experienced Oracle E-Business Suite (EBS) SCM Techno Functional Consultant with strong expertise in Oracle Supply Chain Management modules and technical development. The ideal candidate will possess a combination of functional business process knowledge and technical customization experience to support implementation, enhancements, integrations, production support, and system optimization.

Required Experience

• 15+ years of Oracle EBS experience.
• 7+ years of Oracle SCM Techno Functional experience.
• Strong experience working with Oracle EBS R12.2.x.
• Experience supporting multiple end-to-end Oracle SCM implementations.

Functional Expertise

Strong experience in the following Oracle SCM modules:

• Purchasing (PO)
• Inventory (INV)
• Order Management (OM)
• Shipping Execution (WSH)
• Advanced Pricing
• Bills of Material (BOM)
• Work in Process (WIP)
• Cost Management
• iProcurement
• Supplier Management
• Procurement Lifecycle

Technical Skills

• Oracle SQL
• PL/SQL
• Oracle Forms
• Oracle Reports
• XML Publisher (BI Publisher)
• Workflow Builder
• Oracle Alerts
• Interface development
• APIs
• Open Interfaces
• Concurrent Programs
• Shell scripting (preferred)

Responsibilities

• Gather and analyze business requirements.
• Design and implement Oracle SCM solutions.
• Develop technical specifications from functional requirements.
• Build custom reports, interfaces, conversions, extensions, and workflows (RICE components).
• Develop and support PL/SQL packages, procedures, triggers, and database objects.
• Configure Oracle SCM modules according to business requirements.
• Perform data migration using Oracle Open Interfaces and APIs.
• Troubleshoot production issues and provide root cause analysis.
• Support month-end and quarter-end business activities.
• Work closely with business users, developers, DBAs, and project managers.
• Conduct unit testing, system integration testing (SIT), and user acceptance testing (UAT).
• Prepare technical and functional documentation.
• Participate in Oracle patching and upgrade activities.

Preferred Qualifications

• Experience integrating Oracle EBS with third-party applications.
• Oracle SOA/OIC integration knowledge is a plus.
• Experience with Agile/Scrum methodology.
• Excellent communication and stakeholder management skills.

2)Job Title: Oracle EBS SCM Techno Functional Consultant with APEX Experience

Location: Remote (USA)
Duration: Contract

Job Summary

We are looking for a highly skilled Oracle EBS SCM Techno Functional Consultant with Oracle APEX experience to support Oracle EBS R12 environments. The ideal candidate should possess strong SCM functional knowledge, technical development expertise, and hands-on experience developing modern Oracle APEX applications integrated with Oracle EBS.

Required Experience

• 15+ years of Oracle EBS experience.
• 7+ years of Oracle SCM Techno Functional experience.
• 3+ years of Oracle APEX development.
• Experience working with Oracle EBS R12.2.x.
• Experience supporting enterprise Oracle SCM implementations.

Functional Expertise

Hands-on experience with:

• Purchasing
• Inventory
• Order Management
• Shipping
• Procurement
• Cost Management
• Bills of Material
• Work in Process
• iProcurement
• Supplier Management

Oracle APEX Skills

• Oracle APEX application development
• Interactive Reports
• Interactive Grids
• Forms
• Dashboards
• REST APIs
• Authentication & Authorization
• Dynamic Actions
• LOVs
• Oracle APEX security
• SQL Workshop
• Page Designer

Technical Skills

• Oracle SQL
• PL/SQL
• Oracle Forms
• Oracle Reports
• XML Publisher
• Oracle Workflow
• Oracle APIs
• Open Interfaces
• REST APIs
• JSON
• Oracle REST Data Services (ORDS)
• JavaScript
• HTML
• CSS
• Oracle Database 12c/19c

Responsibilities

• Analyze business requirements and design Oracle SCM solutions.
• Develop Oracle APEX applications integrated with Oracle EBS.
• Build dashboards and reporting solutions for Supply Chain users.
• Create custom workflows and automation using Oracle APEX.
• Develop PL/SQL packages, procedures, functions, and triggers.
• Integrate Oracle APEX with Oracle EBS using APIs and REST services.
• Develop RICE components.
• Support Oracle SCM enhancements and production issues.
• Optimize SQL queries and improve application performance.
• Participate in testing, deployments, and release management.
• Collaborate with functional consultants and technical teams.
• Prepare technical documentation and user guides.
• Support Oracle upgrades and patching activities.

Preferred Qualifications

• Experience with Oracle REST Data Services (ORDS).
• Experience with Oracle Integration Cloud (OIC).
• Exposure to Oracle Visual Builder (VBCS) is a plus.
• Knowledge of Oracle Cloud SCM integrations is desirable.
• Experience with Git or version control systems.
• Strong analytical and problem-solving skills.
• Excellent communication skills with business stakeholders.