Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
  • Table Of Contents Toc
  • Feedback & Rating feedback
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

By : Andy Penver
3.7 (11)
Buy this Book
close
close
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

3.7 (11)
By: Andy Penver
Buy this Book

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.
Table of Contents (15 chapters)
close
close
close
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
Icon
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
Credits
Icon
Credits
About the Author
Icon
About the Author
About the Reviewers
chevron up
Icon
About the Reviewers
www.PacktPub.com
Icon
www.PacktPub.com
Preface
Icon
Preface
Free Chapter
1
Personalizing OA Framework Pages
Icon
Personalizing OA Framework Pages
Icon
Introduction
Icon
Getting started with personalizations
Icon
Setting the personalization profile options
Icon
Discovering information about a page
Icon
Clearing the cache
Icon
Creating a user-level personalization
Icon
Adding tool tips
Icon
Creating an item
Icon
Re-ordering items on a page
Icon
Adding a button to a page
Icon
Hiding a button on a page
Icon
Making a field required
Icon
Adding a flexfield to a page
Icon
Using SPEL to trigger personalizations
Icon
Deactivating personalizations
Icon
Deleting personalizations
2
Getting Started with OA Framework Pages
Icon
Getting Started with OA Framework Pages
Icon
Introduction
Icon
Getting started with OA Framework
Icon
Installing the database objects
Icon
Setting up our development environment
Icon
Setting the environment variables
Icon
Transferring the DBC file from the application server
Icon
Creating a shortcut to JDeveloper
Icon
Creating an EBS user and assigning responsibilities
Icon
Adding database connections in JDeveloper
Icon
Setting the OC4J settings and project properties
Icon
Running a page
Icon
Creating a new project
Icon
Creating the model layer for a query page
Icon
Creating the view layer for a query page
3
Creating a Master Detail Page in OA Framework
Icon
Creating a Master Detail Page in OA Framework
Icon
Introduction
Icon
Creating the model layer for a master detail page
Icon
Creating a master region
Icon
Creating a detail region
Icon
Deploying a page to EBS
4
Adding a Creation Page and LOV Region in OA Framework
Icon
Adding a Creation Page and LOV Region in OA Framework
Icon
Introduction
Icon
Creating a page to insert and update records
Icon
Passing the parameters
Icon
Creating a list of values
Icon
Adding a link to a region
Icon
Running a page in the debug mode
5
Advanced OA Framework
Icon
Advanced OA Framework
Icon
Introduction
Icon
Navigating between OA Framework pages
Icon
Updating records
Icon
Adding a validation to the page
Icon
Calling PL/SQL from the OAF page
Icon
Adding a decision message
Icon
Partial Page Rendering
Icon
Viewing a page from EBS
Icon
Transferring the files
6
BI Publisher
Icon
BI Publisher
Icon
Introduction
Icon
Generating XML output using a concurrent program
Icon
Making a concurrent program available to a user
Icon
Using Oracle BI Publisher Desktop software to create a rich text format (RTF) template
Icon
Creating a Data Definition
Icon
Defining a template
Icon
Running a BI Publisher report
Icon
Generating PDF and Excel output using an RTF template
Icon
Implementing BI Publisher Bursting (e-mail)
Icon
Implementing BI Publisher Bursting (file system)
7
Desktop Integration
Icon
Desktop Integration
Icon
Introduction
Icon
Installing the database objects
Icon
Getting started with desktop integration
Icon
Configuring the browser and MS Office settings
Icon
Registering a table and its columns within Oracle E-Business Suite
Icon
Creating a custom integrator
Icon
Creating a function for an integrator
Icon
Adding an integrator to a menu
Icon
Adding advanced features to an integrator
Icon
Defining the importer
8
Utilities
Icon
Utilities
Icon
Introduction
Icon
Setting the environment variables
Icon
Starting and stopping an environment
Icon
Creating a custom schema
Index
Icon
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.

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
Start a 7-day FREE trial
Next Chapter

Create a Note

Modal Close icon
You need to login to use this feature.
notes
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Delete Note

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Edit Note

Modal Close icon
Write a note (max 255 characters)
Cancel
Update Note

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY