Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
  • Toc
  • feedback
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

By : Andy Penver
3.7 (11)
close
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

3.7 (11)
By: Andy Penver

Overview of this book

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.
Table of Contents (15 chapters)
close
close
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
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Personalizing OA Framework Pages
chevron up
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
2
Getting Started with OA Framework Pages
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
3
Creating a Master Detail Page in OA Framework
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
4
Adding a Creation Page and LOV Region in OA Framework
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
5
Advanced OA Framework
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
6
BI Publisher
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)
7
Desktop Integration
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
8
Utilities
Utilities
Introduction
Setting the environment variables
Starting and stopping an environment
Creating a custom schema
Index
Index

Using SPEL to trigger personalizations

SPEL stands for Simplest Possible Expression Language. A SPEL statement will return a Boolean value of either True or False and can be used for conditionally setting a property of an item on a page.

Adding a SPEL statement

In this recipe, we are going to use SPEL to set the properties of an item. We are going to set the Read Only property based on a SPEL statement. If the SPEL statement returns True, the item will be made read only to the user.

How to do it...

To set properties using SPEL, perform the following steps:

  1. Log in to Oracle with XXUSER and select the XX Test Manager Self-Service responsibility.

  2. Navigate to the Absence Management page.

  3. Click on the Action icon for an employee record.

  4. Click on the Create Absence button.

  5. Click on the Personalize Page link.

  6. Click on the Complete View radio button.

  7. Click on the Expand All link.

  8. Press Ctrl + F to bring up the search facility on the browser.

  9. Type in Comments and scroll down to the Message Text Input: Absence Comments record (which will be highlighted from the find).

  10. Click on the Personalize icon.

  11. Click on the Choose Levels Displayed button.

  12. Shift all of the items other than Site and Responsibility back to the Available Levels side.

  13. Click on the Apply button.

  14. Set the Read Only property at the Responsibility level to SPEL.

  15. Set the Responsibility level for the SPEL statement to ${oa.FunctionSecurity.XXABSREADONLY}, as shown in the following screenshot:

  16. Click on the Apply button.

  17. Scroll down to the bottom of the page and click on the Return to Application link.

How it works...

You may notice that the comments item is now not displayed on the screen. This is because we need to create the function and add it to the menu for the SPEL condition to be returned.

Creating a function

We are now going to create a function that we will add to a menu.

How to do it...

To create a function, perform the following steps:

  1. Log in to Oracle with XXUSER and select the Application Developer responsibility.

  2. Navigate to Application | Function.

  3. Create a function with the following details:

    Item name

    Item value

    Function

    XXABSREADONLY

    User Function Name

    XX Absence Read Only

    Description

    XX Absence Read Only

    Type

    Subfunction

    The function will be displayed as shown in the following screenshot:

  4. Save the record and dismiss the confirmation message.

Adding a function to a menu

We will now add a function to a menu attached to the XX Test Manager Self Service responsibility. The function will be present in the menu, which will mean that the SPEL statement will return True.

How it works...

To add a function to a menu, perform the following steps:

  1. Log in to Oracle with XXUSER and select the Application Developer responsibility.

  2. Navigate to Application | Menu.

  3. Query back the Manager Self Service menu.

  4. Add the function XXABSREADONLY to the menu with the following details:

    Item name

    Item value

    Seq

    200

    Function

    XX Absence Read Only

  5. Save the menu and dismiss the confirmation message to compile the menu.

We can see that the function has now been added to the menu as shown in the following screenshot:

End of Section 15
Next Section
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete