Book description
Building extensions in Oracle E-Business Suite is greatly simplified when you follow the step-by-step instructions in this book. Whether novice or pro, this is a great tutorial with over 60 recipes and stacks of screenshots.
- Gain key skills learning 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
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.
Table of contents
-
Oracle E-Business Suite R12 Core Development and Extension Cookbook
- Table of Contents
- Oracle E-Business Suite R12 Core Development and Extension Cookbook
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
-
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
- Creating a PL/SQL executable
- Configuring a concurrent program to call the PL/SQL executable
- Creating a HOST executable
- Configuring a concurrent program to call the HOST executable
- Adding concurrent programs to a request group
- Creating an OUT directory
- Creating a symbolic link
- Testing a host concurrent program
-
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
-
3. Advanced Oracle Forms
- Introduction
- Installing the database objects
- Using messages from the message dictionary
-
Creating tabs within a form
- Creating a tabbed region
- Resizing objects on a canvas
- Creating a new block
- Setting block properties
- Setting item properties
- Creating a relationship between the master and detail blocks
- Adding a record indicator to a block
- Sizing and positioning items on a tabbed canvas
- Aligning a tabbed canvas on a content canvas
- Adding a form level trigger to show a tabbed canvas
- Adding code to manage a tabbed canvas
- 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
- Finding the short name of the form we want to zoom from
- Finding the name of a block
- Enabling a zoom
- Creating an object-specific library
- Attaching a library to the CUSTOM library
- Coding an event in the CUSTOM library
- Compiling libraries on the application server
- Adding a function to a menu
- Testing the zoom
- Adding a spreadtable to a form
- Capturing events for a spreadtable
-
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
-
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
-
6. Utilities
- Introduction
- Setting the environment variables
- Starting and stopping an environment
- Creating a custom schema
-
Extracting data using FNDLOAD
- Extracting a lookup using FNDLOAD
- Extracting a Descriptive Flexfield using FNDLOAD
- Extracting a concurrent program using FNDLOAD
- Extracting a request set using FNDLOAD
- Extracting a profile option using FNDLOAD
- Extracting a form and function using FNDLOAD
- Extracting a menu using FNDLOAD
- Extracting a request group using FNDLOAD
- Extracting a responsibility using FNDLOAD
- Extracting a personalization using FNDLOAD
- Extracting a message using FNDLOAD
- Downloading multiple objects
-
Uploading using FNDLOAD
- Uploading a lookup using FNDLOAD
- Uploading a Descriptive Flexfield using FNDLOAD
- Uploading a concurrent program using FNDLOAD
- Uploading a request set using FNDLOAD
- Uploading a profile option using FNDLOAD
- Uploading a form and function using FNDLOAD
- Uploading a menu using FNDLOAD
- Uploading a request group using FNDLOAD
- Uploading a responsibility using FNDLOAD
- Uploading a personalization using FNDLOAD
- Uploading a message using FNDLOAD
- Modifying the LDT file
- Using a script for FNDLOAD
- Using a script for migrating objects
- Index
Product information
- Title: Oracle E-Business Suite R12 Core Development and Extension Cookbook
- Author(s):
- Release date: May 2012
- Publisher(s): Packt Publishing
- ISBN: 9781849684842
You might also like
book
Oracle JDeveloper 10g for Forms & PL/SQL Developers: A Guide to Web Development with Oracle ADF
The most efficient way to learn J2EE programming techniques Two Oracle experts demonstrate techniques for working …
book
Oracle Procure-to-Pay Guide
Master Oracle E-Business Suite's Oracle Procure-to-Pay Drive better decision making and maximize asset usage with Oracle …
book
Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach
Performance problems are rarely "problems" per se. They are more often "crises" during which you're pressured …
book
Oracle Fusion Applications Development and Extensibility Handbook
Master Oracle Fusion Applications Design and Personalization Deliver highly adaptable business applications that bolster productivity and …
