How to create External Lov in OAF

Creating External Lov in OAF

Now we are going to learn about how to create the external lov in oaf.

Step1:- Create a Workspace and Project.

Step2:- Create an Application Module.

Step3:- Create a page and attach the application module.

Step4:- Now create a new VO for lov.

             Name: - KPITextLovVO

             Package: - sangu.oracle.apps.pos.lov.server  (Its better practice to create all lov vo’s under   

                               lov.server)

             Click on Next in the query section give the query for lov.

             And click on generate the java files.

Step5:- Create one AM for lov

             Name:- LovAM

             Package:- sangu.oracle.apps.pos.lov.server 

Step6:- Create a new region

             Right click on project select new== > OAComponent == > Region.

             Name :- KPITextLovRN

             Package:- sangu.oracle.apps.pos.lov.webui

             And set the below properties.

             Scope :- public

             And attach the LovAM to this region.

Step7:- Right click on the region and select new== > table using wizard.

             Next select the LovAM under dropdown list and select the lov vo

             Click next.

             Select the column which u want for lov.

             And finish.

Step8:- Now come to the main page under that create one item with style message lov input.

             Set the below properties.

             ExternalLov:- sangu.oracle.apps.pos.lov.webui.KPITextLovRN

Note:- Give the lov region u have created along with path.

            Next Provide the lovmappings

LovRegionItem :- Name of the column

Return Item:- Id of the message lov input item.

Criteria Item :- Id of the message lov input item.

This finishes the external lov run the page to see the output.