Oracle Applications
E-Business Suite, Fusion Cloud, PL/SQL, integration & reporting
Oracle Apps interview questions covering E-Business Suite (R12), Fusion Cloud, PL/SQL APIs, integration patterns, BI Publisher reporting, workflow approvals, and administration.
EBS12 topics
Oracle EBS Architecture Overview
Understand the multi-tier architecture that underpins Oracle E-Business Suite R12
Oracle EBS Module Overview: AP, AR, GL
Grasp the core financial modules and how they interrelate within EBS Financials
Oracle EBS Module Overview: PO, OM, INV
Understand the procurement, order management, and inventory modules and their integration points
Concurrent Programs and Concurrent Manager
Explain how batch and report processing is orchestrated in EBS through concurrent programs
Profile Options in Oracle EBS
Understand what profile options are and how they control application behavior at multiple hierarchy levels
Flexfields: Key and Descriptive
Differentiate key flexfields from descriptive flexfields and explain their configuration and use
Multi-Org Access Control (MOAC)
Explain how EBS R12 enables users to access multiple operating units without switching responsibilities
Application Object Library (AOL) and FND Tables
Understand the foundational metadata layer (AOL/FND) that powers menus, responsibilities, and security in EBS
System Administrator Responsibility and Setup Hierarchy
Understand the standard setup sequence a System Administrator follows when configuring a new EBS instance
Item Master and Organization Structure in EBS
Explain how items and inventory organizations are structured to support multi-org manufacturing and distribution
AutoInvoice and AR Transaction Processing
Explain the AutoInvoice architecture used to import external transaction data into Oracle Receivables
Order Management Workflow and Order-to-Cash Lifecycle
Explain how Order Management uses Oracle Workflow to drive an order line through its lifecycle statuses
PL/SQL10 topics
Oracle EBS Public APIs and TCA Architecture
Explain why Oracle exposes public PL/SQL APIs and how they should be used instead of direct table DML
Open Interface Tables and Import Programs
Understand the standard interface-table pattern EBS uses for high-volume data conversion and integration
Bulk Operations: BULK COLLECT and FORALL
Explain how to optimize PL/SQL performance for large data volumes using bulk binding techniques
Database Triggers in EBS Customizations
Explain the appropriate and risky uses of database triggers within an Oracle EBS environment
CUSTOM.pll and Forms Personalization
Explain the two supported mechanisms for customizing Oracle Forms-based screens in EBS without modifying seeded forms
Value Sets and Validation in EBS
Explain the different value set validation types used across flexfields, concurrent program parameters, and profile options
Custom PL/SQL Packages: Design Standards
Establish best practices for structuring custom PL/SQL packages in an EBS technical environment
Dynamic SQL and Ref Cursors in EBS Extensions
Explain when and how to safely use dynamic SQL and ref cursors in custom EBS reports and extensions
Workflow Business Events and Event Subscriptions
Explain how Business Events decouple custom logic from core Oracle transaction processing
Performance Tuning Custom PL/SQL and SQL in EBS
Explain the standard toolkit and methodology for diagnosing and fixing slow custom code in EBS
Fusion10 topics
Oracle Fusion Cloud SaaS Architecture Overview
Understand the fundamental architectural differences between Fusion Cloud SaaS and traditional on-premise EBS
Fusion Security Model: Roles and Data Security
Explain Oracle Fusion's role-based access control model and how it differs from EBS's responsibility model
Fusion HCM Core Concepts: Global HR and Work Structures
Understand the foundational work structures that underpin Oracle Fusion HCM implementations
Fusion ERP: Subledger Accounting and Ledgers
Explain how Fusion ERP's ledger and subledger accounting architecture evolved from EBS while retaining core concepts
Fusion SCM: Supply Chain Modules Overview
Understand how Fusion SCM modules map to and extend beyond EBS's supply chain capabilities
Application Composer and Sandboxes
Explain Fusion's declarative extensibility model built on Application Composer and Sandbox-based change isolation
Page Composer and Visual Personalization
Explain how Fusion allows UI-level personalization of standard pages without custom code
Fusion Functional Setup Manager (FSM)
Explain how Fusion's Functional Setup Manager structures and tracks implementation configuration tasks
Fusion HCM Extract and Payroll Interface Basics
Explain how Fusion HCM Extract is used to move HR/payroll data out of Fusion for downstream consumption
Fusion Approval Management: BPM Task Configuration
Explain how Fusion configures approval workflows through BPM Worklist and Task Configuration, contrasted with AME in EBS
Integration8 topics
Oracle Fusion REST APIs Fundamentals
Understand the structure, authentication, and common patterns of Fusion Cloud REST APIs
File-Based Data Import (FBDI)
Explain how FBDI enables bulk data loading into Fusion Cloud using standardized Excel templates
HCM Data Loader (HDL)
Explain how HDL is used for bulk loading and updating HCM data using a flat-file, delta-friendly format
Oracle Integration Cloud (OIC) Fundamentals
Understand Oracle Integration Cloud's role as the primary iPaaS for connecting Fusion and other systems
SOAP Web Services in Oracle EBS Integration Repository
Explain how EBS exposes SOAP web services through the Integration Repository for external system integration
Error Handling and Monitoring in Cloud Integrations
Explain best practices for building resilient, observable integrations between Fusion/EBS and external systems
EBS to Fusion Coexistence Integration Patterns
Explain common integration patterns for organizations running EBS and Fusion Cloud side-by-side during a phased migration
Web ADI and Spreadsheet-Based Data Loading
Explain how Web ADI provides a spreadsheet interface for bulk data entry and upload into EBS
Reporting8 topics
Oracle Reports vs BI Publisher
Understand the evolution from Oracle Reports to BI Publisher as EBS's primary reporting engine
BI Publisher Data Models and Sub-Templates
Understand advanced BI Publisher data model techniques including multiple data sets, bursting, and reusable sub-templates
OTBI: Oracle Transactional Business Intelligence
Explain OTBI's role as Fusion Cloud's native, real-time, ad hoc reporting tool
Smart View and Financial Reporting Studio
Explain how Smart View bridges Excel and Oracle's financial data sources for management reporting
Financial Statement Generator (FSG) in EBS
Explain how FSG allows finance users to build custom financial statements in EBS without technical development
Discoverer and Legacy EBS Reporting Tools
Understand the role of Oracle Discoverer as a legacy ad hoc query tool predating OTBI in the EBS ecosystem
BI Publisher eText Templates for EDI/Fixed-Width Output
Explain how BI Publisher's eText template type generates fixed-width and delimited output for EDI and banking integrations
Report Performance Tuning and Data Model Optimization
Explain strategies for diagnosing and improving slow-running reports across BI Publisher, OTBI, and FSG
Workflow6 topics
Oracle Workflow Builder Fundamentals
Understand the core building blocks of Oracle Workflow used throughout EBS for process automation and notifications
Approvals Management Engine (AME)
Explain how AME provides dynamic, attribute-driven approval routing without hardcoded workflow logic
Workflow Notifications and Notification Templates
Explain how workflow notifications are designed, formatted, and routed to end users through multiple channels
Workflow Monitor and Troubleshooting Stuck Processes
Explain the diagnostic tools and methodology for troubleshooting stuck or errored workflow processes
Fusion Approvals: Rule-Based Routing and BPM Composer Deep Dive
Explain advanced Fusion approval configuration beyond basic Task Configuration, including BPM Composer customization
FYI Notifications, Vacation Rules, and Delegation
Explain the supporting mechanisms that keep approval workflows moving smoothly despite approver unavailability
Admin6 topics
EBS Patching Strategy: AD Utilities and Online Patching
Explain the EBS patching toolset and how R12.2's Online Patching (ADOP) minimizes downtime
Cloning EBS Environments with RapidClone
Explain the standard process and considerations for cloning an EBS environment using RapidClone
EBS Security Fundamentals: SSO, SSL, and Data Encryption
Explain the core security layers protecting an EBS environment beyond application-level responsibility security
Database Performance Tuning for EBS: Statistics and Indexing Strategy
Explain EBS-specific considerations for database statistics gathering and indexing that differ from generic Oracle DBA practice
User and Password Administration in EBS
Understand the standard mechanisms for managing user accounts, password policies, and account lifecycle in EBS
Monitoring and Health-Check Strategy for EBS Environments
Explain a comprehensive proactive monitoring approach spanning application, middleware, and database tiers in EBS