1. Foundation (Refresher)

• Overview of Oracle E-Business Suite (R12) & Fusion Architecture

• Multi-Org Access Control (MOAC) and Data Model

• ERP Technical vs. Functional Roles

• Oracle Applications Schema, Key Tables & Relationships

2. SQL, PL/SQL & Performance Tuning (Advanced)

• Advanced SQL Joins, Analytic Functions, Hierarchical Queries

• PL/SQL Packages, Functions, Procedures (Best Practices)

• Bulk Collect, FORALL, Performance Tuning Techniques

• Error Handling, Exception Logging Framework

• Use of DBMS_SCHEDULER for ERP Jobs

3. RICEW Components (Deep Dive)

• Reports: BI Publisher (XML), RDF Reports, Advanced Layouts

• Interfaces: Inbound/Outbound Interfaces, Open Interface Tables, Data Conversion Strategy

• Conversions: Data Mapping, Staging Tables, Data Migration with SQL Loader & APIs

• Extensions: Forms Personalization, OAF Extensions, Custom Hooks

• Workflows: Advanced Workflow Builder, AME (Approval Management Engine), Notifications

4. Oracle APIs & Integration

• Public APIs for Finance, SCM, HRMS Modules

• Interface Development Using APIs

• Oracle Web ADI Advanced Integrators

• Integration Techniques – EDI, SOA, Web Services

5. Oracle APEX & ORDS Integration

• APEX Architecture and Deployment with ERP

• Building Bolt-On Applications for ERP

• ORDS (Oracle REST Data Services) – REST API Development

• ERP to 3rd Party Integrations Using ORDS

6. Advanced BI & Reporting

• BI Publisher Templates – Bursting, Multi-Layout, Multi-Language

• Discoverer Replacement – Using OTBI / BIP for Fusion

• Oracle Analytics Cloud (OAC) Overview

• Custom Dashboards & Embedded Analytics

7. Fusion Technical Concepts (Cloud)

• Fusion Application Technical Architecture (ADF, BIP, OTBI)

• Fusion Data Model and Key Tables

• Security & Role-Based Access Control (RBAC)

• Data Loaders in Fusion (FBDI, ADFdi, HDL)

• REST & SOAP Web Services in Fusion

• Extensions in Fusion – Visual Builder Studio (VBCS), APEX in Cloud

8. Administration & Performance

• Concurrent Manager Tuning & Troubleshooting

• Logging & Debugging Tools (TKPROF, Trace, FND Logging)

• Patch Management & Customizations in R12

• PaaS for SaaS – Leveraging OCI for Custom Solutions

9. Case Studies & Hands-On Projects

• Developing a Complete RICEW Object from Scratch

• Migrating Legacy Data into Oracle ERP (EBS & Fusion)

• Building an APEX Application Integrated with R12

• Consuming Fusion REST APIs with ORDS

• End-to-End Technical Upgrade / Migration Scenario

10. Interview & Certification Preparation

• Common Technical Interview Questions (R12 & Fusion)

• Hands-On Assignments for Real-World Confidence

• Guidance for Oracle Certified Specialist (OCP, OCS) Exams

Who can join this course?

• Minimum 3–5 years of technical experience in one or more of the following: Database or Backend coding
• Basic proficiency in Oracle PL SQL and understanding of business workflows.
• Willingness to shift from domain operations to ERP consulting roles.

Technical Prerequisites

• Basic understanding of relational databases and business systems.
• Comfort in learning digital tools and structured systems.
• Optional: Basic exposure to SQL or any reporting tool (not mandatory but beneficial).