Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Checkout

Change country

Modal Close icon
Country selected Country selected
country flag United States
Country selected
country flag Great Britain
Country selected
country flag India
Country selected
country flag Germany
Country selected
country flag France
Country selected
country flag Canada
Country selected
country flag Russia
Country selected
country flag Spain
Country selected
country flag Brazil
Country selected
country flag Australia
Country selected
country flag Singapore
Country selected
country flag Hungary
Country selected
country flag Ukraine
Country selected
country flag Luxembourg
Country selected
country flag Estonia
Country selected
country flag Lithuania
Country selected
country flag South Korea
Country selected
country flag Turkey
Country selected
country flag Switzerland
Country selected
country flag Colombia
Country selected
country flag Taiwan
Country selected
country flag Chile
Country selected
country flag Norway
Country selected
country flag Ecuador
Country selected
country flag Indonesia
Country selected
country flag New Zealand
Country selected
country flag Cyprus
Country selected
country flag Denmark
Country selected
country flag Finland
Country selected
country flag Poland
Country selected
country flag Malta
Country selected
country flag Czechia
Country selected
country flag Austria
Country selected
country flag Sweden
Country selected
country flag Italy
Country selected
country flag Egypt
Country selected
country flag Belgium
Country selected
country flag Portugal
Country selected
country flag Slovenia
Country selected
country flag Ireland
Country selected
country flag Romania
Country selected
country flag Greece
Country selected
country flag Argentina
Country selected
country flag Netherlands
Country selected
country flag Bulgaria
Country selected
country flag Latvia
Country selected
country flag South Africa
Country selected
country flag Malaysia
Country selected
country flag Japan
Country selected
country flag Slovakia
Country selected
country flag Philippines
Country selected
country flag Mexico
Country selected
country flag Thailand
Country selected
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Home > Business & Other > Workflow Automation > Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook

Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook: A practical step-by-step guide to develop end-to-end extensions to Oracle E-Business Suite Release 12, with detailed illustrations and explanations

Arrow left icon
Profile Icon Andy Penver
Arrow right icon
R$339.99
Full star icon Full star icon Full star icon Half star icon Empty star icon 3.7 (11 Ratings)
Paperback Mar 2013 398 pages 1st Edition
eBook
R$80 R$271.99
Paperback
R$339.99
Subscription
Free Trial
Renews at R$50p/m
Arrow left icon
Profile Icon Andy Penver
Arrow right icon
R$339.99
Full star icon Full star icon Full star icon Half star icon Empty star icon 3.7 (11 Ratings)
Paperback Mar 2013 398 pages 1st Edition
eBook
R$80 R$271.99
Paperback
R$339.99
Subscription
Free Trial
Renews at R$50p/m
eBook
R$80 R$271.99
Paperback
R$339.99
Subscription
Free Trial
Renews at R$50p/m

What do you get with Print?

Product feature icon Instant access to your digital copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Redeem a companion digital copy on all Print orders
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR

Contact Details

Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Table of content icon View table of contents Preview book icon Preview Book

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

Chapter 2. Getting Started with OA Framework Pages

In this chapter, we will cover the following recipes:

  • Getting started with OA Framework

  • Installing the database objects

  • Setting up our development environment

  • Setting the environment variables

  • Transferring the DBC file from the application server

  • Creating a shortcut to JDeveloper

  • Creating an EBS user and assigning responsibilities

  • Adding database connections in JDeveloper

  • Setting the OC4J settings and project properties

  • Running a page

  • Creating a new project

  • Creating the model layer for a query page

  • Creating the view layer for a query page

Introduction

In this chapter, we will be looking at creating OA Framework pages. We will first look at the architecture of OA Framework pages, as this is important to understand before we start any development. Then, we will go through the process of setting up our development environment and what we will need to do to get up and running. We will then create our first page. We will create the components that we need to develop our first page. The working examples will provide a good understanding of how a page is constructed, and we will discuss various points throughout the chapter that are important to gain a sound understanding of the concepts required to start building your own pages.

At the end of the chapter, readers will have an understanding of the components required to develop and test an OA Framework page.

Getting started with OA Framework

