11G : How to Create List of Values(LOV) ?

How to Create List of Values(LOV) in Jdeveloper 11.1.1.0.1 ?


Step-1 : Start JDeveloper by selecting Start > All Programs > Oracle WebLogic > JDeveloper Studio 11.1.1.0.0

Step-2 : Create a New Application and Project

Step-3 : Create the Database Connection(Ex, HRConnection for HR-schema)

Step-4 : Create ADF-BC(ex, Entity and View Object for Employee table).

Step-5 : Open Employee(EmployeesView.xml) View Object from Application Navigator.





Step-6 : Select Attribute > DepartmentId.

Step-7 : Goto LIST-OF-VALUES than click on + symbol.

Step-8 : Goto Configuration Tab on the List-of-value windows.

Step-9 : Click + symbol for LIST-DATA-SOURCE.






Step-10: select DepartmentView from Available and Sattle it to Rightside under EmployeeView than click ok.




Step-11: Now select DepartmentId from LIST-ATTRIBUTE dropdown.

Step-12: Goto UI-hint Tab.

Step-13: Select Input-text from List of value from Default list type.

Step-14: Select Department Name from Available and sattle it to Right Side.

Step-15: Check QueryListAutomatically than click OK.

Step-16: Goto ApplicationModule, select RUN from the Context menu, Click to CONNECT in next window.

Step-17: Double Click on EmployeeView1




Step-18: You can see the Browse Button for DepartmentID. Click on that.

Step-19: New Window with LOV will be open.