This week we will be learning how to create LOVs in Oracle ADF application.
– HR Schema in Oracle database.
– I am using Jdeveloper 11.1.3
On this post we will create LOV for Department Id in Simple Employee based form.
Steps to follow:
Adding Department Entity:
– Add Departments Entity by Right clicking on Vinay.model package in Model project and choose New Entity Object
Enter Name as ” Department ” and Choose Schema object as ” Department ” by pressing Browse button you can select from the list of objects as well.
Right click on Vinay.model.view package and Choose New View Object name Departments as below
– Click the green + button with List Data Source.
A create List of value wizard will open.In the configuration tab click the + sign if there is no default value is there
On clicking of the ‘+’ sign a view accessor pop up will open.Select Department View Object and shuttle to right side.
In the list attribute select department ID.Click ok.Now your department View object would like as below
In the data control palette.Select department view which we created and drag drop on the page
A wizard will open.As you can see department Id is coming as select one choice
Now your jspx page look like this.
Click run on the page. In browser you can see department Id is coming as LOV.It is easy to create.If you want to create lov from another entity object then you need to have accessor on that referring entity object.And you will use that accessor in List Data source in configuration tab.