I have an LOV defined on an attribute of a view object. The view accessor that fetches data for this LOV is not filtered and queries data from a large table. With LOV created in ADF 12.1.3, I was seeing performance issue while selecting any value in the LOV.
Also I was seeing the below logs in the Jdeveloper console.
[142211] Evaluating Script with name:null, Type : Groovy. Expression:
[142212] ( (FormatDesc = :vc_temp_1 ) )
[142213] Evaluation result:false
[142212] ( (FormatDesc = :vc_temp_1 ) )
[142213] Evaluation result:false
After debugging for some time, I have found a resolution for this. I need to modify the ListRangeSize parameter to a positive value eg: 10 whose value is by default set to -1 in ADF 12.1.3.
<ListBinding
Name="LOV_DrugName"
ListVOName="DrugDescSearchVA"
ListRangeSize="10"
ComboRowCountHint="10"
NullValueFlag="none"
MRUCount="0">
<AttrArray Name="AttrNames">
<Item Value="DrugName"/>
</AttrArray>
<AttrArray Name="AttrExpressions"/>
<AttrArray Name="DerivedAttrNames">
<Item Value="ChemicalName"/>
<Item Value="DrugSerial"/>
</AttrArray>
<AttrArray Name="ListAttrNames">
<Item Value="Drug"/>
<Item Value="Chem"/>
<Item Value="DrugSerial"/>
</AttrArray>
<AttrArray Name="ListDisplayAttrNames">
<Item Value="Drug"/>
</AttrArray>
<DisplayCriteria
Name="findByDrugDesc"/>
</ListBinding>
Name="LOV_DrugName"
ListVOName="DrugDescSearchVA"
ListRangeSize="10"
ComboRowCountHint="10"
NullValueFlag="none"
MRUCount="0">
<AttrArray Name="AttrNames">
<Item Value="DrugName"/>
</AttrArray>
<AttrArray Name="AttrExpressions"/>
<AttrArray Name="DerivedAttrNames">
<Item Value="ChemicalName"/>
<Item Value="DrugSerial"/>
</AttrArray>
<AttrArray Name="ListAttrNames">
<Item Value="Drug"/>
<Item Value="Chem"/>
<Item Value="DrugSerial"/>
</AttrArray>
<AttrArray Name="ListDisplayAttrNames">
<Item Value="Drug"/>
</AttrArray>
<DisplayCriteria
Name="findByDrugDesc"/>
</ListBinding>