Oracle Applications Framework (OAF) has been around for a number of years now. It was quite a big shift for Oracle with the core applications in EBS being developed in Oracle Forms. However, with the advent of Java and its utilization in web-based applications, which provided a flexible UI console and a much faster processing speed, Oracle decided to make the move from the popular and stable Oracle Forms to OAF.

Initially, the first module to be completely built using OAF within EBS was Oracle HRMS - Self Service. It was followed by other products and modules, such as iProcurement, iSupport, iStore, iRecruitement, iExpenses, and iSupplier to name a few.

OA Framework was introduced by Oracle's Applications Technology Group (ATG). They developed a framework called Oracle Applications Framework, which was based on Java 2 Platform: Enterprise Edition (J2EE) and Model View Controller (MVC) architecture. To develop OA pages, we require:

  • JDeveloper 9i: 11i Applications...

Installing the database objects

Create the database objects for this chapter before you start, by using a script provided called 7126_02_01.sh.

Getting ready

We are going to create a table, view, and synonym for the new block we will create. We will also create a package that will handle all of the database transactions, such as insert, update, and delete. Finally, we will create a sequence that will be used to generate a unique number for new records. The next section provides details of how to run the script.

Tip

Create XXHR schema

If you have not done so already, create a new custom schema called XXHR. Please refer to Chapter 8, Utilities to create the schema if you have not done so already before running the database installation script given in the next section.

How to do it...

To create the database objects required for this chapter, perform the following tasks:

  1. Create a local directory c:\packt\scripts\ch2, where the scripts are downloaded and extracted to.

  2. Open Putty and connect to the...

Setting up our development environment

Now that we understand the basics regarding the architecture of OA Framework, we are going to get started with our development environment. We will be preparing our development environment ready to create our OA Framework pages. We will perform the following tasks to install the correct IDE and connect to an EBS database instance.

Downloading and installing JDeveloper with OA extension

Our first step is to download and install JDeveloper. However, we must ensure that we download the correct version of JDeveloper with OA Extension. To get the correct version, we will first establish the version of E-Business Suite (EBS) we are on. We will then download JDeveloper from Oracle Support and install it.

How to do it...

To download and install the correct version of JDeveloper, perform the following steps:

  1. Obtain the version of EBS you are on. To do this, log on to EBS and click on the About this Page link.

    Note

    If you remember from the Setting the personalization...

Setting the environment variables

The following environment variables should be set for JDeveloper. JDEV_USER_HOME is mandatory and needs to be set before launching JDeveloper.

  • JDEV_USER_HOME points to the directory which contains my projects.

  • JDEV_JAVA_HOME points to the Java SDK that is required for development. It is not usually required to set this variable.

How to do it...

To set the JDEV_USER_HOME environment variables, perform the following:

On Windows:

  1. Right-click on My Computer or Computer, and select Properties from the menu.

  2. Click on Advanced System Settings to open the System Properties window.

  3. Click on the Advanced tab.

  4. Click on the Environment Variables button.

  5. Select the New button for user variables.

  6. In the Variable name field, enter JDEV_USER_HOME.

  7. In the Variable value field, enter the directory of the jdevhome\jdev directory, for example, C:\oaf\jdevhome\jdev as shown in the following screenshot:

  8. Click on the OK button.

On Unix, at the command prompt, run the following command:

export...

Transferring the DBC file from the application server

We will now transfer the database connection file (DBC) from the application server of our EBS environment. We will transfer this to our local directory so that we can create database connections for JDeveloper so that we can run our OAF pages locally during development.

How to do it...

To transfer the .dbc file, perform the following tasks:

  1. Open WinSCP and connect to the application server.

  2. FTP the .dbc file to your local PC from the $INST_TOP/appl/fnd/12.0.0.0/secure directory on the application server to the jdevhome\jdev\dbc_files\secure directory as shown in the following screenshot:

How it works...

We have now transferred the .dbc file that we need to create a database connection to our EBS R12 environment. The file contains the server and port details, and we will reference this file when we open up JDeveloper and create our database connection. We can put multiple .dbc files here if we want to connect to multiple instances on EBS, but...

Creating a shortcut to JDeveloper

