Creating an LOV which is detached from entity model/DB in ADF

      This post explains how to create an LOV which is detached from entity model (no database or business component validation for insertion should happen on change of the drop down value).

         To demonstrate this, let us consider a login screen which will have user name, password as input text fields and a drop down to select the county whose value will be stored in session for later use (the list of countries should be populated from database but the selection in the UI should not have effect on the database).

1) Let us create a view object for country table.

2) Once the view object is created , Create the LOV for country Id by clicking on attributes à List of values.

3)     In loginpageDef.xml add an executable (iterator).

4) Go to structure of loginpageDef.xml and add variables under executables

5) Create a variable countryIdVar under the variables

6) Now in login.jspx, drag and drop countryName from data controls

7)   Give the proper values (base data source as variables and list data source as data control.