ESaaS - Oracle - Technical - EBS/Apps Development

techno-functional candidate with expert-level skills in PL/SQL and RICEFW, along with knowledge of modules such as P2P, GL, Advanced Collections and Inventory.

Techno-functional candidate with expert-level skills in PL/SQL and RICEFW, along with knowledge of modules such as P2P, GL, Advanced Collections and Inventory.

RICEFW Development: Lead the design, development, and deployment of R eports, I nterfaces, C onversions, E xtensions, F orms, and W orkflows.

OAF Customization: Utilize Oracle Application Framework (OAF) to extend standard EBS functionality and develop new self-service pages.

System Integration: Design and implement robust data integration solutions between Oracle EBS and third-party systems using API-based frameworks.

Technical Troubleshooting: Provide Tier 3 support for complex production issues, performance tuning of long-running SQL queries, and data patches.

Documentation: Create comprehensive technical design documents (MD070), installation scripts (ins), and unit test plans (TE020).

Category Requirement Proficiency

Core Language Expert-level PL/SQL (Packages, Procedures, Triggers, Analytical Functions) Required

EBS Components RICEFW, Oracle Forms 10g/12c, Oracle Reports, XML/BI Publisher Required

Web Framework Oracle Application Framework (OAF) / JDeveloper Required

Nice to Have Oracle APEX (Application Express) integration with EBS Highly Preferred

Workflow Oracle Workflow Builder & AME (Approval Management Engine) Required

Experience Minimum 8+ years in Oracle EBS R12 environment Mandatory

Soft Skills

Analytical Thinking: Ability to translate complex business requirements (MD050) into scalable technical designs.

Communication: Strong verbal and written skills for interacting with functional consultants and stakeholders.

Leadership: Experience in conducting code reviews to ensure best practices.