3 List of Values

This topic provides an overview of the List of Values.

Oracle FLEXCUBE Universal Banking Development Workbench provides the developer with a user-friendly console for defining LOV’s of Oracle FLEXCUBE Universal Banking handling the high volume data with the following parameters. Following parameters/features are introduced for handling such LOVs:

• Exact Fetch
• Is Mandatory
• Minimum number of Search Character

Exact Fetch

If the Block field is of Display Type LOV , the developer can choose the exact fetch parameter for search optimization (in High Volume). If the Exact Fetch parameter is selected, the user has to provide the exact values of the field as it is present in the Database, otherwise, the system will throw the error message as an invalid value. Wildcard Searches are not permitted.

For Example: Entering 98712 in the Account Number field will fetch value only if an account with that particular number exists. In the Normal case, all account numbers beginning with the search pattern would be retrieved.

Figure 3-1 Block Field Properties- LOV

Description of "Figure 3-1 Block Field Properties- LOV"

Figure 3-2 Select Fields- Webpage Dialog

Description of "Figure 3-2 Select Fields- Webpage Dialog"

Figure 3-3 Information Message

Description of "Figure 3-3 Information Message"

Is Mandatory

This parameter should be specified during the definition of LOV in Open Development Tool. If this parameter is selected, then total wild card search (by providing blank or % in reduction fields) won’t be allowed on fields where the particular LOV is attached.

In the LOV definition screen, Is Mandatory option would be enabled for all Reduction Fields. This feature is not available for Global LOVs.

Minimum Search Character Length

If Is Mandatory is selected as Yes for any reduction field, Open Development Tool will ask for minimum search character length. By default, the value is 3.

If the field is mandatory and minimum search character length is given as n, then while searching, the user has to enter a minimum of n characters to search a particular value otherwise the system will show an error message.

Any value less than 3 will not be accepted. Open Development Tool will show an alert message in case of any rule violation. This feature is not available for Global LOVs.

Example: Customer LOV should allow searches based on is Mandatory and Minimum no of Character search character fields only and total wild card search should not be allowed.

The figure below illustrates Is Mandatory and Minimum number of Search Character fields in Open Development Tool.

Figure 3-4 List Of Values Details

Description of "Figure 3-4 List Of Values Details"

Figure 3-5 LOV Definitions- Webpage Dialog

Description of "Figure 3-5 LOV Definitions- Webpage Dialog"

Figure 3-6 List Of Values Credit Account

Description of "Figure 3-6 List Of Values Credit Account"

Figure 3-7 Information Message

Description of "Figure 3-7 Information Message"

Figure 3-8 List Of Values Credit Account

Description of "Figure 3-8 List Of Values Credit Account"