10 Use Lists of Values in an Excel Workbook

You can configure a list of values (LOV) for a field in your workbook to allow business users to select a valid value from a drop-down list. You can also allow users to enter a search term in a search box to filter this list to find the value they want.

Oracle Visual Builder Add-in for Excel supports LOVs on business object fields including descriptive flexfields with parameter and segment type client binds. The add-in also supports lists of values for search fields, custom action payload fields, row finder variables, and row variables.

Lists of values also manage the conversion of internal ID or code values to and from user-friendly display values.