12 Define LOV

This topic provides systematic instructions to define LOVs.

1. To add LOV, right-click on the ListOfValues node and select Add option from the right-click menu.
   List Of values can be defined for the function ID using LOV node
2. Specify the LOV Name field and then click OK.
   LOV name should start with LOV_<name>.
   For Example: LOV_COUNTRY
   The List Of Values Details screen displays.

   Figure 12-1 List Of Values Details

   
   

   
   Description of "Figure 12-1 List Of Values Details"

   
   
3. Specify the fields in the List Of Values Details screen.
4. Enter a valid query and click Populate.
   LOV Query window displays.

   Figure 12-2 LOV Query

   
   

   
   Description of "Figure 12-2 LOV Query"

   
   
5. Click OK.
   The List Of Values Details screen displays.

   Figure 12-3 List Of Values Details- Query

   
   

   
   Description of "Figure 12-3 List Of Values Details- Query"

   
   

   Note:

   Reduction/Column Label are mandatory. If the user won’t provide Reduction/Column Label field, an error displays on click LOV after deployment in Oracle FLEXCUBE Universal Banking.
6. After defining LOV, go to block and the corresponding field where the LOV has to be attached.
7. For Block Field Properties to attach LOV to the field follow steps as follows:
   1. Select Display Type as LOV.
   2. Select the required Lov Name from the list of all defined LOV’s.
   3. Click on the Return Fields tab.
      Return Fields Mapping tab opens.
   4. Click Default from the Lov Definition.
      The result fields maintained in the LOV query gets populated.
   5. Select the desired field (and its block) to which the result of the LOV query should have defaulted.
      If the return field is not required to have defaulted to any field in the screen, the return field value can be left blank.

      Figure 12-4 Block Field Properties

      
      

      
      Description of "Figure 12-4 Block Field Properties"

      
      

      Use of Bind Variable: If the list of values should be based on any other field value from the screen, bind variables can be used.
      For Example: Define Lov as shown in below query, where clause should contain condition with ?.

      SELECT cust_ac_no, branch_code, ccy
      from sttms_cust_account
      where cust_no = ?
      and record_stat = 'O'
      and once_auth = 'Y'
      and ac_stat_de_post = 'Y'

   6. In the block field, after selecting Return Fields, click on the Bind Variables tab.
      Bind Variables Mapping tab opens.
   7. Click Default From LOV Definition.
      New rows will be created depending on the number of bind variables provided in the LOV query.
   8. Select the bind filed in the screen (and its block ) for the LOV.
   9. Select the Data Type of the field.
      Block Field Properties screen displays.