Oracle E-Business Suite R12 Core Development and Extension Cookbook. Building extensions in Oracle E-Business Suite is greatly simplified when you fol

Oracle E-Business Suite R12 Core Development and Extension Cookbook. Building extensions in Oracle E-Business Suite is greatly simplified when you fol - Opis

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 (...) więcej 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. Spis treści:
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
Support files, eBooks, discount offers, and more
Why Subscribe?
Free Access for Packt account holders
Instant Updates on New Packt Books
Preface
Extending Oracle E-Business Suite
Understanding the EBS architecture
Before we start
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Errata
Piracy
Questions
1. Creating Concurrent Programs
Introduction
Defining a concurrent program
Introducing concurrent programs
Types of concurrent programs
Executable file location
Output and log files
Register a custom application
How to do it...
How it works
Configure an executable
Getting ready
How to do it...
How it works...
Configure a concurrent program
How to do it...
How it works...
Making a concurrent program available to a user
Configure a menu
How to do it...
How it works...
Theres more...
Viewing a menu structure
Create a new request group
How to do it...
How it works...
Create a new responsibility
How to do it...
How it works...
Assign the responsibility to a user
How to do it...
How it works...
Run the concurrent program
How to do it...
How it works...
View the request
How to do it...
How it works...
See also...
Adding a concurrent program parameter
Adding a parameter to the concurrent program
How to do it...
How it works...
Amend the XXHREEBS package to add the new parameter
Getting ready
How to do it...
How it works...
Amend the XXHREEBS package to change the completion status of the concurrent program
Getting ready
How to do it...
How it works...
Testing the concurrent program
How to do it...
How it works...
There's more...
Creating a value set
Create a value set
How to do it...
How it works...
There's more...
What happens to the data entered?
Create a new parameter for the concurrent program
How to do it...
How it works...
Modify the executable to accept the new parameter
How to do it...
How it works...
Run the concurrent program
How to do it...
How it works...
Creating dependent parameters
Create a dependent value set
How to do it...
How it works...
Create a new parameter for the concurrent program
How to do it...
How it works...
Modify the executable to accept the new parameter
How to do it...
How it works...
Run the concurrent program
How to do it...
How it works...
Adding messages to the concurrent program log file
Create a profile option to turn logging on or off
How to do it...
How it works...
There's more...
Set the profile option value
How to do it...
How it works...
Add a procedure to write to the log file
How to do it...
How it works...
Writing to the log file
How to do it...
How it works...
Run the concurrent program
How to do it...
How it works...
Viewing the log file
How to do it...
How it works...
Reporting to the concurrent program output file
Add a procedure to write to the output file
How to do it...
How it works...
Add a cursor to get some data
How to do it...
How it works...
Add code to fetch data and write to the output file
How to do it...
How it works...
Running the concurrent program
How to do it...
How it works...
View the concurrent program output file
How to do it...
How it works...
Scheduling a concurrent program
Add default values for any required parameters
Getting ready
How to do it...
How it works...
Schedule the concurrent program
How to do it...
How it works...
Creating multiple concurrent programs
Copy an existing concurrent program
How to do it...
How it works...
Add a concurrent program to a request set
How to do it...
How it works...
Creating request sets
Run request set wizard
How to do it...
How it works...
Add a request set to a request group
How to do it...
How it works...
Run the request set
How to do it...
How it works...
Installing the database objects
How to do it...
How it works...
Creating a HOST concurrent program
Creating a PL/SQL executable
How to do it...
How it works...
Configuring a concurrent program to call the PL/SQL executable
How to do it...
How it works...
Creating a HOST executable
How to do it...
How it works...
Configuring a concurrent program to call the HOST executable
How to do it...
How it works...
Adding concurrent programs to a request group
How to do it...
How it works...
Creating an OUT directory
How to do it...
How it works...
Creating a symbolic link
How to do it...
How it works...
Testing a host concurrent program
Getting started...
How to do it...
How it works...
2. Oracle Forms
Introduction
Using forms builder for E-Business Suite
Creating a custom schema
Installing the database objects
How to do it...
How it works...
Getting started with forms
Installing Oracle Developer Suite
How to do it...
How it works...
Creating the forms builder desktop shortcut
How to do it...
How it works...
Adding a TNS names entry
How to do it...
How it works...
Setting runtime parameters in the environment file
How to do it...
How it works...
FTP forms and libraries
Getting ready
Forms (FMB files)
Libraries (PLL files)
How to do it...
How it works...
Opening the TEMPLATE form
How to do it...
How it works...
Renaming the TEMPLATE form
How to do it...
How it works...
Creating a master block and container objects
Creating a block using the block wizard
How to do it...
How it works...
Setting the block properties
How to do it...
How it works...
Setting the item properties
How to do it...
How it works...
Setting the canvas properties
How to do it...
How it works...
Setting the window properties
How to do it...
How it works...
Setting the module properties
How to do it...
How it works...
Creating a dummy item
How to do it...
How it works...
Removing unwanted objects
How to do it...
How it works...
Renaming prompts
How to do it...
How it works...
Resizing the viewport
How to do it...
How it works...
Modifying the template code
Modifying the PRE-FORM trigger
How to do it...
How it works...
Modifying the WHEN-NEW-FORM-INSTANCE trigger
How to do it...
How it works...
Modifying the APP_CUSTOM procedure
How to do it...
How it works...
Adding a detail block to a form
Creating a lookup
How to do it...
How it works...
Creating a detail block
How to do it...
How it works...
Setting the block properties
How to do it...
How it works...
Setting the item properties
How to do it...
How it works...
Creating a relationship between the master and detail blocks
How to do it...
How it works...
Adding a record indicator to the block
How to do it...
How it works...
Adding insert, update, and delete events
Creating a program unit package specification
How to do it...
How it works...
Creating a program unit package body
How to do it...
How it works...
Creating ON-INSERT, ON-UPDATE, ON-DELETE, and ON-LOCK triggers
How to do it...
How it works...
Creating PRE-INSERT and PRE-UPDATE triggers to set the WHO columns
How to do it...
How it works...
Deploying forms
Registering a form
How to do it...
How it works...
Creating a function that calls a form
How to do it...
How it works...
Adding a form to a menu
How to do it...
How it works...
FTP the form to the application tier
How to do it...
How it works...
Compiling a form
How to do it...
How it works...
Testing a form
How to do it...
How it works...
Adding buttons, list, and checkbox items
Adding OK and Cancel buttons
How to do it...
How it works...
Modifying the layout
How to do it...
How it works...
Adding triggers to the buttons
How to do it...
How it works...
Creating an LOV for the society name field
How to do it...
How it works...
Configuring the date fields
How to do it...
How it works...
Creating a list item
How to do it...
How it works...
Creating a checkbox item
How to do it...
How it works...
Testing the form
How to do it...
How it works...
Adding a query screen to a form
Adding code to the WHEN-NEW-FORMS-INSTANCE trigger
How to do it...
How it works...
Copying the QUERY_FIND object group
How to do it...
How it works...
Setting the block, canvas, and window properties
How to do it...
How it works...
Editing the button triggers on the QUERY_FIND block
How to do it...
How it works...
Creating items in the query block
How to do it...
How it works...
Resizing the objects on the canvas
How to do it...
How it works...
Creating a PRE-QUERY trigger
How to do it...
How it works...
Creating a QUERY_FIND trigger
How to do it...
How it works...
Passing parameters to a form
Creating a parameter
How to do it...
How it works...
Bypassing the query find screen
How to do it...
How it works...
Testing the form
How to do it...
How it works...
Testing the form with the PERSON_ID parameter passed in
How to do it...
How it works...
3. Advanced Oracle Forms
Introduction
Installing the database objects
How to do it...
How it works...
Using messages from the message dictionary
Creating a message directory
How to do it...
How it works...
Creating a message
How to do it...
How it works...
Creating a message file
How to do it...
How it works...
Coding logic to display messages
How to do it...
How it works...
Compiling the form
How to do it...
How it works...
Testing the form
How to do it...
How it works...
Creating tabs within a form
Creating a tabbed region
How to do it...
How it works...
Resizing objects on a canvas
How to do it...
How it works...
Creating a new block
How to do it...
How it works...
Setting block properties
How to do it...
How it works...
Setting item properties
How to do it...
How it works...
Creating a relationship between the master and detail blocks
How to do it...
How it works...
Adding a record indicator to a block
How to do it...
How it works...
Sizing and positioning items on a tabbed canvas
How to do it...
How it works...
Aligning a tabbed canvas on a content canvas
How to do it...
How it works...
Adding a form level trigger to show a tabbed canvas
How to do it...
How it works...
Adding code to manage a tabbed canvas
How to do it...
How it works...
Creating program units
Creating a new package to handle database transactions
How to do it...
How it works...
Adding triggers to capture transactional events on a block
How to do it...
How it works...
Creating triggers to set the WHO columns
How to do it...
How it works...
Adding lookups, date fields, and lists
Creating a lookup
How to do it...
How it works...
Creating a new LOV based upon a record group
How to do it...
How it works...
Configuring date fields
How to do it...
How it works...
Creating a list item
How to do it...
How it works...
Controlling menu items
Copying the standard menu from the application server and opening it in forms
How to do it...
How it works...
Disabling an existing menu item
How to do it...
How it works...
Adding a new menu item
How to do it...
How it works...
Adding a trigger to capture new menu item events
How to do it...
How it works...
There's more...
Compiling the form
How to do it...
How it works...
Creating pop-up menu items
Adding items to a pop-up menu
How to do it...
How it works...
Compiling the form
How to do it...
How it works...
Adding a trigger to capture pop-up events
How to do it...
How it works...
Adding flexfields to forms
Adding flexfield items to a table
How to do it...
How it works...
Registering a table within EBS
How to do it...
How it works...
Viewing the table registration in EBS
How to do it...
How it works...
Registering a Descriptive Flexfield
How to do it...
How it works...
Enabling a flexfield value
How to do it...
How it works...
Adding a flexfield item to a form
How to do it...
How it works...
Creating triggers for flexfield events
Adding a WHEN-NEW-FORM-INSTANCE event
How to do it...
How it works...
Adding a WHEN-NEW-ITEM-INSTANCE event
How to do it...
How it works...
Testing the form
How to do it...
How it works...
Adding a zoom using the CUSTOM library
Finding the short name of the form we want to zoom from
How to do it...
How it works...
Finding the name of a block
How to do it...
How it works...
Enabling a zoom
How to do it...
How it works...
Creating an object-specific library
How to do it...
How it works...
Attaching a library to the CUSTOM library
How to do it...
How it works...
Coding an event in the CUSTOM library
How to do it...
How it works...
Compiling libraries on the application server
How to do it...
How it works...
Adding a function to a menu
How to do it...
How it works...
Testing the zoom
How to do it...
How it works...
Adding a spreadtable to a form
Adding the CRM Administrator responsibility
How to do it...
How it works...
Configuring a spreadtable
How to do it...
How it works...
Adding a tab page
How to do it...
How it works...
Adding the JTF_GRID object group
How to do it...
How it works...
Adding a block
How to do it...
How it works...
Adding an item
How to do it...
How it works...
Adding a library
How to do it...
How it works...
Adding code to manage the grid
How to do it...
How it works...
Adding code to populate the grid
How to do it...
How it works...
Testing the form
How to do it...
How it works...
Capturing events for a spreadtable
Configuring a hyperlink on a spreadtable
How to do it...
How it works...
Adding triggers to capture events for a grid
How to do it...
How it works...
Adding a custom trigger to capture an event
How to do it...
How it works...
Adding code to manage events from a grid
How to do it...
How it works...
Testing the form
How to do it...
How it works...
4. Forms Personalization
Introduction
Opening the personalization screen
Getting started
How it works...
The Personalization screen
Definition
Condition tab
Context region
Actions tab
Property
Message
Builtin
Menu
How it works...
Installing the database objects
How to do it...
How it works...
Changing properties
Changing prompts
How to do it...
How it works...
Disabling buttons
How to do it...
How it works...
Renaming tabs
How to do it...
How it works...
Hiding fields
How to do it...
How it works...
Moving fields
How to do it...
How it works...
Testing the form after applying personalization
How to do it...
How it works...
Fixing personalization that doesn't seem to work
How to do it...
How it works...
Adding a menu item to a form
Adding a menu item
How to do it...
How it works...
Testing whether the menu item has been added
How to do it...
How it works...
Performing a simple validation and displaying a message
Adding validation when an event is triggered
How to do it...
How it works...
Adding a message
How to do it...
How it works...
Testing the form
How to do it...
How it works...
Launching a form
Adding a condition
How to do it...
How it works...
Adding a builtin to launch a form
How to do it...
How it works...
Testing the form is launched
Getting started
How to do it...
How it works...
Adding a toolbar icon to a form
Adding an icon to the toolbar
How to do it...
How it works...
Testing to see if the toolbar icon is displayed
How to do it...
How it works...
Performing complex validation
Creating a lookup
How to do it...
How it works...
Calling a database function in a condition statement
Getting ready
How to do it...
How it works...
Adding a warning message
How to do it...
How it works...
Testing the validation
How to do it...
How it works...
Stop any further processing
How to do it...
How it works...
Checking a database value against a form value
How to do it...
How it works...
There's more...
Altering an LOV's record group
Creating a new record group
How to do it...
How it works...
There's more...
Assigning a new record group to an LOV
How to do it...
How it works...
Testing a radio group has changed
How to do it...
How it works...
5. Workflow
Introduction
Introducing Workflow Builder
How to do it...
How it works...
There's more...
See also
Installing the database objects
How to do it...
How it works...
Creating an advanced queue
Getting started
How to do it...
How it works...
Building a workflow
Creating a new workflow
Getting ready
How to do it...
How it works...
Creating a new item type
How to do it...
How it works...
Creating a new process
How to do it...
How it works...
Creating a start function
How to do it...
How it works...
Creating an end function
How to do it...
How it works...
Creating attributes to store the event details
How to do it...
How it works...
Assigning the start event details
How to do it...
How it works...
Saving a workflow to the database
How to do it...
How it works...
Creating a business event
Setting up the workflow administrator responsibility
How to do it...
How it works...
Creating an agent
How to do it...
How it works...
Creating an agent listener
How to do it...
How it works...
Defining a business event
How to do it...
How it works...
Subscribing to a business event
How to do it...
How it works...
Viewing a workflow status and monitoring progress
Adding a message to an advanced queue
How to do it...
How it works...
Viewing a workflow in status monitor
How to do it...
How it works...
Viewing the workflow status diagram
How to do it...
How it works...
Viewing workflow attributes and event messages
How to do it...
How it works...
Adding a function
Updating an employee record for testing
How to do it...
How it works...
Adding attributes
How to do it...
How it works...
Adding a function
How to do it...
How it works...
There's more...
Testing the workflow
How to do it...
How it works...
Creating a lookup
Creating a Success/Fail lookup
How to do it...
How it works...
See also
Adding an error message attribute
How to do it...
How it works...
Creating a subprocess
Creating a subprocess
How to do it...
How it works...
Adding a validate employee function
How to do it...
How it works...
Adding a validate absence type function
How to do it...
How it works...
Adding a validate absence dates function
How to do it...
How it works...
Creating end functions
How to do it...
How it works...
Joining the functions
How to do it...
How it works...
Adding a subprocess to a parent process
How to do it...
How it works...
Testing the workflow
How to do it...
How it works...
There's more...
Creating messages
Creating an absence approval message
How to do it...
How it works...
Adding attributes to our approval message
How to do it...
How it works...
Creating a rejection message
How to do it...
How it works...
Adding attributes to our rejection message
How to do it...
How it works...
Creating an invalid XML message
How to do it...
How it works...
Adding invalid XML message attributes
How to do it...
How it works...
Sending notifications and processing responses
Creating an absence approval notification
How to do it...
How it works...
Creating an absence rejection notification
How to do it...
How it works...
Creating invalid XML notification
How to do it...
How it works...
Adding notifications to the process diagram
How to do it...
How it works...
Mapping the notifications
How to do it...
How it works...
Testing the workflow
How to do it...
How it works...
Viewing the notifications and workflow diagrams
How to do it...
How it works...
Calling an API
Creating a function to call the database package
How to do it...
How it works...
Adding a function to a process
How to do it...
How it works...
Testing the workflow
How to do it...
How it works...
6. Utilities
Introduction
Setting the environment variables
Setting the environment on the application server
How to do it...
How it works...
Setting the environment on the database server
How to do it...
How it works...
Starting and stopping an environment
Starting an environment
How to do it...
How it works...
Stopping an environment
How to do it...
How it works...
Creating a custom schema
Making a new environment parameter
How to do it...
Running AutoConfig (adautocfg.sh)
How to do it...
How it works...
There's more...
Creating a CUSTOM schema directory structure
How to do it...
How it works...
Creating a new tablespace
How to do it...
How it works...
Creating a database user
How to do it...
How it works...
Registering an Oracle schema
How to do it...
How it works...
Registering an Oracle user
How to do it...
How it works...
There's more...
Extracting data using FNDLOAD
Extracting a lookup using FNDLOAD
How to do it...
How it works...
Extracting a Descriptive Flexfield using FNDLOAD
How to do it...
How it works...
Extracting a concurrent program using FNDLOAD
How to do it...
How it works...
Extracting a request set using FNDLOAD
How to do it...
How it works...
Extracting a profile option using FNDLOAD
How to do it...
How it works...
Extracting a form and function using FNDLOAD
How to do it...
How it works...
There's more...
Extracting a menu using FNDLOAD
How to do it...
How it works...
Extracting a request group using FNDLOAD
How to do it...
How it works...
Extracting a responsibility using FNDLOAD
How to do it...
How it works...
Extracting a personalization using FNDLOAD
How to do it...
How it works...
Extracting a message using FNDLOAD
How to do it...
How it works...
Downloading multiple objects
How to do it...
How it works...
Uploading using FNDLOAD
Uploading a lookup using FNDLOAD
How to do it...
How it works...
Uploading a Descriptive Flexfield using FNDLOAD
How to do it...
How it works...
Uploading a concurrent program using FNDLOAD
How to do it...
How it works...
Uploading a request set using FNDLOAD
How to do it...
How it works...
Uploading a profile option using FNDLOAD
How to do it...
How it works...
Uploading a form and function using FNDLOAD
How to do it...
How it works...
Uploading a menu using FNDLOAD
How to do it...
How it works...
Uploading a request group using FNDLOAD
How to do it...
How it works...
Uploading a responsibility using FNDLOAD
How to do it...
How it works...
Uploading a personalization using FNDLOAD
How to do it...
How it works...
Uploading a message using FNDLOAD
How to do it...
How it works...
Modifying the LDT file
How to do it...
How it works...
Using a script for FNDLOAD
How to do it...
How it works...
Using a script for migrating objects
How to do it...
How it works...
Index O autorze: 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. mniej