We are having a cascading LOV -> Deaprtment, class(inputComboBoxWithLOV). Class LOV is filtered with selected value of Department. When I follow the below steps:
On Debugging, found that the viewCriteria which was applied to filter using Department is missing. The entire Where clause is missing.
This is occurring after our latest migration to 12.1.3, earlier we were using jdeveloper 11g and never faced this issue.
Any pointers about this issue will be highly appreciated.
The LOV UI hints "Filter Combo Box Using" option was unchecked, when I checked it and tried I was able to see filtered results in the dropdown.
However I did not understand why it was not picking values from existing view criteria from the view object definition related to the LOV's view accessor and why should I explicitly check this option.