Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook

You're reading from   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
Product type Paperback
Published in Mar 2013
Publisher Packt
ISBN-13 9781849687126
Length 398 pages
Edition 1st Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Andy Penver Andy Penver
Author Profile Icon Andy Penver
Andy Penver
Arrow right icon
View More author details
Toc

Table of Contents (15) Chapters Close

Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
1. Personalizing OA Framework Pages FREE CHAPTER 2. Getting Started with OA Framework Pages 3. Creating a Master Detail Page in OA Framework 4. Adding a Creation Page and LOV Region in OA Framework 5. Advanced OA Framework 6. BI Publisher 7. Desktop Integration 8. Utilities 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:

You have been reading a chapter from
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
Published in: Mar 2013
Publisher: Packt
ISBN-13: 9781849687126
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime