Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook

A practical step-by-step guide to develop end-to-end extensions to Oracle E-Business Suite Release 12, with detailed illustrations and explanations

Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook

Cookbook
Andy Penver

A practical step-by-step guide to develop end-to-end extensions to Oracle E-Business Suite Release 12, with detailed illustrations and explanations
$32.99
$54.99
RRP $32.99
RRP $54.99
eBook
Print + eBook
$12.99 p/month

Want this title & more? Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.
+ Collection
Free Sample

Book Details

ISBN 139781849687126
Paperback398 pages

About This Book

  • 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

Who This Book Is For

This book is written for those who want to learn how to develop extensions in Oracle E-Business Suite. If you are involved in developing or supporting an e-business suite implementation you should find this book very useful. The book is detailed and therefore minimal technical expertise is required. It is suitable for those new to E-Business Suite or those wanting to broaden their knowledge who may want to use the book to brush up on their skills.

Table of Contents

Chapter 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
Chapter 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
Chapter 3: Creating a Master Detail Page in OA Framework
Introduction
Creating the model layer for a master detail page
Creating a master region
Creating a detail region
Deploying a page to EBS
Chapter 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
Chapter 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
Chapter 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)
Chapter 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
Chapter 8: Utilities
Introduction
Setting the environment variables
Starting and stopping an environment
Creating a custom schema

What You Will Learn

  • Get an overview of the architecture of release 12; learn about the file system and where files need to go
  • Gain an understanding of how we can personalize OA Framework pages in Oracle E-Business Suite (EBS)
  • Gain an understanding of the architecture of an OA Framework page
  • Install JDeveloper with OA Extension and set up a development environment
  • Deploy an OA Framework page in Oracle E-Business Suite (EBS) and run it through the application
  • Learn how to use BI Publisher for authoring, managing, and delivering highly-formatted documents
  • Create BI Publisher template files and then distribute populated templates to the file system and via email
  • Learn to configure a browser and MS office settings in preparation for use with desktop integrator

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.

Authors

Table of Contents

Chapter 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
Chapter 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
Chapter 3: Creating a Master Detail Page in OA Framework
Introduction
Creating the model layer for a master detail page
Creating a master region
Creating a detail region
Deploying a page to EBS
Chapter 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
Chapter 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
Chapter 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)
Chapter 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
Chapter 8: Utilities
Introduction
Setting the environment variables
Starting and stopping an environment
Creating a custom schema

Book Details

ISBN 139781849687126
Paperback398 pages
Read More

Recommended for You

Oracle Application Express 3.2 - The Essentials and More
$ 35.99