Oracle EBS R12 Technical Consultant

Experience: Not Available to Not Available years

Location: Pune, Maharashtra

Skills: PL/SQL, Oracle SQL, Oracle Forms, BI Publisher, RICEFW, Concurrent Programs, Value Sets, Lookups, Descriptive Flexfields, Key Flexfields, Profile Options, Alerts, Personalizations, Open Interfaces, Public APIs, Interface tables, REST, SOAP, Web Services, File-based integrations, FTP, SFTP, Data templates, XML templates, RTF templates, Excel templates, Oracle Workflow Builder, Oracle Integration Cloud, Shell scripting, Unix, Linux

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
Robust analytical and problem-solving skills.
Good communication skills.
Ability to work in cross-functional teams.
Documentation and technical design skills.

📌 Oracle EBSTechnical Consultant (Pune)
🏢 Jade Global Software
📍 Pune