9 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 custom action payload fields and descriptive flexfields with parameter and segment type client binds. The add-in also supports lists of values for search fields and row finder variables.

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