Oracle E-Business Suite R12 Core Development and Extension Cookbook

Oracle E-Business Suite R12 Core Development and Extension Cookbook
eBook: $35.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $95.98    Print cover: $59.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • Gain key skills to extend Oracle E-Business Suite Release 12.
  • Build forms with advanced features and deploy them in the application
  • Create personalizations and understand how to modify functionality through them
  • Step by step examples guiding you through the development process

Book Details

Language : English
Paperback : 480 pages [ 235mm x 191mm ]
Release Date : May 2012
ISBN : 1849684847
ISBN 13 : 9781849684842
Author(s) : Andy Penver
Topics and Technologies : All Books, Enterprise Products and Platforms, Cookbooks, Enterprise, Oracle

Table of Contents

Chapter 1: Creating Concurrent Programs
Chapter 2: Oracle Forms
Chapter 3: Advanced Oracle Forms
Chapter 4: Forms Personalization
Chapter 5: Workflow
Chapter 6: Utilities
  • Chapter 1: Creating Concurrent Programs
    • Introduction
    • Defining a concurrent program
    • Making a concurrent program available to a user
    • Adding a concurrent program parameter
    • Creating a value set
    • Creating dependent parameters
    • Adding messages to the concurrent program log file
    • Reporting to the concurrent program output file
    • Scheduling a concurrent program
    • Creating multiple concurrent programs
    • Creating request sets
    • Installing the database objects
    • Creating a HOST concurrent program
    • Chapter 2: Oracle Forms
      • Introduction
      • Using forms builder for E-Business Suite
      • Installing the database objects
      • Getting started with forms
      • Creating a master block and container objects
      • Modifying the template code
      • Adding a detail block to a form
      • Adding insert, update, and delete events
      • Deploying forms
      • Adding buttons, list, and checkbox items
      • Adding a query screen to a form
      • Passing parameters to a form
      • Chapter 3: Advanced Oracle Forms
        • Introduction
        • Installing the database objects
        • Using messages from the message dictionary
        • Creating tabs within a form
        • Creating program units
        • Adding lookups, date fields, and lists
        • Controlling menu items
        • Creating pop-up menu items
        • Adding flexfields to forms
        • Creating triggers for flexfield events
        • Adding a zoom using the CUSTOM library
        • Adding a spreadtable to a form
        • Capturing events for a spreadtable
        • Chapter 4: Forms Personalization
          • Introduction
          • Opening the personalization screen
          • Installing the database objects
          • Changing properties
          • Adding a menu item to a form
          • Performing a simple validation and displaying a message
          • Launching a form
          • Adding a toolbar icon to a form
          • Performing complex validation
          • Altering an LOV's record group
          • Chapter 5: Workflow
            • Introduction
            • Introducing Workflow Builder
            • Installing the database objects
            • Creating an advanced queue
            • Building a workflow
            • Creating a business event
            • Viewing a workflow status and monitoring progress
            • Adding a function
            • Creating a lookup
            • Creating a subprocess
            • Creating messages
            • Sending notifications and processing responses
            • Calling an API
            • Chapter 6: Utilities
              • Introduction
              • Setting the environment variables
              • Starting and stopping an environment
              • Creating a custom schema
              • Extracting data using FNDLOAD
              • Uploading using FNDLOAD
              • Using a script for FNDLOAD
              • Using a script for migrating objects

              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.


              - 1 submitted: last submission 12 Apr 2013

              Errata type: Code | Page range: 438-446

              The commands in this range of pages is incorrect. This assignment should not upload the download command

              for example, The error:
              FNDLOAD apps / apps OY DOWNLOAD $ FND_TOP/patch/115/import/afmdmsg.lct MESG_XXHR_ON_HOLD_WARNING.ldt
              should be:
              FNDLOAD apps / apps OY UPLOAD $ FND_TOP/patch/115/import/afmdmsg.lct MESG_XXHR_ON_HOLD_WARNING.ldt

              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 Core Development and Extension Cookbook +    Cisco Unified Communications Manager 8: Expert Administration Cookbook =
              50% Off
              the second eBook
              Price for both: £32.75

              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.
              • Configure concurrent programs which launch executable programs such as a database package or a host program.
              • Understand how to write to a concurrent program log, and output files.
              • Add a query screen to forms and learn how to pass parameters.
              • Configure forms in E-Business Suite, create functions and add them to menus.
              • Create tabs and add code to control them. Create items with lookups, use widgets for date fields and add drop down lists.
              • Build a fully working form with most of the components you are ever likely to utilize.
              • Understand the personalization screen. Change properties to hide fields and move them around. Change labels and even alter a list of values.
              • Create personalizations to perform validation and display a message. Perform actions such as launching a form, adding items to menus or icons to toolbars.
              • Understand Oracle workflow and create a workflow that is triggered by a business event from an XML message on an advanced queue.
              • Build a workflow with functions, lookups, sub-processes and notifications.
              • Learn how to deploy a workflow and test it - viewing its status and monitoring progress.

              In Detail

              Oracle’s suite of applications is used by many major businesses and public sector organizations throughout the world. The book will show you how to build different types of extensions with different toolsets with Oracle E-Business Suite R12. It will take you from start to finish with fully working examples.

              This book will show you how to extend Oracle E-Business Suite Release 12. You will learn highly desirable skills on how to extend the application and develop your expertise. The book will provide detailed information about why things have to be done in certain ways, and will take you through the process of how to get started, what tools are needed, how to develop working examples, and how to deploy them within the application.

              Learn how to extend Oracle E-Business Suite (EBS) Release 12. There are detailed examples to work through, such as how various components are configured and how we can extend standard functionality. The book focuses on core development and extension and each chapter will introduce a topic before going through working examples from start to finish. There are plenty of detailed screen shots throughout each chapter giving clear instructions of what we are doing and why. Each recipe will develop a solution that will utilize core components to that topic. The Oracle E-Business Suite R12 Core Development and Extension Cookbook 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 on 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 individuals who want to learn how to develop extensions in Oracle E-Business suite. If you are involved in development or supporting an e-business suite implementation you should find this book very useful. The book is detailed so minimal technical expertise is required. It is suitable for beginners who have little experience or developers 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