External LOV in OAF

1- Create a new Workspace (MatloobExternalLovWS), Project (MatloobExternalPR), AM  (MatloobExternalLovAM)  (Application Module as usual).

2- Create a query baseVO named (MatloobExternalLovVO) as we are not using EO so query will be used.

select application_short_name , product_code from fnd_application

3- Attach VO with AM as usual

4- Create a new Page (MatloobExternalLovPG) and set its some default properties

ID                          PageLayoutRN

AM                        Matloobexternallov.oracle.apps.po.server.MatloobexternallovAM

Window Title        Lov Window

Title                        Lov Page

5- Create a new region by right click on above created region PageLayoutRN

ID                           MainRN

Region Stype          messageComponentLayout

Note - Style is given as messageComponentlayout because we are going to create only message components that is messageLovInput item in that region

6- Create a new region by right click on Project 

Right click on LovDemo > New > Web Tier > OA Components > Region 

Set its some of properties.

Name -- ApplicationLovRN

Package -- Matloobexternallov.oracle.apps.po.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

7- Select ApplicationLovRN. Right click on ApplicationLovRN in Structure pane and click table using wizard. In the wizard choose the Matloobexternallov.oracle.apps.po.server.MatloobexternallovAM and select the MatloobexternalLovVO1 and Click Next

Region Id -- LovRN

Region style -- table

8- Shuttle the two attributes to the right side.That is application_short_name and product_name

9- Finish it.

10- Select the field application_short_name 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

10-  Attaching External LOV to Page:

Click on MatloobExternalLovPG and right click the MainRN and click new messageLovInput

External Lov -- /Matloobexternallov/oracle/apps/po/webui/ApplicationLovRN

Lov Region Item -- application_short_name

Return Item -- item1

Criteria Item -- item1

Prompt -- Application Name

Cheers. Compile and run to test.