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.
Table of Contents (15 chapters)
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Installing the database objects


Create the database objects for this chapter before you start, by using a script provided. The code comes with the Readme_7_1.Txt readme file.

How to do it...

We are going to create a number of objects that we will use throughout the chapter. For all the database objects, there is a script provided called 7126_07_01.sh. The following steps explain of how to run the script:

  1. Create a local directory C:\Packt\Scripts\Ch7, where the scripts are downloaded to.

  2. Open PuTTY and connect to the Application Tier user.

  3. Create a new directory on the Application Tier under $XXHR_TOP/Install with the following commands:

    cd $XXHR_TOP/Install
    mkdir Ch7
  4. Navigate to the new directory with the following command:

    cd Ch7
  5. Open WinSCP and transfer (ftp) the files from C:\Packt\Scripts\Ch7 to $XXHR_TOP/Install/Ch7.

  6. In Unix, change the permissions of the script with the following command:

    chmod 775 7126_07_01.sh
  7. Run the following command to create all of the database object commands:

    ./7126_07_01...