Saturday, January 3, 2015

External LOV in OAF

1. Create a New Workspace and Project

Right Click Applications -> New OA Workspace



Enter Workspace Name and Click OK


Enter Project Name and Default Package then click Next


2. Create a New Application Module

Right Click on ExternalLovProject -> New -> ADF Business Components -> Application Module

Enter Package and Application Module Name then Click Next.



3. Create a New View Object (VO)

Right click on EnternalLovProject -> New -> ADF Business Components -> View Object





VO Select Statement

SELECT project_id projectid,
       segment1 projectnumber,
       name projectname

  FROM pa.pa_projects_all

Click Next till SQL Statement Window. (Step 5 of 8)



Step 4: Attach VO to AM

Right Click on ExternalLovAM -> Edit ExternalLovAM


Data Model -> ExternalLovVO
Update the Name ExternalLovVO1 -> ExternalLovVO
Move to Right then click on OK



5. Create a New OA Page

Right Click on EnternalLovProject -> New -> OA Components -> Page




Name: ExternalLovPG
Package: oracle.apps.fnd.externallov.webui 


Step 6: Create a LOV Region

Right Click on EnternalLovProject -> New -> OA Components -> Region





Attribute
Property
Name
ExternalLovRN
Package
oracle.apps.fnd.externallov.webui
Region Style
listOfValues
Scope
Public




7. Select ExternalLovRN. Right click on ExternalLovRN in Structure pane and click table using wizard. In the wizard choose the oracle.apps.fnd.externallov.server.ExternalLovAM and select the ExternalLovVO.



Region ID: ExternalLovRN

Region Style: table




Move the fields to Right


Click Next and Finish it.



8: Modify the Field Properties



9: Create a New Page Layout Region and Container Region for Lov
Select ExternalLovPG

ID: PageLayoutRN
AM Definition: oracle.apps.fnd.externallov.server.ExternalLovAM
Window Title: External LOV Window
Title: Project LOV

Right click PageLayoutRN and click new Region

ID: MainRN

Region Style: messageComponentLayout

10. Right click the MainRN and click new messageLovInput

ID: ProjectName
External Lov: /oracle/apps/fnd/externallov/webui/ExternalLovRN




11. Lov Mappings

ID: ProjectLovMap
LovRegionItem: ProjectName
ReturnItem: ProjectName
Criteria Item: ProjectName



12. Save your work, Run the ExternalLovPG.xml





Congratulations, you have done it!

2 comments:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete