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
eBook: $32.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $87.98    Print cover: $54.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • 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

Book Details

Language : English
Paperback : 398 pages [ 235mm x 191mm ]
Release Date : March 2013
ISBN : 1849687129
ISBN 13 : 9781849687126
Author(s) : Andy Penver
Topics and Technologies : All Books, Enterprise Products and Platforms, Cookbooks, Enterprise

Table of Contents

Chapter 1: Personalizing OA Framework Pages
Chapter 2: Getting Started with OA Framework Pages
Chapter 3: Creating a Master Detail Page in OA Framework
Chapter 4: Adding a Creation Page and LOV Region in OA Framework
Chapter 5: Advanced OA Framework
Chapter 6: BI Publisher
Chapter 7: Desktop Integration
Chapter 8: Utilities
  • 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 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

                  Andy Penver

                  Andy Penver currently lives and works in the U.K. as a solution architect for a large public sector client. He studied at Christ Church (University of Kent). He has over 18 years of experience in working with Oracle E-Business Suite. He has worked in both the private and public sectors, and has a strong technical background. He has led and managed teams of consultants through the full project lifecycles on some very large programs throughout the U.K. and Europe. Andy has been heavily involved in two large-scale, award-winning implementations of a shared service centre. Andy is currently the Managing Director of his own consultancy, NU-TEKK Limited. Andy has previously authored and published a book called Oracle E-Business Suite R12 Core Development and Extension Cookbook.
                  Sorry, we don't have any reviews for this title yet.

                  Code Downloads

                  Download the code and support files for this book.

                  Submit Errata

                  Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

                  Sample chapters

                  You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                  Frequently bought together

                  Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook +    Learning Dart =
                  50% Off
                  the second eBook
                  Price for both: $47.10

                  Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                  What you will learn from this book

                  • 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.


                  This is a practical, hands-on book providing in depth tutorials in each topic. It is full of step by step examples of the key points for each subject to give a core understanding. The examples are designed to be worked through and start right from scratch. Each topic will cover the development, configuration and testing of working examples. The book provides clear illustrations and tips each step of the way. It also comes with fully tested, complete, working code if ever you get stuck. Each chapter introduces the topic and what you need to do to get ready to start the exercises. It will tell you what tools you need to use and when to use them.

                  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.

                  Code Download and Errata
                  Packt Anytime, Anywhere
                  Register Books
                  Print Upgrades
                  eBook Downloads
                  Video Support
                  Contact Us
                  Awards Voting Nominations Previous Winners
                  Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                  Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software