Book description
A practical step-by-step guide to develop end-to-end extensions to Oracle E-Business Suite Release 12, with detailed illustrations and explanations
- Gain key skills learning to extend Oracle E-Business Suite Release 12
- Learn how to personalize Oracle Application Framework (OAF) pages and understand the structure of an OA Framework page
- Set up a JDeveloper with OA Framework extension and configure a development environment
- Develop OA Framework pages with advanced features such as a simple query page and master detail page
In Detail
Oracle’s suite of applications is used by many major businesses and public sector organizations throughout the world. Oracle E-Business Suite is the most comprehensive suite of integrated, global business applications that enable organizations to make better decisions, reduce costs, and increase performance. The book will show you how to build different types of extensions with different toolsets. It will take you from start to finish with fully working examples.
This book will show readers a wide variety of step-by-step examples of how to extend Oracle E-Business Suite Release 12 in a number of areas. The book focuses on OA Framework personalization and development, WebADI, and BI Publisher. It will take readers through the process of how to get started and what tools are needed. It will explain how to develop working examples and how to deploy them within Oracle E-Business Suite Release 12.
Learn how to extend Oracle E-Business Suite (EBS) Release 12, using detailed examples to work through how various components are configured and how we can extend standard functionality. The book focuses on OA Framework personalization and development, desktop integration (formerly WebADI), and BI Publisher and each chapter will introduce the topic before going through working examples from start to finish. There are plenty of detailed illustrations throughout each chapter giving clear instructions of what we are doing and why. Each topic will develop a solution that will utilize common core components of a subject area. It focuses on starting an extension right from the beginning to deploying it within E-Business Suite. At the end of each chapter the reader will have a good understanding of what they need to do for each area to take away and start using it in practice.
Each chapter will detail how to build an extension in the supported manner and also comes with complete, fully tested code and scripts that can be downloaded.
Table of contents
-
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
- Table of Contents
- Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
-
1. Personalizing OA Framework Pages
- Introduction
- Getting started with personalizations
- Setting the personalization profile options
- Discovering information about a page
- Clearing the cache
- Creating a user-level personalization
- Adding tool tips
- Creating an item
- Re-ordering items on a page
- Adding a button to a page
- Hiding a button on a page
- Making a field required
- Adding a flexfield to a page
- Using SPEL to trigger personalizations
- Deactivating personalizations
- Deleting personalizations
-
2. Getting Started with OA Framework Pages
- Introduction
- Getting started with OA Framework
- Installing the database objects
- Setting up our development environment
- Setting the environment variables
- Transferring the DBC file from the application server
- Creating a shortcut to JDeveloper
- Creating an EBS user and assigning responsibilities
- Adding database connections in JDeveloper
- Setting the OC4J settings and project properties
- Running a page
- Creating a new project
- Creating the model layer for a query page
- Creating the view layer for a query page
-
3. Creating a Master Detail Page in OA Framework
- Introduction
-
Creating the model layer for a master detail page
- Creating the entity object (EO)
- Creating the application module (AM)
- Creating the view object (VO)
- Editing the view object (VO)
- Linking the view object (VO) to the application module (AM)
- Testing the application module (AM)
- Creating the view link (VL)
- Adding the view link (VL) to the application module (AM)
- Testing the application module (AM)
- Creating a master region
- Creating a detail region
- Deploying a page to EBS
-
4. Adding a Creation Page and LOV Region in OA Framework
- Introduction
- Creating a page to insert and update records
- Passing the parameters
- Creating a list of values
- Adding a link to a region
- Running a page in the debug mode
-
5. Advanced OA Framework
- Introduction
- Navigating between OA Framework pages
- Updating records
- Adding a validation to the page
- Calling PL/SQL from the OAF page
- Adding a decision message
- Partial Page Rendering
- Viewing a page from EBS
- Transferring the files
-
6. BI Publisher
- Introduction
- Generating XML output using a concurrent program
- Making a concurrent program available to a user
- Using Oracle BI Publisher Desktop software to create a rich text format (RTF) template
- Creating a Data Definition
- Defining a template
- Running a BI Publisher report
- Generating PDF and Excel output using an RTF template
- Implementing BI Publisher Bursting (e-mail)
- Implementing BI Publisher Bursting (file system)
-
7. Desktop Integration
- Introduction
- Installing the database objects
- Getting started with desktop integration
- Configuring the browser and MS Office settings
- Registering a table and its columns within Oracle E-Business Suite
- Creating a custom integrator
- Creating a function for an integrator
- Adding an integrator to a menu
- Adding advanced features to an integrator
- Defining the importer
-
8. Utilities
- Introduction
- Setting the environment variables
- Starting and stopping an environment
- Creating a custom schema
- Index
Product information
- Title: Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
- Author(s):
- Release date: March 2013
- Publisher(s): Packt Publishing
- ISBN: 9781849687126
You might also like
book
Oracle E-Business Suite R12 Core Development and Extension Cookbook
Building extensions in Oracle E-Business Suite is greatly simplified when you follow the step-by-step instructions in …
book
Oracle E-Business Suite Development & Extensibility Handbook
Extend and Customize Oracle E-Business Suite Transform your Oracle E-Business Suite infrastructure to suit enterprise requirements …
book
Oracle E-Business Suite R12.x HRMS – A Functionality Guide
Design, implement, and build an entire end-to-end HR management infrastructure with Oracle E-Business Suite In Detail …
book
Oracle Database Upgrade and Migration Methods: Including Oracle 12c Release 2
Learn all of the available upgrade and migration methods in detail to move to Oracle Database …