Description :

Oracle EBS R12 Technical Consultant

Exp : 4 to 6 years

Location : Pune

Job Description Summary :

We are looking for a skilled Oracle EBS R12 Technical Consultant with strong experience in Oracle E-Business Suite technical development. The candidate will be responsible for developing custom solutions, reports, integrations, and extensions in Oracle EBS and supporting business requirements across Finance, SCM, and HR modules.

Job Description :

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