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

Adding a flexfield to a page


In this recipe, we are going to show how we can create a descriptive flexfield (DFF) and then display the flexfield on the screen. Again, we need to gather some information about the page and find out if a flexfield is available for a particular region. We will then configure a segment on the DFF and show how we can display it on the screen.

How to do it...

To add a flexfield 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 the Absence Management page.

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

  4. Click on the Create Absence button and the Enter Absence Details screen will open as shown in the following screenshot:

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

  6. Click on the Expand All link.

  7. Scroll down to the Flexfield References section and we will see what flexfields are available on this screen.

The following screenshot shows us that the PER_ABSENCE_ATTENDANCES flexfield is available:

Getting the title of a descriptive flexfield

Now, we have the flexfield name and we can add a descriptive flexfield segment to the flexfield. First, we will get the title of the Additional Absence Information DFF. To do this, perform the following steps:

  1. Log in to Oracle with the Application Developer responsibility.

  2. Navigate to Flexfield | Descriptive | Register and the Descriptive Flexfields window will open.

  3. Press the F11 key to enter a query and enter PER_ABSENCE_ATTENDANCES in the Name field.

  4. Press CTRL + F11 to execute the query and the following record should be returned.

    We can see that the PER_ABSENCE_ATTENDANCES flexfield is returned from the query. Make a note of the flexfield title Additional Absence Details.

  5. Exit the Descriptive Flexfields screen and navigate to Flexfield | Descriptive | Segments and the Descriptive Flexfields Segments window will open.

  6. Press F11 to enter a query.

  7. When in ENTER-QUERY mode, type Additional Absence Details in the Title field and press Ctrl + F11 to execute the query.

  8. If the Freeze Flexfield Definition checkbox is checked, uncheck it.

  9. Click on OK when the warning message appears.

  10. Click on the Segments button for the Global Data Elements record.

The steps taken are summarized in the following screenshot:

Adding a DFF segment

Now, we can create a new DFF segment for the Global Data Elements context as performed in the following steps:

  1. Enter the following data in the Segments Summary screen:

    Property

    Value

    Number

    45

    Name

    Test DFF

    Window Prompt

    Test DFF

    Column

    ATTRIBUTE20

    Value Set

     

    Displayed

    checked

    Required

    checked

  2. Click on the Open button.

  3. Enter the following data:

    Property

    Value

    Name

    Test DFF

    Description

    Test DFF

    Enabled

    checked

    Displayed

    checked

    Required

    unchecked

    Display Size

    10

    Description Size

    10

    Concatenated Description Size

    25

    List of Values

    Test DFF

    Window

    Test DFF

  4. When you change the Display Size field, click on OK when the warning appears.

  5. Click on Save.

  6. Close the Segments screen.

  7. Close the Segments Summary screen.

  8. Check the Freeze Flexfield Definition checkbox to recompile the flexfield definition.

  9. Click on OK when the warning appears.

  10. Click on Save and OK when a note message appears.

  11. Exit the form.

Enabling a flexfield on a self-service page

Now that we have created a DFF segment, we are going to show the flexfield in the Create Absence screen. To do this, perform the following steps:

  1. Change responsibility to the XX Test Manager Self-Service responsibility.

  2. Navigate to the Absence Management page.

  3. Click 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 Additional and scroll down to the Flex: Additional Absence Details record (which will be highlighted from the find).

  10. Click on the Personalize icon for the Flex: Additional Absence Details field.

    The steps are summarized in the following screenshot:

  11. Click on the Choose Levels Displayed button.

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

  13. Click on the Apply button.

  14. Set the Rendered at Site level to true.

  15. Click on the Apply button.

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

How it works...

We have now updated the page so that the flexfield is displayed in the Enter Absence Details screen, as shown in the following screenshot: