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
