Oracle EBS R12 Technical Consultant4

Key Responsibilities

• Design, develop, and maintain customizations in Oracle EBS R12.

• Develop RICEFW components:

  • Reports

  • Interfaces

  • Conversions

  • Extensions

  • Forms

  • Workflows

• Develop PL/SQL packages, procedures, functions, and triggers.

• Create and maintain Oracle Reports and BI Publisher reports.

• Develop Oracle Forms personalization and custom forms.

• Design and implement interfaces using APIs and open interfaces.

• Develop inbound and outbound integrations with third-party systems.

• Work closely with functional consultants to understand requirements.

• Perform unit testing, system testing, and support UAT.

• Provide production support and issue resolution.

Technical Skills

Core Technologies

• PL/SQL

• Oracle SQL

• Oracle Forms

• Oracle Reports

• BI Publisher (XML Publisher)

Oracle EBS Technical Components

Strong experience in:

• RICEFW development

• Concurrent Programs

• Value Sets

• Lookups

• Descriptive Flexfields (DFF)

• Key Flexfields (KFF)

• Profile Options

• Alerts

• Personalizations

Integration & Interfaces

• Experience using:

  • Open Interfaces

  • Public APIs

  • Interface tables

• Integration using:

  • REST/SOAP Web Services

  • File-based integrations

  • FTP/SFTP

Reporting

• BI Publisher report development

• Data templates and XML templates

• RTF and Excel templates

• SQL-based reports

Workflow

• Oracle Workflow Builder

• Creating and modifying workflow processes

• Workflow notifications and approvals

Preferred Skills

• Knowledge of Oracle Integration Cloud (OIC).

• Experience integrating Oracle EBS with Oracle Fusion Applications.

• Experience with shell scripting and Unix/Linux commands.

• Knowledge of performance tuning for SQL and PL/SQL.

Modules Exposure (Preferred)

Experience working with functional modules such as:

• Finance (GL, AP, AR, FA)

• SCM (PO, OM, Inventory)

• HRMS

Educational Qualification

• Bachelor’s degree in Computer Science / IT / Engineering.

Certifications (Preferred)

• Oracle EBS Technical Certification

• Oracle Database SQL/PLSQL Certification

Soft Skills

• Strong analytical and problem-solving skills

• Good communication skills

• Ability to work in cross-functional teams

• Documentation and technical design skills