You are previewing Oracle E-Business Suite Development & Extensibility Handbook.
O'Reilly logo
Oracle E-Business Suite Development & Extensibility Handbook

Book Description

Extend and Customize Oracle E-Business Suite Transform your Oracle E-Business Suite infrastructure to suit enterprise requirements using the comprehensive development methods in this Oracle Press guide.Oracle E-Business Suite Development & Extensibility Handbook lays out each tool alongside reusable code and step-by-step examples.

Table of Contents

  1. Cover Page
  2. Oracle E-Business Suite Development and Extensibility Handbook
  3. Copyright Page
  4. Dedication
  5. Contents
  6. Acknowledgments
  7. Introduction
  8. 1 Introduction to Oracle E-Business Suite
    1. What Is Oracle E-Business Suite?
    2. Product Families
    3. Professional User Interface
    4. Web User Interface
    5. Configurations, Personalizations, Extensions, and Customizations
      1. Configurations
      2. Personalizations
      3. Customizations and Extensions
    6. Concept of E-Business Suite Environments
    7. Concept of Common Entities and Common Data
    8. Examples of Common Entities
    9. Summary
  9. 2 E-Business Suite Architecture
    1. Architecture Overview
    2. E-Business Suite System Architecture
      1. Client or Desktop Tier
      2. Application Tier
      3. Oracle Home Directories and File System in Oracle Applications
      4. File System in Oracle Applications
      5. File System in R11i
      6. File System in R12
      7. Environment Files in Oracle Applications
      8. Database Tier
    3. Summary
  10. 3 Application Object Library (AOL)
    1. Overview of Security Architecture
    2. Applications in E-Business Suite
      1. An Example: Attaching a Concurrent Program to an Application
    3. Profile Options in Oracle Applications
      1. Example Use Case for Profile Options
      2. Creating Custom Profile Options
    4. Descriptive Flexfields (DFFs)
      1. Descriptive Flexfield FAQs
    5. Key Flexfields (KFFs)
      1. Key Flexfield FAQ
    6. Lookups in Oracle Apps
      1. Security of Lookups
      2. Validating Flexfield Segments Against Lookups
      3. Using Lookups for Custom Development
    7. Value Sets
      1. Value Set of a Validation Type Table
    8. Message Dictionary
      1. The Purpose of Message Dictionary
      2. How a Message Is Created
      3. Displaying a Message from Different Tools
      4. Table Used by Messages Dictionary
    9. Auditing in Oracle Apps: User Audits and Data Change Audits
      1. Audit of End Users’ Activity
      2. Audit of Data Changes
      3. Row Who Columns
    10. Common Debugging Framework in Oracle Applications
      1. API to Capture Debug Messages in Custom Code
      2. Autonomous Transaction in Debugging
      3. Debugging an API from SQL*Plus
    11. Summary
  11. 4 Multiple Organizations Feature
    1. Overview of Multi-Org
    2. Multi-Org in R11i
      1. Setting the Multi-Org Context in SQL*Plus
    3. Multi-Org in Release 12
      1. Technical Details of the MOAC Design
    4. Summary
  12. 5 Development of Concurrent Programs
    1. What Is a Concurrent Program?
    2. Types of Concurrent Programs
    3. How to Define a Concurrent Program
      1. Creating a Hello World Concurrent Program
    4. Examples of Concurrent Programs
      1. Host Program
      2. SQL*Loader Concurrent Programs
      3. PL/SQL Program
      4. Java Concurrent Program
    5. Best Practices
    6. Summary
  13. 6 Forms in Oracle Applications
    1. Oracle Forms Tool: An Overview
      1. Forms
      2. Blocks
      3. Items
      4. Triggers
      5. Property Palette
    2. Forms Delivered by Oracle E-Business Suite
      1. Location of the Form Files on Server
    3. Custom Forms in E-Business Suite
      1. Preparing the Desktop for Custom Forms Development
      2. Steps for Developing Custom Forms in E-Business Suite
    4. Extending Forms Using CUSTOM.pll
      1. Example of an Extension Using CUSTOM.pll
      2. Best Practice for CUSTOM.pll
    5. Extending Forms Using Forms Personalization
      1. Examples of Forms Personalizations
      2. Comparison Between Forms Personalization and CUSTOM.pll
      3. Best Practices When Implementing Forms Personalizations
      4. Further Readings on Forms Personalizations
    6. Summary
  14. 7 Reports Development and Customization in Oracle Apps
    1. Main Components of Oracle Reports
      1. Data Model
    2. Reports Delivered by Oracle Apps
      1. Dynamic ORDER BY Clauses
      2. Multi-Org Initialization
    3. Reports Customization and Custom Reports Development
      1. Reports Customization Example
      2. Best Practices for Developing Reports in E-Business Suite
    4. Summary
  15. 8 BI Publisher in Oracle Applications
    1. Comparison Between BI Publisher and Oracle Reports
    2. BI Publisher: Introduction and Example
      1. BI Publisher Example Using an XML File
    3. Integration of BI Publisher with E-Business Suite
      1. Oracle Reports Integration with BI Publisher
      2. Using a Data Template with BI Publisher
      3. Using BI Publisher with OA Framework
      4. Converting Oracle Reports Output to BI Publisher
      5. Bursting in E-Business Suite
      6. Good Practices for Developing BI Publisher Reports in E-Business Suite
    4. Summary
  16. 9 OA Framework: Concepts, Development, and Extensions
    1. OAF: A Historical Perspective
      1. PL/SQL-Based Web Pages
      2. AK Developer
      3. OA Framework with AK Developer Repository
      4. Current Technology: OA Framework with MDS
    2. Comparison Between Oracle Forms and OA Framework
    3. OA Framework Architecture
      1. MDS: Pages in OA Framework
      2. Controller in OA Framework
      3. Business Components for Java
      4. Where to Write Code
    4. JDeveloper: Development Methodology
      1. JDeveloper and Desktop Configuration
    5. Concepts of OA Framework Personalizations
      1. Admin Personalizations
      2. User-Level Personalizations
    6. OA Framework Extensions
      1. Identifying the Type of Required Extension
      2. View Object Extension
      3. Entity Object Extensions
      4. Application Module Extension
      5. Controller Extension
      6. OAF Extensions: Fully Worked Example
      7. OA Framework Extensions Tips
    7. Summary
  17. 10 Custom Look and Feel
    1. UIX: CLAF Enabling Technology
      1. UIX Custom Style Sheets
      2. UIX Custom Icons
      3. UIX Custom Renderers
    2. How to Create CLAF in Oracle Applications
      1. Creating Custom Styles and Icons
    3. Best Practices
    4. Summary
  18. 11 Oracle Workflow
    1. Architecture Overview and Key Components
      1. Oracle Workflow Builder
      2. Understanding Workflow Definition
      3. An Example: Creating a Workflow Process
      4. Workflow Engine
      5. Embedding OA Framework Regions in WF Notifications
      6. Directory Service
    2. Business Events in Oracle Applications
      1. What Is a Business Event?
      2. Business Events System (BES)
      3. An Example: Converting Existing Workflow
    3. Best Practices
      1. Workflow Builder: Design Time
      2. Modifications of Standards Workflow Processes
      3. Performance Considerations
      4. Deployment Considerations
    4. Summary
  19. 12 Oracle XML Gateway
    1. XML Gateway Architecture Overview
      1. XML Gateway Main Components Explained by Example
    2. Practical Examples
      1. Example of Creating an Inbound Message
      2. Example of Creating an Outbound Message
    3. Message Monitoring and Debugging
    4. Summary
  20. 13 Moving AOL Objects Between Instances
    1. Brief History: Before FNDLOAD
    2. Basics of FNDLOAD
      1. Advantages of FNDLOAD
      2. FNDLOAD Command
      3. Understanding the Loader Configuration (LCT) File
    3. Using FNDLOAD for Non-AOL Objects
    4. Using FNDLOAD: Best Practices
    5. Summary
  21. 14 Integration Between E-Business Suite and SOA
    1. Integration Through Oracle Adapter for Oracle Applications
      1. An Example of Exposing a Business Event to SOA
      2. Example Process Overview and Required Software
      3. Step-by-Step Walkthrough
    2. New SOA Enabling Features in Release 12.1
      1. Subscribing an External Web Service to a Business Event
      2. Oracle Integration Repository Enhancement in R12.1
    3. Summary
  22. 15 SQL Performance Coding Guidelines
    1. General Considerations Before Starting Solution Design
    2. Scalability
    3. SQL Coding Guidelines
      1. SQL Processing Overview
      2. Overview of Cost Based Optimizer (CBO)
      3. SQL Tuning Tools
      4. SQL Coding Guidelines
      5. SQL Tuning Tools: Common Signs of Inefficiency
    4. Summary
  23. Index