Oracle EBS SCM Techno Functional Consultant with APEX Experience

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

Location: Remote (USA)

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

• 10+ 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.