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>
Thanks a lot for sharing a great blog I was just browsing through the internet looking for some information and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject. Bookmarked this page, will come back for more keep going on it helped me a lot I have gained a lot of knowledge by reading your blog.
ReplyDeleteoracle adf training
oracle adf online training
oracle adf 11g training
Oracle adf 12c training
oracle adf training online
Thanks Amelia
DeleteThis comment has been removed by the author.
ReplyDeleteThanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle Fusion Procurement . Actually I was looking for the same information on internet for Oracle Fusion Supply Chain Management Cloud and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can learn more aboutOracle Fusion Manufacturing . By attending Oracle Fusion Financials .
ReplyDeleteI feel really happy to have seen your webpage and look forward to so many more entertaining times reading here.Same as your blog i found another one Oracle Fusion Financials.Actually I was looking for the same information on internet for Oracle Financials Cloud and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.
ReplyDelete