About Lists of Values

A list of values is a defined set of values that a report consumer can select from to pass a parameter value to your data source.

If you define a menu type parameter, the list of values provides the menu of choices. You must define the list of values before you define the menu parameter.

Populate the list using one of the following methods:

  • Fixed Data

    Manually enter the list of values.

  • SQL Query

    Retrieves the values from a database using a SQL query.

  • Flexfield

    Retrieves the values from a key flexfield defined in Oracle E-Business Suite. The flexfield option is only available when Oracle BI Publisher is using the Oracle E-Business Suite security model, see Adding Flexfield Parameters.