We are now going to create a shortcut to the JDeveloper executable and put it on our desktop. For the purposes of the book, it is assumed that we are developing using a Windows operating system and therefore, we will create a shortcut to jdevw.exe, as this is the executable we use on Windows. On other operating systems, we would use the jdev.exe executable.

How to do it...

To create a shortcut to JDeveloper, perform the following:

  1. Navigate to the directory, C:\oaf\jdevbin\jdev\bin.

  2. Right-click on the jdevw.exe and select Send To | Desktop (create shortcut).

  3. Rename the shortcut on the desktop if desired, for example, Jdev R12.

How it works...

We have now created a shortcut to the Windows version of JDeveloper on our desktops. If you are using a Linux-based operating system, you will need to launch the jdev.exe instead.

Creating an EBS user and assigning responsibilities

We are now going to log in to EBS and create a user we will be using to develop our OA Framework pages. We will also assign responsibilities to the user so that we can test our connections and access the Oracle tutorials if required.

How to do it...

To create the user, perform the following:

  1. Log in to EBS with the SYSADMIN user (or a user that has access to the System Administrator responsibility).

  2. Select the System Administrator responsibility.

  3. Navigate to Security | User | Define.

  4. Enter OAF_USER in the User Name field.

  5. Enter a password oracle01 in the password field and press the TAB key.

  6. Enter the password again and press the TAB key.

  7. Set the Password Expiration to None.

  8. Navigate to the Direct Responsibilities tab.

  9. Add the following responsibilities:

    • Framework ToolBox Tutorial

    • Framework ToolBox Menu Lab (1)

    • Framework ToolBox Tutorial Labs

    • Framework ToolBox Tutorial Labs (New)

    • OA Framework ToolBox Tutorial

    • OA Framework ToolBox Tutorial Labs...

Adding database connections in JDeveloper

We are now going to create a database connection to our EBS environment. We always connect using the apps user, so you will need the <apps password> to complete this task.

How to do it...

To add a database connection, perform the following steps:

  1. Start JDeveloper.

  2. Click on the Connections tab in Applications Navigator.

  3. Right-click on the Database node, and select New Database Connection.

    The new database connection wizard will now be displayed.

  4. Click on Next on the welcome page (and check Skip this Page Next Time if desired).

  5. In the Connection Name field, type VISR12 (this is just a name for the connection and can be anything relevant), and click on Next.

  6. When prompted, enter apps in the username field and the <apps password> in the password field, that is, apps/apps and click on Next.

  7. Enter the following c onnection details:

    Note

    If you are unsure of the connection details for your environment, you can get the details from the .dbc file we transferred...

Setting the OC4J settings and project properties

OC4J stands for Oracle AS Containers for Java EE. It is essentially a lighter version of the Oracle Application Server, and it allows us to run our OAF pages locally on our PC. We will now configure our OC4J settings and set the runtime properties of each of our tutorial projects.

How to do it...

To test our configuration, perform the following:

  1. Open JDeveloper.

  2. Check the OC4J Settings in Tools | Embedded OC4J Preferences | Global | Startup.

  3. Check if the Host Name or IP Address Used to Refer to Embedded OC4J is set to Default Local IP Address, as shown in the following screenshot:

  4. Click on File | Open from the menu.

  5. Open the toolbox workspace from <JDEV_Install>\jdevhome\jdev\myprojects\toolbox.jws.

  6. Set the following project settings for each of the tutorials:

    • ExtendedLabSources

    • LabSolutions

    • SampleLibrary

    • Tutorial

To set the Tutorial runtime properties first, perform the following steps:

  1. Right-click on Applications | toolbox | Tutorial.

  2. Click...

Running a page

We will now test that we can run a tutorial OA Framework page from within JDeveloper.

How to do it...

To run the tutorial web page, perform the following steps:

  1. Right-click test_fwkturial.jsp in Applications | toolbox | Tutorial | Web Content, and select Run from the pop-up menu.

    The following .jsp page will open. This checks that the OC4J server is running. To check, we can run an OA Framework page click on the Hello, World!.

    The following tutorial of Hello, World! page will open:

How it works...

