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
