book

Oracle E-Business Suite R12 Core Development and Extension Cookbook

Name: Oracle E-Business Suite R12 Core Development and Extension Cookbook
Author: Andy Penver
ISBN: 9781849684842

by Andy Penver

May 2012

Intermediate to advanced

480 pages

9h 51m

English

Packt Publishing

Read now

Unlock full access

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 moreWhy Subscribe?Free Access for Packt account holdersInstant Updates on New Packt Books
Preface
Extending Oracle E-Business SuiteUnderstanding the EBS architectureBefore 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 codeErrataPiracyQuestions
1. Creating Concurrent Programs
Introduction
Defining a concurrent program
Introducing concurrent programsTypes of concurrent programsExecutable file locationOutput and log filesRegister a custom applicationHow to do it...How it worksConfigure an executableGetting readyHow to do it...How it works...Configure a concurrent programHow to do it...How it works...
Making a concurrent program available to a user
Configure a menuHow to do it...How it works...There's more...Viewing a menu structureCreate a new request groupHow to do it...How it works...Create a new responsibilityHow to do it...How it works...Assign the responsibility to a userHow to do it...How it works...Run the concurrent programHow to do it...How it works...View the requestHow to do it...How it works...See also...
Adding a concurrent program parameter
Adding a parameter to the concurrent programHow to do it...How it works...Amend the XXHREEBS package to add the new parameterGetting readyHow to do it...How it works...Amend the XXHREEBS package to change the completion status of the concurrent programGetting readyHow to do it...How it works...Testing the concurrent programHow to do it...How it works...There's more...
Creating a value set
Create a value setHow to do it...How it works...There's more...What happens to the data entered?Create a new parameter for the concurrent programHow to do it...How it works...Modify the executable to accept the new parameterHow to do it...How it works...Run the concurrent programHow to do it...How it works...
Creating dependent parameters
Create a dependent value setHow to do it...How it works...Create a new parameter for the concurrent programHow to do it...How it works...Modify the executable to accept the new parameterHow to do it...How it works...Run the concurrent programHow to do it...How it works...
Adding messages to the concurrent program log file
Create a profile option to turn logging on or offHow to do it...How it works...There's more...Set the profile option valueHow to do it...How it works...Add a procedure to write to the log fileHow to do it...How it works...Writing to the log fileHow to do it...How it works...Run the concurrent programHow to do it...How it works...Viewing the log fileHow to do it...How it works...
Reporting to the concurrent program output file
Add a procedure to write to the output fileHow to do it...How it works...Add a cursor to get some dataHow to do it...How it works...Add code to fetch data and write to the output fileHow to do it...How it works...Running the concurrent programHow to do it...How it works...View the concurrent program output fileHow to do it...How it works...
Scheduling a concurrent program
Add default values for any required parametersGetting readyHow to do it...How it works...Schedule the concurrent programHow to do it...How it works...
Creating multiple concurrent programs
Copy an existing concurrent programHow to do it...How it works...Add a concurrent program to a request setHow to do it...How it works...
Creating request sets
Run request set wizardHow to do it...How it works...Add a request set to a request groupHow to do it...How it works...Run the request setHow 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 executableHow to do it...How it works...Configuring a concurrent program to call the PL/SQL executableHow to do it...How it works...Creating a HOST executableHow to do it...How it works...Configuring a concurrent program to call the HOST executableHow to do it...How it works...Adding concurrent programs to a request groupHow to do it...How it works...Creating an OUT directoryHow to do it...How it works...Creating a symbolic linkHow to do it...How it works...Testing a host concurrent programGetting 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 SuiteHow to do it...How it works...Creating the forms builder desktop shortcutHow to do it...How it works...Adding a TNS names entryHow to do it...How it works...Setting runtime parameters in the environment fileHow to do it...How it works...FTP forms and librariesGetting readyForms (FMB files)Libraries (PLL files)How to do it...How it works...Opening the TEMPLATE formHow to do it...How it works...Renaming the TEMPLATE formHow to do it...How it works...
Creating a master block and container objects
Creating a block using the block wizardHow to do it...How it works...Setting the block propertiesHow to do it...How it works...Setting the item propertiesHow to do it...How it works...Setting the canvas propertiesHow to do it...How it works...Setting the window propertiesHow to do it...How it works...Setting the module propertiesHow to do it...How it works...Creating a dummy itemHow to do it...How it works...Removing unwanted objectsHow to do it...How it works...Renaming promptsHow to do it...How it works...Resizing the viewportHow to do it...How it works...
Modifying the template code
Modifying the PRE-FORM triggerHow to do it...How it works...Modifying the WHEN-NEW-FORM-INSTANCE triggerHow to do it...How it works...Modifying the APP_CUSTOM procedureHow to do it...How it works...
Adding a detail block to a form
Creating a lookupHow to do it...How it works...Creating a detail blockHow to do it...How it works...Setting the block propertiesHow to do it...How it works...Setting the item propertiesHow to do it...How it works...Creating a relationship between the master and detail blocksHow to do it...How it works...Adding a record indicator to the blockHow to do it...How it works...
Adding insert, update, and delete events
Creating a program unit package specificationHow to do it...How it works...Creating a program unit package bodyHow to do it...How it works...Creating ON-INSERT, ON-UPDATE, ON-DELETE, and ON-LOCK triggersHow to do it...How it works...Creating PRE-INSERT and PRE-UPDATE triggers to set the WHO columnsHow to do it...How it works...
Deploying forms
Registering a formHow to do it...How it works...Creating a function that calls a formHow to do it...How it works...Adding a form to a menuHow to do it...How it works...FTP the form to the application tierHow to do it...How it works...Compiling a formHow to do it...How it works...Testing a formHow to do it...How it works...
Adding buttons, list, and checkbox items
Adding OK and Cancel buttonsHow to do it...How it works...Modifying the layoutHow to do it...How it works...Adding triggers to the buttonsHow to do it...How it works...Creating an LOV for the society name fieldHow to do it...How it works...Configuring the date fieldsHow to do it...How it works...Creating a list itemHow to do it...How it works...Creating a checkbox itemHow to do it...How it works...Testing the formHow to do it...How it works...
Adding a query screen to a form
Adding code to the WHEN-NEW-FORMS-INSTANCE triggerHow to do it...How it works...Copying the QUERY_FIND object groupHow to do it...How it works...Setting the block, canvas, and window propertiesHow to do it...How it works...Editing the button triggers on the QUERY_FIND blockHow to do it...How it works...Creating items in the query blockHow to do it...How it works...Resizing the objects on the canvasHow to do it...How it works...Creating a PRE-QUERY triggerHow to do it...How it works...Creating a QUERY_FIND triggerHow to do it...How it works...
Passing parameters to a form
Creating a parameterHow to do it...How it works...Bypassing the query find screenHow to do it...How it works...Testing the formHow to do it...How it works...Testing the form with the PERSON_ID parameter passed inHow 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 directoryHow to do it...How it works...Creating a messageHow to do it...How it works...Creating a message fileHow to do it...How it works...Coding logic to display messagesHow to do it...How it works...Compiling the formHow to do it...How it works...Testing the formHow to do it...How it works...
Creating tabs within a form
Creating a tabbed regionHow to do it...How it works...Resizing objects on a canvasHow to do it...How it works...Creating a new blockHow to do it...How it works...Setting block propertiesHow to do it...How it works...Setting item propertiesHow to do it...How it works...Creating a relationship between the master and detail blocksHow to do it...How it works...Adding a record indicator to a blockHow to do it...How it works...Sizing and positioning items on a tabbed canvasHow to do it...How it works...Aligning a tabbed canvas on a content canvasHow to do it...How it works...Adding a form level trigger to show a tabbed canvasHow to do it...How it works...Adding code to manage a tabbed canvasHow to do it...How it works...
Creating program units
Creating a new package to handle database transactionsHow to do it...How it works...Adding triggers to capture transactional events on a blockHow to do it...How it works...Creating triggers to set the WHO columnsHow to do it...How it works...
Adding lookups, date fields, and lists
Creating a lookupHow to do it...How it works...Creating a new LOV based upon a record groupHow to do it...How it works...Configuring date fieldsHow to do it...How it works...Creating a list itemHow to do it...How it works...
Controlling menu items
Copying the standard menu from the application server and opening it in formsHow to do it...How it works...Disabling an existing menu itemHow to do it...How it works...Adding a new menu itemHow to do it...How it works...Adding a trigger to capture new menu item eventsHow to do it...How it works...There's more...Compiling the formHow to do it...How it works...
Creating pop-up menu items
Adding items to a pop-up menuHow to do it...How it works...Compiling the formHow to do it...How it works...Adding a trigger to capture pop-up eventsHow to do it...How it works...
Adding flexfields to forms
Adding flexfield items to a tableHow to do it...How it works...Registering a table within EBSHow to do it...How it works...Viewing the table registration in EBSHow to do it...How it works...Registering a Descriptive FlexfieldHow to do it...How it works...Enabling a flexfield valueHow to do it...How it works...Adding a flexfield item to a formHow to do it...How it works...
Creating triggers for flexfield events
Adding a WHEN-NEW-FORM-INSTANCE eventHow to do it...How it works...Adding a WHEN-NEW-ITEM-INSTANCE eventHow to do it...How it works...Testing the formHow to do it...How it works...
Adding a zoom using the CUSTOM library
Finding the short name of the form we want to zoom fromHow to do it...How it works...Finding the name of a blockHow to do it...How it works...Enabling a zoomHow to do it...How it works...Creating an object-specific libraryHow to do it...How it works...Attaching a library to the CUSTOM libraryHow to do it...How it works...Coding an event in the CUSTOM libraryHow to do it...How it works...Compiling libraries on the application serverHow to do it...How it works...Adding a function to a menuHow to do it...How it works...Testing the zoomHow to do it...How it works...
Adding a spreadtable to a form
Adding the CRM Administrator responsibilityHow to do it...How it works...Configuring a spreadtableHow to do it...How it works...Adding a tab pageHow to do it...How it works...Adding the JTF_GRID object groupHow to do it...How it works...Adding a blockHow to do it...How it works...Adding an itemHow to do it...How it works...Adding a libraryHow to do it...How it works...Adding code to manage the gridHow to do it...How it works...Adding code to populate the gridHow to do it...How it works...Testing the formHow to do it...How it works...
Capturing events for a spreadtable
Configuring a hyperlink on a spreadtableHow to do it...How it works...Adding triggers to capture events for a gridHow to do it...How it works...Adding a custom trigger to capture an eventHow to do it...How it works...Adding code to manage events from a gridHow to do it...How it works...Testing the formHow to do it...How it works...
4. Forms Personalization
Introduction
Opening the personalization screen
Getting startedHow it works...The Personalization screenDefinitionCondition tabContext regionActions tabPropertyMessageBuiltinMenuHow it works...
Installing the database objects
How to do it...How it works...
Changing properties
Changing promptsHow to do it...How it works...Disabling buttonsHow to do it...How it works...Renaming tabsHow to do it...How it works...Hiding fieldsHow to do it...How it works...Moving fieldsHow to do it...How it works...Testing the form after applying personalizationHow to do it...How it works...Fixing personalization that doesn't seem to workHow to do it...How it works...
Adding a menu item to a form
Adding a menu itemHow to do it...How it works...Testing whether the menu item has been addedHow to do it...How it works...
Performing a simple validation and displaying a message
Adding validation when an event is triggeredHow to do it...How it works...Adding a messageHow to do it...How it works...Testing the formHow to do it...How it works...
Launching a form
Adding a conditionHow to do it...How it works...Adding a builtin to launch a formHow to do it...How it works...Testing the form is launchedGetting startedHow to do it...How it works...
Adding a toolbar icon to a form
Adding an icon to the toolbarHow to do it...How it works...Testing to see if the toolbar icon is displayedHow to do it...How it works...
Performing complex validation
Creating a lookupHow to do it...How it works...Calling a database function in a condition statementGetting readyHow to do it...How it works...Adding a warning messageHow to do it...How it works...Testing the validationHow to do it...How it works...Stop any further processingHow to do it...How it works...Checking a database value against a form valueHow to do it...How it works...There's more...
Altering an LOV's record group
Creating a new record groupHow to do it...How it works...There's more...Assigning a new record group to an LOVHow to do it...How it works...Testing a radio group has changedHow 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 startedHow to do it...How it works...
Building a workflow
Creating a new workflowGetting readyHow to do it...How it works...Creating a new item typeHow to do it...How it works...Creating a new processHow to do it...How it works...Creating a start functionHow to do it...How it works...Creating an end functionHow to do it...How it works...Creating attributes to store the event detailsHow to do it...How it works...Assigning the start event detailsHow to do it...How it works...Saving a workflow to the databaseHow to do it...How it works...
Creating a business event
Setting up the workflow administrator responsibilityHow to do it...How it works...Creating an agentHow to do it...How it works...Creating an agent listenerHow to do it...How it works...Defining a business eventHow to do it...How it works...Subscribing to a business eventHow to do it...How it works...
Viewing a workflow status and monitoring progress
Adding a message to an advanced queueHow to do it...How it works...Viewing a workflow in status monitorHow to do it...How it works...Viewing the workflow status diagramHow to do it...How it works...Viewing workflow attributes and event messagesHow to do it...How it works...
Adding a function
Updating an employee record for testingHow to do it...How it works...Adding attributesHow to do it...How it works...Adding a functionHow to do it...How it works...There's more...Testing the workflowHow to do it...How it works...
Creating a lookup
Creating a Success/Fail lookupHow to do it...How it works...See alsoAdding an error message attributeHow to do it...How it works...
Creating a subprocess
Creating a subprocessHow to do it...How it works...Adding a validate employee functionHow to do it...How it works...Adding a validate absence type functionHow to do it...How it works...Adding a validate absence dates functionHow to do it...How it works...Creating end functionsHow to do it...How it works...Joining the functionsHow to do it...How it works...Adding a subprocess to a parent processHow to do it...How it works...Testing the workflowHow to do it...How it works...There's more...
Creating messages
Creating an absence approval messageHow to do it...How it works...Adding attributes to our approval messageHow to do it...How it works...Creating a rejection messageHow to do it...How it works...Adding attributes to our rejection messageHow to do it...How it works...Creating an invalid XML messageHow to do it...How it works...Adding invalid XML message attributesHow to do it...How it works...
Sending notifications and processing responses
Creating an absence approval notificationHow to do it...How it works...Creating an absence rejection notificationHow to do it...How it works...Creating invalid XML notificationHow to do it...How it works...Adding notifications to the process diagramHow to do it...How it works...Mapping the notificationsHow to do it...How it works...Testing the workflowHow to do it...How it works...Viewing the notifications and workflow diagramsHow to do it...How it works...
Calling an API
Creating a function to call the database packageHow to do it...How it works...Adding a function to a processHow to do it...How it works...Testing the workflowHow to do it...How it works...
6. Utilities
Introduction
Setting the environment variables
Setting the environment on the application serverHow to do it...How it works...Setting the environment on the database serverHow to do it...How it works...
Starting and stopping an environment
Starting an environmentHow to do it...How it works...Stopping an environmentHow to do it...How it works...
Creating a custom schema
Making a new environment parameterHow to do it...Running AutoConfig (adautocfg.sh)How to do it...How it works...There's more...Creating a CUSTOM schema directory structureHow to do it...How it works...Creating a new tablespaceHow to do it...How it works...Creating a database userHow to do it...How it works...Registering an Oracle schemaHow to do it...How it works...Registering an Oracle userHow to do it...How it works...There's more...
Extracting data using FNDLOAD
Extracting a lookup using FNDLOADHow to do it...How it works...Extracting a Descriptive Flexfield using FNDLOADHow to do it...How it works...Extracting a concurrent program using FNDLOADHow to do it...How it works...Extracting a request set using FNDLOADHow to do it...How it works...Extracting a profile option using FNDLOADHow to do it...How it works...Extracting a form and function using FNDLOADHow to do it...How it works...There's more...Extracting a menu using FNDLOADHow to do it...How it works...Extracting a request group using FNDLOADHow to do it...How it works...Extracting a responsibility using FNDLOADHow to do it...How it works...Extracting a personalization using FNDLOADHow to do it...How it works...Extracting a message using FNDLOADHow to do it...How it works...Downloading multiple objectsHow to do it...How it works...
Uploading using FNDLOAD
Uploading a lookup using FNDLOADHow to do it...How it works...Uploading a Descriptive Flexfield using FNDLOADHow to do it...How it works...Uploading a concurrent program using FNDLOADHow to do it...How it works...Uploading a request set using FNDLOADHow to do it...How it works...Uploading a profile option using FNDLOADHow to do it...How it works...Uploading a form and function using FNDLOADHow to do it...How it works...Uploading a menu using FNDLOADHow to do it...How it works...Uploading a request group using FNDLOADHow to do it...How it works...Uploading a responsibility using FNDLOADHow to do it...How it works...Uploading a personalization using FNDLOADHow to do it...How it works...Uploading a message using FNDLOADHow to do it...How it works...Modifying the LDT fileHow 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

Content preview from Oracle E-Business Suite R12 Core Development and Extension Cookbook

Adding insert, update, and delete events

Now that we have created the forms objects, it is time to start adding some code. We need to add code to perform inserts, updates, and deletes. As we have based the form on views, we need to trigger the events and then we need to write code to call database procedures to transact data. There are four triggers we need to create on each block where we need to perform transactions. In this example, the only block where we want to do any transactions is the PER_SOCIETIES block. When we insert data, we will also need to increment a sequence number for the SOCIETY_ID column. We will need to perform the following tasks to trigger and code database transactions within our form:

Creating a program unit package specification ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook

Publisher Resources

ISBN: 9781849684842Other

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Oracle E-Business Suite R12 Core Development and Extension Cookbook

by Andy Penver

Adding insert, update, and delete events

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.