Oracle EBS R12 Technical Consultant
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
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