Book Image

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

By : Andy Penver
Book Image

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

By: Andy Penver

Overview of this book

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.

Related Content you might be interested in

Current Title:

Small book image
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
Andy Penver
Mar, 2013 | 398 pages
No titles found
Table of Contents (15 chapters)
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Personalizing OA Framework Pages
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
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
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
4
Adding a Creation Page and LOV Region in OA Framework
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
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
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
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
Utilities
Introduction
Setting the environment variables
Starting and stopping an environment
Creating a custom schema
Index
Index

About the Reviewers

Parvez Achhwa has more than 22 years of experience in information systems technologies, with the last 17 years in Oracle Apps 11i/12i (CRM and Financials) implementation, BI, Business Process Automation, and management of large-scale projects. He is a rare breed to possess both functional and technical skills at various landscapes. In recent years, he has also developed Siebel implementation skills.

Presently, he is working with DAMAC Holding as Oracle ERP Manager.

I would like to thank Andy for giving me the opportunity to review this book.

Brian Badenhorst works as an Oracle E-Business Consultant and has over 10 years of experience in designing and developing robust solutions for a range of clients in both the UK private and public sectors. Backed by an engineering background, he has the ability to put forward strategic solutions and he has significant experience in fulfilling bespoke requirements.

Brian works as a freelance consultant and is the Managing Director of his own business.

This is the first book that Brian has been involved in.

Stephen Phillips was born in London in 1959 and moved to Australia in 1969 when his family emigrated. He studied Computer Science at the University of Melbourne and has worked in IT in both Australia and the U.K. for over 30 years. He began his career at the Government Computing Service (GCS) in Melbourne, Australia in 1981, working on Burroughs mainframes. Since that time he has worked in all scales of equipment and on projects ranging from large-scale implementations of Oracle HRMS to small PC-based systems for a single client.

Stephen has worked extensively with Oracle software since 1989 and moved back to London in 1994 in order to broaden his experience.

Since his return to the U.K. he has worked for a number of prestigious clients, including Oracle UK, Reuters, Lloyds TSB, Walkers Snack Foods, The John Lewis Partnership, and the Ministry of Justice. Stephen has worked on Data Migration projects with a number of these clients, as part of their implementation of Oracle HRMS/Payroll.

In 2003, Stephen completed the MSc degree with the Open University. The major area of his dissertation was artificial intelligence, as applied to the compiling of public transport timetables.

Previous Section
Next Chapter