Oracle OAF Personalization, Adding Flexfield on OAF / HTML page

Posted on by

Oracle OAF Personalization, Adding Flexfield on OAF / HTML page 

In this task you want to set-up the descriptive flexfield in the Unprocessed Requests page in Oracle Sourcing. You will also set-up segments for the flexfield.

  1. Log in as your XXX_USER.
  2. Select the iProcurement responsibility.
  3. Select the Non-Catalog Request subtab.


  1. About this Page link to determine if there is a flexfield available on this page, and note its name and application short name. In our case, the Application Short Name is PO, and the flexfield name is PO_REQUISITION_LINES.



  1. Select the Return to Page: Unprocessed Requests link.

Task 2: Define Descriptive Flexfield Segments

  1. Go to the Home page and switch to the Application Developer responsibility.
  2. Navigate to the Descriptive Flexfield Register form, Flexfield: Descriptive > Register
  3. Query the Name field using PO_REQUISITION_LINES. Note that the Title of this flexfield is Requisition Lines. You will need that name to set-up the segments.


  1. Close the Descriptive Flexfield Register form, and open the Descriptive Flexfield Segments form, (N) Flexfields > Descriptive > Segments.
  2. Query the Descriptive Flexfield Segments by Title using Requisition Lines.


  1. Unfreeze the flexfield by deselecting the Freeze Flexfield Definition checkbox.
  2. Select OK for the warning message.


  1. Global Data Elements code, and then click the Segments button.


  1. Set the Number to 10.
  2. Set the Name to Priority.
  3. Set Column to ATTRIBUTE1.
  4. Set the Value Set to Priority
  5. Tab to the next row.
  6. OK on the Caution dialog box that opens.


  1. Set the Number to 20.
  2. Set the Name to Justification.
  3. Set Column to ATTRIBUTE2.
  4. Tab to the next row.
  5. Click OK on the Caution dialog box that opens.
  6. Save your work.


  2. Check the Freeze Flexfield Definition checkbox.
  3. Select OK for the warning message.


  1. Save your work again to compile the flexfield.


  1. When the flexfield is compiled successfully, you will get a Note window to notify you.


Task 3: Enable Descriptive Flexfield on Page

  1. Exit the forms-based Applications, and return to the Personal Home Page.
  2. Select the iProcurement responsibility.
  3. Select the Non-Catalog Request subtab.
  4. Select Personalize Page.
  5. Select Complete View.
  6. Select the Flex’s Personalize icon, and set the Rendered property at the Site level to true.
  7. Select the Labeled Field Layout: (ReqLineDffLabel) personalize icon, and set the Rendered property at the Site level to true.
  8. Select the Header: Additional Information personalize icon, and set the Rendered property at the Site level to true.
  9. Note: You MUST do this separately for the Flex, the Field Layout and the Header (which are the Flex’s container) in order to enable the descriptive flexfield.


  1. Apply your changes, and Return to the Application.



Note: There is one technique of interest to both instructors and students. Often times when dealing with OA Framework pages, there are interesting quirks that might or might not appear. Things like menu items not appearing, responsibilities not appearing, and the like. Why? Because Oracle Application Framework has a cache of run-time information, and by default that cache only gets reloaded every 15 minutes. So, here is the technique to clear the cache quicker.

  1. From the SYSADMIN user, or any user in the Application that has the Functional Administrator responsibility, choose the Functional Administrator responsibility from the Personal Home Page.
  2. Choose the Core Service tab.
  3. Choose the Caching Framework subtab.
  4. Choose the Global Configuration submenu.


  1. Choose the Clear All Cache button.
  2. Click the Yes button at the Warning page.


    If the problem was due to an Oracle Application Framework caching problem, you have now flushed the cache. Any item now required will be loaded on demand because it is no longer in the cache. Your quirk should go away.

Task 4: Create a new flexfield on the Non-Catalog Request Page

This task requires that the Requisition Lines descriptive flexfield has already had its segments defined and that the flexfield is frozen.

  1. Login to the Application as your XXX_USER.
  2. Select the XXX iProcurement responsibility.
  3. Select the Non-Catalog Request subtab.
  4. Select the Personalize Page link.
  5. Select the Complete View.
  6. Select the Create Item icon for the Page Layout: Oracle iProcurement: Shop region.
  7. Set the Level to Site.
  8. Set the Item Style to Stack Layout.
  9. Set the ID to XXX_StackLayout.
  10. Set the Prompt to XXX Additional Information.
  11. Select the Apply button.
  12. You should see your new XXX Additional Information in the Personalization Structure.
  13. Select the Create Icon on the XXX_StackLayout item.
  14. Set the Level to Site.
  15. Set the Item Style to Static Styled Text.
  16. Set the ID to XXX_FlexText.
  17. Set the CSS Class to OraInstructionTextStrong
  18. Set the Prompt to XXX Lines Flexfield.
  19. Select the Apply button.
  20. You should see your new XXX Lines Flexfield in the Personalization Structure.
  21. Select the Create Icon on the XXX_StackLayout item.
  22. Set the Level to Site.
  23. Set the Item Style to Flex.
  24. Set the ID to XXX_ReqLinesFlex.
  25. Set the Appl Short Name to PO.
  26. Set the Display Context Field to false.
  27. Set the Name to PO_REQUISITION_LINES.
  28. Set the Prompt to XXX Lines.
  29. Set the Type to descriptive.
  30. Set the View Instance to NonCatalogRequestVO.
  31. Select the Apply button.
  32. Select the Return to Application link.


Task 5: Make Your Flexfield Visible to Your Responsibility

  1. Select the Personalize Page link.
  2. Select Complete View
  3. Select the Personalize icon (not the Update Item icon) for your new Stack Layout. If you personalize just the flexfield, the Static Style Text boilerplate will still appear.
  4. Select the Choose Levels Displayed button.
  5. Select just the Site and Responsibility levels to display.
  6. Select the Apply button.
  7. Set the Rendered property to false at the Site level, and to true at the Responsibility level.
  8. Select the Apply button.
  9. Select the Return to Application link.
  10. Verify that the flexfield is only visible for your responsibility. From the Personal Home Page, choose the iProcurement responsibility, then the Non-Catalog Request subtab, to confirm.