We have now tested that the OC4J server runs locally on our machine and that we can run an OA Framework page. Therefore, we have tested our connectivity and can now get down to developing our own OA Framework page.

Note

There can be problems connecting to an EBS environment through a VPN connection and running an OC4J server locally. You may well get a connection refused error message when attempting to run the test page. Ensure that the OC4J Settings in Tools | Embedded OC4J Preferences...

Creating a new project

Okay, now that we have set up our development environment, we are ready to create our first project. We will perform the following tasks to create a project and set up our runtime parameters for the project:

  • Creating a new workspace and project

  • Setting the project runtime parameters

Creating a new workspace and project

We are now ready to get started. We first of all need to create a new workspace and project.

How to do it...

To create a new workspace, proceed with the following steps:

  1. In JDeveloper, in the Applications Navigator tab, right-click on Applications and select New OA Workspace from the pop-up menu.

  2. In the New Oracle Applications Workspace window, enter the following details:

    • File Name: MyOAWorkspace.jws

    • Directory Name: C\:oaf\jdevhome\jdev\myprojects

  3. Check the Add a New OA Project checkbox.

  4. Click on OK.

    A summary of the steps is shown in the following screenshot:

    The new project wizard will now open when OK is clicked.

  5. When the Oracle Applications Project Wizard...

Creating the model layer for a query page

In the next couple of recipes, we will be creating a search screen. The search screen will be based upon a view, but we will not create an entity object. If we are not performing database transactions, we do not need to create an entity object, although we will do that later in the chapter. We will be creating our application module to search for employees. Therefore, we need to create an application module and view object, and link them together. We will then test that we can return records from EBS using the Oracle Business Component Browser. We will test the configuration before we start creating the user interface in the next recipe. It is really important for us to check that we have successfully set up our application module before we go on to create the user interface. To do this, we will perform the following tasks:

  • Creating the application module (AM)

  • Creating a view object (VO)

  • Linking the view object to the application module (VO to AM)

  • Testing...

Creating the view layer for a query page

Now that we have created our application module and successfully tested it, we will go on to create our user interface. We will create a page that allows us to query data based upon the attributes in our application module. The page we create will look as follows at the end of this recipe:

To achieve this we will perform the following tasks:

  • Adding a page (PG)

  • Adding a query region (RG)

  • Adding a results region (RG)

  • Setting attribute properties

  • Testing the page

Adding a page (PG)

We need to create the page first before we can add any regions. A default OA Framework page will already have the corporate branding. We will create a page with just the corporate branding and a line of text to test the page.

How to do it...

To create a page object, perform the following steps:

  1. In the Application Navigator tab, right-click on OAPacktProject.

  2. Select New from the pop-up menu.

  3. In the New Gallery window, navigate to Web Tier | OA Components and select Page from the Items:...

Left arrow icon

Page 1 of 15

Right arrow icon

Key benefits

  • Gain key skills learning to extend Oracle E-Business Suite Release 12
  • Learn how to personalize Oracle Application Framework (OAF) pages and understand the structure of an OA Framework page
  • Set up a JDeveloper with OA Framework extension and configure a development environment
  • Develop OA Framework pages with advanced features such as a simple query page and master detail page

Description

Oracle's suite of applications is used by many major businesses and public sector organizations throughout the world. Oracle E-Business Suite is the most comprehensive suite of integrated, global business applications that enable organizations to make better decisions, reduce costs, and increase performance. The book will show you how to build different types of extensions with different toolsets. It will take you from start to finish with fully working examples.This book will show readers a wide variety of step-by-step examples of how to extend Oracle E-Business Suite Release 12 in a number of areas. The book focuses on OA Framework personalization and development, WebADI, and BI Publisher. It will take readers through the process of how to get started and what tools are needed. It will explain how to develop working examples and how to deploy them within Oracle E-Business Suite Release 12. Learn how to extend Oracle E-Business Suite (EBS) Release 12, using detailed examples to work through how various components are configured and how we can extend standard functionality. The book focuses on OA Framework personalization and development, desktop integration (formerly WebADI), and BI Publisher and each chapter will introduce the topic before going through working examples from start to finish. There are plenty of detailed illustrations throughout each chapter giving clear instructions of what we are doing and why. Each topic will develop a solution that will utilize common core components of a subject area. It 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.

Who is this book for?

This book is written for those who want to learn how to develop extensions in Oracle E-Business Suite. If you are involved in developing or supporting an e-business suite implementation you should find this book very useful. The book is detailed and therefore minimal technical expertise is required. It is suitable for those new to E-Business Suite or those wanting to broaden their knowledge who may want to use the book to brush up on their skills.

What you will learn

  • Get an overview of the architecture of release 12; learn about the file system and where files need to go
  • Gain an understanding of how we can personalize OA Framework pages in Oracle E-Business Suite (EBS)
  • Gain an understanding of the architecture of an OA Framework page
  • Install JDeveloper with OA Extension and set up a development environment
  • Deploy an OA Framework page in Oracle E-Business Suite (EBS) and run it through the application
  • Learn how to use BI Publisher for authoring, managing, and delivering highly-formatted documents
  • Create BI Publisher template files and then distribute populated templates to the file system and via email
  • Learn to configure a browser and MS office settings in preparation for use with desktop integrator
Estimated delivery fee Deliver to Brazil

Standard delivery 10 - 13 business days

R$63.95

Premium delivery 3 - 6 business days

R$203.95
(Includes tracking information)

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Mar 26, 2013
Length: 398 pages
Edition : 1st
Language : English
ISBN-13 : 9781849687126
Vendor :
Oracle
Category :
Business & Other
Languages :
Java
Concepts :
Workflow Automation
Tools :
Oracle E-Business Suite

What do you get with Print?

Product feature icon Instant access to your digital copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Redeem a companion digital copy on all Print orders
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR

Contact Details

Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Estimated delivery fee Deliver to Brazil

Standard delivery 10 - 13 business days

R$63.95

Premium delivery 3 - 6 business days

R$203.95
(Includes tracking information)

Product Details

Publication date : Mar 26, 2013
Length: 398 pages
Edition : 1st
Language : English
ISBN-13 : 9781849687126
Vendor :
Oracle
Category :
Business & Other
Languages :
Java
Concepts :
Workflow Automation
Tools :
Oracle E-Business Suite

Packt Subscriptions

See our plans and pricing
Modal Close icon
R$50 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
START FREE TRIAL
BUY NOW
R$500 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just R$25 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW
R$800 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just R$25 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW

Frequently bought together

Oracle E-Business Suite 12 Financials Cookbook
Oracle E-Business Suite 12 Financials Cookbook
Read more
Aug 2011 384 pages
Full star icon 2.6 (5)
eBook
eBook
  • eBook eBook R$80
  • Paperback Paperback R$428.99
R$80 R$343.99
R$428.99
Oracle E-Business Suite R12 Core Development and Extension Cookbook
Oracle E-Business Suite R12 Core Development and Extension Cookbook
Read more
May 2012 480 pages
Full star icon 4 (2)
eBook
eBook
  • eBook eBook R$80
  • Paperback Paperback R$367.99
R$80 R$294.99
R$367.99
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
Read more
Mar 2013 398 pages
Full star icon 3.7 (11)
eBook
eBook
  • eBook eBook R$80
  • Paperback Paperback R$339.99
R$80 R$271.99
R$339.99
Stars icon
Total R$ 1,136.97
Oracle E-Business Suite 12 Financials Cookbook
R$428.99
Oracle E-Business Suite R12 Core Development and Extension Cookbook
R$367.99
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
R$339.99
Total R$ 1,136.97 Stars icon

Table of Contents

8 Chapters
Personalizing OA Framework Pages Chevron down icon Chevron up icon
Personalizing OA Framework Pages
Introduction
Getting started with personalizations
Setting the personalization profile options
Discovering information about a page
Clearing the cache
Creating a user-level personalization
Adding tool tips
Creating an item
Re-ordering items on a page
Adding a button to a page
Hiding a button on a page
Making a field required
Adding a flexfield to a page
Using SPEL to trigger personalizations
Deactivating personalizations
Deleting personalizations
Getting Started with OA Framework Pages Chevron down icon Chevron up icon
Getting Started with OA Framework Pages
Introduction
Getting started with OA Framework
Installing the database objects
Setting up our development environment
Setting the environment variables
Transferring the DBC file from the application server
Creating a shortcut to JDeveloper
Creating an EBS user and assigning responsibilities
Adding database connections in JDeveloper
Setting the OC4J settings and project properties
Running a page
Creating a new project
Creating the model layer for a query page
Creating the view layer for a query page
Creating a Master Detail Page in OA Framework Chevron down icon Chevron up icon
Creating a Master Detail Page in OA Framework
Introduction
Creating the model layer for a master detail page
Creating a master region
Creating a detail region
Deploying a page to EBS
Adding a Creation Page and LOV Region in OA Framework Chevron down icon Chevron up icon
Adding a Creation Page and LOV Region in OA Framework
Introduction
Creating a page to insert and update records
Passing the parameters
Creating a list of values
Adding a link to a region
Running a page in the debug mode
Advanced OA Framework Chevron down icon Chevron up icon
Advanced OA Framework
Introduction
Navigating between OA Framework pages
Updating records
Adding a validation to the page
Calling PL/SQL from the OAF page
Adding a decision message
Partial Page Rendering
Viewing a page from EBS
Transferring the files
BI Publisher Chevron down icon Chevron up icon
BI Publisher
Introduction
Generating XML output using a concurrent program
Making a concurrent program available to a user
Using Oracle BI Publisher Desktop software to create a rich text format (RTF) template
Creating a Data Definition
Defining a template
Running a BI Publisher report
Generating PDF and Excel output using an RTF template
Implementing BI Publisher Bursting (e-mail)
Implementing BI Publisher Bursting (file system)
Desktop Integration Chevron down icon Chevron up icon
Desktop Integration
Introduction
Installing the database objects
Getting started with desktop integration
Configuring the browser and MS Office settings
Registering a table and its columns within Oracle E-Business Suite
Creating a custom integrator
Creating a function for an integrator
Adding an integrator to a menu
Adding advanced features to an integrator
Defining the importer
Utilities Chevron down icon Chevron up icon
Utilities
Introduction
Setting the environment variables
Starting and stopping an environment
Creating a custom schema

Recommendations for you

Left arrow icon
Mastering PyTorch
Mastering PyTorch
Read more
May 2024 558 pages
Full star icon 4.7 (20)
eBook
eBook
  • eBook eBook R$80
  • Paperback Paperback R$289.99
R$80 R$231.99
R$289.99
Microsoft 365 and SharePoint Online Cookbook
Microsoft 365 and SharePoint Online Cookbook
Read more
Feb 2024 640 pages
Full star icon 4.8 (23)
eBook
eBook
  • eBook eBook R$80
  • Paperback Paperback R$222.99
R$80 R$178.99
R$222.99
Tools and Skills for .NET 8
Tools and Skills for .NET 8
Read more
Jul 2024 778 pages
Full star icon 5 (12)
eBook
eBook
  • eBook eBook R$80
  • Paperback Paperback R$267.99
R$80 R$213.99
R$267.99
Information Theory
Information Theory
Read more
Nov 2024 294 pages
eBook
eBook
  • eBook eBook R$53.99
R$53.99
The Music Producer's Ultimate Guide to FL Studio 21
The Music Producer's Ultimate Guide to FL Studio 21
Read more
Jun 2023 462 pages
Full star icon 5 (11)
eBook
eBook
  • eBook eBook R$80
  • Paperback Paperback R$222.99
R$80 R$178.99
R$222.99
Workflow Automation with Microsoft Power Automate, Second edition
Workflow Automation with Microsoft Power Automate, Second edition
Read more
Aug 2022 424 pages
Full star icon 4.3 (36)
eBook
eBook
  • eBook eBook R$80
  • Paperback Paperback R$278.99
R$80 R$222.99
R$278.99
Mastering QuickBooks 2024
Mastering QuickBooks 2024
Read more
Dec 2023 570 pages
Full star icon 4.6 (19)
eBook
eBook
  • eBook eBook R$80
  • Paperback Paperback R$194.99
R$80 R$155.99
R$194.99
Programming Microsoft Dynamics 365 Business Central
Programming Microsoft Dynamics 365 Business Central
Read more
Oct 2024 466 pages
Full star icon 5 (1)
eBook
eBook
  • eBook eBook R$80
  • Paperback Paperback R$250.99
R$80 R$200.99
R$250.99
Unreal Engine 5 Character Creation, Animation, and Cinematics
Unreal Engine 5 Character Creation, Animation, and Cinematics
Read more
Jun 2022 598 pages
Full star icon 4.7 (16)
eBook
eBook
  • eBook eBook R$80
  • Paperback Paperback R$445.99
R$80 R$356.99
R$445.99
Power Apps Tips, Tricks, and Best Practices
Power Apps Tips, Tricks, and Best Practices
Read more
Nov 2024 430 pages
Full star icon 4.5 (2)
eBook
eBook
  • eBook eBook R$80
  • Paperback Paperback R$250.99
R$80 R$200.99
R$250.99
Right arrow icon

Customer reviews

Top Reviews
  • Top Reviews
  • Most Recent
Rating distribution
Full star icon Full star icon Full star icon Half star icon Empty star icon 3.7
(11 Ratings)
5 star 27.3%
4 star 45.5%
3 star 9.1%
2 star 9.1%
1 star 9.1%
Filter icon Filter
Top Reviews
  • Top Reviews
  • Most Recent

Filter reviews by

Kawal Jun 13, 2013
Full star icon Full star icon Full star icon Full star icon Full star icon 5
In March 2013, First book dedicatedly on OAF was published. This book "Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook" is authored by Andy Penver, who is having around 18 years of experience around Oracle E-Business Suite applications. In this post I will share my review for this book for you.Out of the 8 chapters of the book, five of them are dedicated to Oracle Application Framework's personalization and customization of OAF pages within E-Business Suite Applications. This book is suitable for both beginners who have little knowledge on OAF as well as for experience developers who wants to know additional advanced OAF features and concept. It provides step to step guide for performing various personalization and customization of E-Business Suite Applications. Here is the list of contents that are covered as part of this book Chapter 1, Personalizing OA Framework PagesProvides detailed and step to step information for performing various personalizations in E-Business Suite Applications. It explains different types of personalizations, its levels, and various profile options that needs to be set for performing personalization. Also, it explains details about responsibilities that are used for administering and migrating personalizations. Chapter 2, Getting Started with OA Framework PagesGives an overview of the architecture and methodology of OA Framework and various components of OA Framework. It also provides detailed information on setting up the development environment for development of OAF pages. Also, it gives a step to step guide for creating a query page in OAF. Chapter 3, Creating a Master Detail Page in OA FrameworkExplains the concept of Master-Details pages and provides a good understanding on the development of Master Detail page using OA Framework. It explains the deployment process for OAF pages and their registration within E-Business Suite Applications. Chapter 4, Adding a Creation Page and LOV Region in OA FrameworkFocuses on steps involved in creation of a page that allows to insert and update records to the database. It shows how we can write programmatic logic in various classes such as Entity Object Class, Application Module Class etc. It also has a section that explains how we can debug OA pages using Jdeveloper debugger. Chapter 5, Advanced OA FrameworkIs about the advanced features of OA Framework. It explains about programmatic navigation between OAF pages, passing parameters between pages, adding validations to entity object class and calling PLSQL from OAF pages. Another important concept that is explained as part of this chapter is Partial Page Rendering. Chapter 6, BI PublisherThis chapter provides an overview on how we can integrate BI Publisher with E-Business Suite Applications. It provides recipes to create report templates, generating XML data and support for different output formats. Chapter 7, Desktop IntegrationThis chapter explains the details about integration of desktop applications such as Microsoft Word, Excel etc. with Oracle Applications using WebADI. Chapter 8, UtilitiesIt explains about some of the utilities provided by oracle for migrating objects between environments. Also, it explains detailed step to step guide on who we can create a custom schema within oracle applications.Overall, "Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook" by Andy Penver is a great book and a must buy for all the E-Business Suite Developers who want to learn the basics as well as advanced features on Oracle Application Framework. You can buy the book from here.ThanksAJ
Amazon Verified review Amazon
Anil May 09, 2013
Full star icon Full star icon Full star icon Full star icon Full star icon 5
When implementing self service these days understanding personalisation (OA framework) is key. This book summarises what volumes of Oracle literature details. Good for the starter, project manager, analysts and developers. Clear concise instructions and woked examples. It gives that shot of experience in an instance. Thanks to the author for putting this complex matter in a simplified form.
Amazon Verified review Amazon
aestrada Jun 14, 2013
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Great book!!!Excellent source of information to understand Personalization and OA Framework pages as the Key to implement Self-Service extensions focused on Oracle EBusiness Suite R12 and OA Framework pages.The examples are real good for hands-on exercises to get a better knowledge of the OA concepts.Besides the first five chapters about OA Framework, the author dedicate two chapters to BI and Desktop integration and the final chapter to oracle utilities for migrating objects and how to create custom schema in Oracle Applications.Overall it is great resource for any developer at any level, beginners or experienced.Disclaimer: I got electronic format of book from publisher for review.
Amazon Verified review Amazon
Ketan Jun 01, 2013
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
This book provides a good insight into the complex topic of OAF Development. The book covers the topic in quite detail. I will be able to use some of the information from this book for several of our customizations in our Oracle EBS environment.
Amazon Verified review Amazon
Bryan Gardner Apr 23, 2013
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
This book is helping me take what I already know about integration with other ERP systems and apply it to the E-Business suite. Also liked the section on BI Publisher.
Amazon Verified review Amazon

People who bought this also bought

Left arrow icon
Workflow Automation with Microsoft Power Automate, Second edition
Workflow Automation with Microsoft Power Automate, Second edition
Read more
Aug 2022 424 pages
Full star icon 4.3 (36)
eBook
eBook
  • eBook eBook R$80
  • Paperback Paperback R$278.99
R$80 R$222.99
R$278.99
101 UX Principles – 2nd edition
101 UX Principles – 2nd edition
Read more
May 2022 454 pages
Full star icon 4.7 (60)
eBook
eBook
  • eBook eBook R$80
  • Paperback Paperback R$250.99
  • Audiobook Audiobook R$233.99
R$80 R$200.99
R$250.99
R$233.99
Mastering PostgreSQL 15
Mastering PostgreSQL 15
Read more
Jan 2023 522 pages
Full star icon 4.9 (7)
eBook
eBook
  • eBook eBook R$80
  • Paperback Paperback R$345.99
R$80 R$276.99
R$345.99
Mastering Microsoft Dynamics 365 Business Central
Mastering Microsoft Dynamics 365 Business Central
Read more
Mar 2024 684 pages
Full star icon 4.9 (17)
eBook
eBook
  • eBook eBook R$80
  • Paperback Paperback R$278.99
R$80 R$222.99
R$278.99
Learn Blender Simulations the Right Way
Learn Blender Simulations the Right Way
Read more
Nov 2022 368 pages
Full star icon 4 (14)
eBook
eBook
  • eBook eBook R$80
  • Paperback Paperback R$250.99
R$80 R$200.99
R$250.99
Right arrow icon

About the author

Profile icon Andy Penver
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.
Read more
See other products by Andy Penver
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is the digital copy I get with my Print order? Chevron down icon Chevron up icon

When you buy any Print edition of our Books, you can redeem (for free) the eBook edition of the Print Book you’ve purchased. This gives you instant access to your book when you make an order via PDF, EPUB or our online Reader experience.

What is the delivery time and cost of print book? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela
What is custom duty/charge? Chevron down icon Chevron up icon

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order? Chevron down icon Chevron up icon

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges? Chevron down icon Chevron up icon

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

  • If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
  • Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.
How can I cancel my order? Chevron down icon Chevron up icon

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy? Chevron down icon Chevron up icon

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

  1. If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
  2. Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
  3. You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
  4. Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
  5. If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
  6. Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged? Chevron down icon Chevron up icon

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use? Chevron down icon Chevron up icon

You can pay with the following card types:

  1. Visa Debit
  2. Visa Credit
  3. MasterCard
  4. PayPal
What is the delivery time and cost of print books? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela