Descriptive Flexfields

Use descriptive flexfields to store additional information that you cannot enter into standard windows. A descriptive flexfield can have context-sensitive or global segments.

This example shows you how to set up the Receipt Information descriptive flexfield for the Receipts window with a free form field to store the employee name of the person receiving the payment. You can set up the flexfield to validate against your HR table or use a context to differentiate between headquarters employees and field employees.

Example of setting up a descriptive flexfield:

  1. Navigate to the Descriptive Flexfield Segments window.

  2. Query the flexfield with Oracle Receivables in the Application field and Receipt Information in the Title field.

  3. Uncheck the Freeze Flexfield Definition check box.

  4. In the Context Field region, uncheck the Displayed check box to hide the Context Value field.

    Note: If you do want to store context-sensitive information, for example to differentiate between headquarters and field employees, you can define the context value and its associated segments.

  5. Navigate to the Context Field Values region and select Global Data Elements.

  6. Press the Segments button. The Segments Summary window appears.

  7. Press the New button. The Segments window appears.

  8. Enter Employee Name in the Name field, ATTRIBUTE1 in the Column field, and 1 in the Number field.

  9. Press the Value Set button. The Value Sets window appears.

  10. Enter 30 Characters in the Value Set Name field.

  11. Enter 30 in the Maximum Size field.

    Note: If you want to validate against your HR table, select Table in the Validation Type poplist, press the Edit Information button for the Validation Table Information window, and provide a SQL statement for validation.

  12. Save your work and close the Value Sets window.

  13. In the Segments window, enter the value set that you just defined, 30 Characters, in the Value Set field.

  14. Make sure that the Enabled check box is checked for all items, save your work, and close the Segments and Segments Summary windows.

  15. In the Descriptive Flexfield Segments window, check the Freeze Flexfield Definition check box.

  16. Press the Compile button to run a concurrent request.

  17. After the concurrent request successfully completes, you can enter information in the flexfield of the Receipts window.

Related Topics