Book Image

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

By : Andy Penver
Book Image

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

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)
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Creating an item


Okay, in this recipe we are going to add an item to a screen. We can add an item to a screen without extending a page as long as the field exists in the view object of the region we are extending. A view object will nearly always contain many more data items than are visible on the screen. To find out the items that are in the view object, we need to do a little bit of investigation into the view object. Once we have checked the available items, we can personalize the page to make the items visible on the screen. We can also order the items in the region we are displaying them.

How to do it...

To add an item to a page, perform the following steps:

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

  2. Navigate to Home | Personal Information.

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

    We are going to add a new item to the Basic Details region. This item will specify the employee original start date after the Full Name field.

    However, before we add the item, we need to find out some information about the page as we need to know the view object that is used by the Basic Details region and the name of the attribute for the original start date item.

  4. Scroll down to the bottom of the page and click on the About this Page link.

  5. Then, click on the Expand All link.

  6. Scroll down until you see the details for the Basic Details region.

    We can see that the view object for this region is BasicDetailsCurrentVO.

  7. Scroll down and expand the Business Component References Details section.

  8. Click on oracle.apps.per.selfservice.personalinformation.server.BasicDetai lsCurrentVO for the basic details view object.

  9. If we look at the attributes returned by the view object, we will notice that the original start date field is called OriginalDateOfHire:

Now that we have the information about the item we want to add, we can create the item through personalization:

  1. Scroll to the bottom of the page and click on the Return to About Page link.

  2. Scroll down to the bottom of the next page and click on the Return to Page: Personal Information link.

  3. In the Personal Information page, click on the Personalize "Basic Details" link.

  4. In the Personalize Region: Basic Details screen, click on the Create Item icon for the Default Single Column: Basic Details object as shown in the following screenshot:

  5. From the Item Style list, select MessageStyledText to add a display only field.

  6. Set the values of the following properties:

    Property

    Value

    ID

    XXOrigHireDate

    Prompt

    Orig. Hire Date

    View Attribute

    OriginalDateOfHire

    View Instance

    BasicDetailsCurrentVO

  7. Click on the Apply button.

How it works...

We have now added the item, but note that we need to move the item just next to the Full Name field and also the font for the item's data is not the same as the other data. We are going to reorder the item in the region in the next recipe.