Adding Descriptive Flexfields

Reporting on descriptive flexfields is supported only for Oracle Fusion Applications.

  1. Enter the basic flexfield information:
    • Name - Enter a name for the flexfield component.

    • Flexfield Type -Select Descriptive Flexfield.

    • Lexical Type - Only Select is supported.

    • Application Short Name - Enter the short name of the Oracle Application that owns this flexfield (for example, FND).

    • Flexfield Code - Enter the flexfield code defined for this flexfield in the Register Descriptive Flexfield form, for example, FND_DFF1.

  2. Enter the flexfield details:
    • Table Alias -Specify the table alias to prefix to the column names. Use TABLEALIAS if your SELECT joins to other flexfield tables or uses a self-join.

    • Flexfield Usage Code - (Optional) Identifies for which segments this data is requested. Default value is "ALL".

  3. If your descriptive flexfield definition includes parameters, you can enter the parameters in the Parameters region.

    To enter parameters, click + to add each parameter. Enter a Label and a Value for each parameter. The Label must match exactly the label in the descriptive flexfield definition.

Including Descriptive Flexfield Reference in SQL Queries

When you create the SQL data set, you can include the descriptive flexfield using the ampersand symbol.

For example, the figure below shows &DFF_SELECT referencing of the descriptive flexfield.

When you click OK, the diagram of your data set shows the columns that are returned from your descriptive flexfield as shown below.

The columns that are returned from the key flexfield have the following limitations:

  • Element properties are disabled

  • In the data model Structure tab, you cannot edit the following fields: XML Tag Name, Value if Null, Display Name, Data Type

  • Subgrouping of descriptive flexfield elements is not supported

  • Element linking is not supported