Sign in  |  Register
Advanced search
Publication Cover

CITATION

Passi, Anil and Ajvaz, Vladimir. Oracle E-Business Suite Development & Extensibility Handbook. US: McGraw-Hill Osborne Media, 2009.

Oracle E-Business Suite Development & Extensibility Handbook

Authors: Anil Passi and Vladimir Ajvaz

Published:  September 2009

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