here we gave the some steps to dovelop lov in page
Step
1 :- Create a New Workspace and Project
Right
click Workspaces and click create new OAworkspace and name it as CSBrahmiLovDemo.
Automatically a new OA Project is also created. Name the project as LovDemo and
package as CSBrahmi.oracle.apps.fnd.lovdemo
Steps 2 :- Create a New Application Module (AM)
Right
Click on LovDemo > New > ADF Business Components > Application Module
Name
-- LovAM
Package
-- CSBrahmi.oracle.apps.fnd.lovdemo.server
3. Create a New View Object (VO)
Right
click on LovDemo > New > Business Components > View Object
Name
-- LovVO
Package
-- CSBrahmi.oracle.apps.fnd.lovdemo.server
Note
- The VO is not based on any EO
so click next and go to the query section and paste the query
SELECT *
FROM EMP
Here we take the emp table (emp table is all ready created in over database so we use the table )
Step 4 :- Add
View Object to Root UI Application Module
Step 5 :-. Create a New Page
Right
click on LovDemo > New > Web Tier > OA Components > Page
Name
-- LovPG
Package
-- CSBrahmi.oracle.apps.fnd.lovdemo.webui
Step 6:- Select the LovPG and go to the strcuture pane where a
default region has been created
Step 7:- Right click on LovPG >New > Region(lovPLRN)
Step 8:- Select lovPLRN and set the following properties:
ID
-- LovPLRN
AM
Definition -- CSBrahmi.oracle.apps.fnd.lovdemo.server.LovAM
Window
Title -- List of values Demo Window
Title
– List of values Demo
Step 9:- Right click lovPLRN and click new
Region
ID
-- MainRN
Region
Style – messageComponentLayout
Note
- Style is given as
messageComponentlayout because we are going to create only message components
that is messageLovInput item in that region
Step 10 :- Create a New Region
Right
click on LovDemo > New > Web Tier > OA Components > Region
Name
-- EmployeeLovRN
Package
-- CSBrahmi.oracle.apps.fnd.lovdemo.webui
Region
Style -- listOfValues
Scope
-- Public
Note
- The property Scope is the key
property which makes the LOV region public and makes it usable in multiple
pages
Step :- 11. Select EmployeeLovRN. Right click on EmployeeLovRN in
Structure pane and click table using wizard. In the wizard choose the CSBrahmi.oracle.apps.fnd.lovdemo.server.LovAM
and select the LovVO1. Click Next
Region
Id -- LovRN
Region
style -- table
Step 12:- . Shuttle the two attributes to the right side.That is
EmployeeNumber and FullName
Step 13:- Click next, check the mapping and then finish
Step 14:- Select the field FullName and set the following
properties:
Search
Allowed -- True
Selective
Search Criteria – True
Note
- The first property lets users
search on these values in the LOV, and the second property ensures that the
users specify search criteria for at least one of these values to avoid a blind
query
Attaching External LOV to Page:
Step 15:- Click on LovPG and right click the MainRN and click
new messageLovInput
External
Lov -- /CSBrahmi/oracle/apps/fnd/lovdemo/webui/EmployeeLovRN
Lov
Region Item -- FullName
Return
Item -- item1
Criteria
Item -- item1
Prompt
-- Employee Name
