book

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

Name: Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
Author: Andy Penver
ISBN: 9781849687126

by Andy Penver

March 2013

Intermediate to advanced

398 pages

7h 48m

English

Packt Publishing

Read now

Unlock full access

Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
Table of Contents
Oracle E-Business Suite R12 Integration and OA Framework 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
Microsoft WordDeveloping code in EBSUNIX shell scripting

Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example codeErrataPiracyQuestions
1. Personalizing OA Framework Pages
Introduction
Getting started with personalizations
Creating a custom responsibilityHow to do it...How it works...Creating a new userHow to do it...How it works...Creating an employee recordHow to do it...How it works...Assigning a managerHow to do it...How it works...Attaching an employee to a user recordHow to do it...How it works...
Setting the personalization profile options
How to do it...How it works...
Discovering information about a page
How to do it...How it works...
Clearing the cache
How to do it...How it works...
Creating a user-level personalization
How to do it...How it works...
Adding tool tips
Adding a tool tip to a pageHow to do it...How it works...Creating new messagesHow to do it...How it works...Adding a short tip typeHow to do it...How it works...Adding a long message tip typeHow to do it...How it works...
Creating an item
How to do it...How it works...
Re-ordering items on a page
How to do it...How it works...
Adding a button to a page
How to do it...How it works...There's more...
Hiding a button on a page
Getting readyHow to do it...How it works...
Making a field required
How to do it...How it works...
Adding a flexfield to a page
How to do it...Getting the title of a descriptive flexfieldAdding a DFF segmentEnabling a flexfield on a self-service pageHow it works...
Using SPEL to trigger personalizations
Adding a SPEL statementHow to do it...How it works...Creating a functionHow to do it...Adding a function to a menuHow it works...
Deactivating personalizations
How to do it...How it works...There's more…
Deleting personalizations
How to do it...How it works...
2. Getting Started with OA Framework Pages
Introduction
Getting started with OA Framework
OAF ArchitectureUser interface XML (UIX)OA Controller (CO)Application module (AM)View object (VO)Entity object (EO)File locationsStandard filesUIX and COVO and AMEOCustom filesUIX and COVO and AMEOMDS repositoryBouncing apache
Installing the database objects
Getting readyHow to do it...How it works...
Setting up our development environment
Downloading and installing JDeveloper with OA extensionHow to do it...How it works...
Setting the environment variables
How to do it...How it works...
Transferring the DBC file from the application server
How to do it...How it works...
Creating a shortcut to JDeveloper
How to do it...How it works...
Creating an EBS user and assigning responsibilities
How to do it...How it works...
Adding database connections in JDeveloper
How to do it...How it works...
Setting the OC4J settings and project properties
How to do it...How it works...
Running a page
How to do it...How it works...
Creating a new project
Creating a new workspace and projectHow to do it...How it works...Setting the project runtime parametersHow to do it...How it works...
Creating the model layer for a query page
Creating the application module (AM)How to do it...How it works...Creating a view object (VO)How to do it...How it works...Linking the view object to the application module (VO to AM)How to do it...How it works...Testing the application module (AM)How to do it...How it works...
Creating the view layer for a query page
Adding a page (PG)How to do it...How it works...Renaming the default region (PG)How to do it...How it works...Adding a query region (RG)How to do it...How it works...Adding a results region (RG) using a wizardHow to do it...How it works...Setting item propertiesHow to do it...How it works...Testing the pageHow to do it...How it works...
3. Creating a Master Detail Page in OA Framework
Introduction
Creating the model layer for a master detail page
Creating the entity object (EO)How to do it...How it works...There's more...Creating the application module (AM)How to do it...How it works...Creating the view object (VO)How to do it...How it works...Editing the view object (VO)How to do it...How it works...Linking the view object (VO) to the application module (AM)How to do it...How it works...Testing the application module (AM)How to do it...How it works...Creating the view link (VL)How to do it...How it works...Adding the view link (VL) to the application module (AM)How to do it...How it works...Testing the application module (AM)How to do it...How it works...
Creating a master region
Adding a master region (RN)How to do it...How it works...Creating the master region (RN) itemsHow to do it...Creating columnsCreating column itemsCreating column headersHow it works...Creating the controller (CO)How to do it...How it works...Testing the pageHow to do it...How it works...
Creating a detail region
Adding a detail region (RN)How to do it...How it works...Creating the detail region (RN) itemsHow to do it...Creating columnsCreating column itemsCreating column headersHow it works...Adding a show/hide attributeHow to do it...How it works...Adding sortable headersHow to do it...How it works...
Deploying a page to EBS
Copy the files to the application serverHow to do it...How it works...Set the permissions of the .class files on the application serverHow to do it...How it works...Importing the page definitionHow to do it...How it works...Creating a functionHow to do it...How it works...Configure a menuHow to do it...How it works...Creating a custom responsibilityHow to do it...How it works...Adding our responsibility to a userHow to do it...How it works...Run the OAF pageHow to do it...How it works...
4. Adding a Creation Page and LOV Region in OA Framework
Introduction
Creating a page to insert and update records
Creating a view objectHow to do it...How it works...Linking the view object to an application moduleHow to do it...How it works...There's moreCreating a page to insert dataHow to do it...How it works...Adding a page status regionHow to do it...How it works...Creating a page buttons regionHow to do it...How it works...Creating and editing the page controllerHow to do it...How it works...Capturing an eventHow to do it...How it works...Editing the application module classHow to do it...How it works...Editing the entity object classHow to do it...How it works...There's more...
Passing the parameters
How to do it...How it works...
Creating a list of values
Creating the application moduleHow to do it...How it works...Creating the view objectHow to do it...How it works...Linking the application module to the view objectHow to do it...How it works...Creating the region for the list of valuesHow to do it...How it works...Linking the LOV region to an itemHow to do it...How it works...
Adding a link to a region
Creating a link itemHow to do it...How it works...Capturing the create item eventHow to do it...How it works...
Running a page in the debug mode
How to do it...How it works...
5. Advanced OA Framework
Introduction
Navigating between OA Framework pages
Adding logic to navigate between pages and pass parametersHow to do it...How it works...Adding code to the destination page to capture the parameters passedHow to do it...How it works...Creating a dictionary messageHow to do it...How it works...Adding logic and calling a dictionary messageHow to do it...How it works...Adding logic for a Cancel buttonHow to do it...How it works...Adding a method to roll back a transactionHow to do it...How it works...
Updating records
Adding an update iconHow to do it...How it works...Adding the logic when the update icon is clicked onHow to do it…How it works...Adding the code to process the update in the createSocietyPG pageHow to do it...How it works...Adding the updateSociety methodHow to do it...How it works...
Adding a validation to the page
How to do it...How it works...
Calling PL/SQL from the OAF page
Adding a button to execute the SQL statementHow to do it...How it works…Creating a method in the application moduleHow to do it…How it works...Calling the method from the controller classHow to do it…How it works…
Adding a decision message
How to do it...How it works...
Partial Page Rendering
Viewing a page from EBS
How to do it...How it works...
Transferring the files
How to do it...How it works...There's more...
6. BI Publisher
Introduction
Generating XML output using a concurrent program
Getting readyCreate and compile a database packageHow to do it...How to do it...Create and run an executableHow 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...Create 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...
Using Oracle BI Publisher Desktop software to create a rich text format (RTF) template
Download and install Oracle BI Publisher Desktop softwareHow to do it...How it works...Create an RTF templateHow to do it...How it works...Remove XDO field codesHow to do it...How it works...Save the template as an RTF documentHow to do it...How it works...Preview the RTF templateHow to do it...How it works...
Creating a Data Definition
How to do it...How it works...
Defining a template
How to do it...How it works...
Running a BI Publisher report
How to do it...How it works...
Generating PDF and Excel output using an RTF template
How to do it...How it works...
Implementing BI Publisher Bursting (e-mail)
Creating the bursting fileHow to do it...How it works...Running the Bursting concurrent programHow to do it...How it works...
Implementing BI Publisher Bursting (file system)
How to do it...How it works...
7. Desktop Integration
Introduction
Installing the database objects
How to do it...
Getting started with desktop integration
Configure a menuHow to do it...How it works...Create a new request groupHow to do it...How it works...Create a new responsibilityHow to do it...How it works...Assign the desktop integration responsibilities to a userHow to do it...How it works...
Configuring the browser and MS Office settings
Configure the browserHow to do it...How it works...Configure MS Office security settingsHow to do it...How it works...
Registering a table and its columns within Oracle E-Business Suite
How to do it...How it works...Checking the table has been registered in OracleHow to do it...How it works...
Creating a custom integrator
Configure the integratorHow to do it...Configure the interfaceHow to do it...Create a layout for the integratorHow to do it...How it works…Generate an integratorHow to do it…How it works…Edit the attributesHow to do it…How it works…Add the lists of valuesHow to do it…How it works…
Creating a function for an integrator
How to do it…How it works…
Adding an integrator to a menu
Adding form functions to menuHow to do it…How it works…
Adding advanced features to an integrator
How to do it…How it works…
Defining the importer
How to do it…How it works…
8. Utilities
Introduction
Setting the environment variables
Setting the environment on the application serverHow to do it...How it worksSetting 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 worksStopping 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 worksThere’s moreCreating a CUSTOM schema directory structureHow to do it...How it worksCreating a new tablespaceHow to do it...How it worksCreating a database userHow to do it...How it worksRegistering an Oracle schemaHow to do it...How it worksRegistering an Oracle userHow to do it...How it works
Index

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

Calling PL/SQL from the OAF page

In this recipe we are going to call some SQL from our page. We will add a button to the page and when a user clicks on the button, we will call a database package that will insert a record into a database table. We will perform the following tasks:

Adding a button to execute the SQL statement
Creating a method in the application module
Calling the method from the controller class

Adding a button to execute the SQL statement

We are now going to create a button. We are going to use the button to call a method that executes the piece of SQL code, which we will add afterwards.

How to do it...

To add a button, perform the following steps:

In the Application Navigator tab, click on the CreateSocietyPG.xml page.
In the Structure ...

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 Core Development and Extension Cookbook

Publisher Resources

ISBN: 9781849687126Other

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

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

by Andy Penver

Calling PL/SQL from the OAF page