Sunday, January 4, 2015

Dependant LOV in OAF Page

Pre-Requisite 

Do complete the “External LOV” exercise.

Step 1: Verify the below properties

Select “ExternalLovRN.xml” -> Structure Pane -> ProjectId



Step 2: Create a New VO for Dependant LOV

Right Click on “ExternalLovProject” -> New -> Business Tier -> ADF Business Components -> View Object




Enter Package and Name


Place this SQL

SELECT project_id projectid,
       task_id taskid,
       task_number tasknumber,
       task_name taskname
  FROM pa.pa_tasks




Step 3: Attach Dependant LOV to Application Module

Right Click on ExternalLovAM -> Edit ExternalLovAM


Data Model -> under oracle.apps.fnd.externallov.server

Choose DependantLovVO, do rename DependantLovVO1 -> DependantLovVO in the Name section and move to right.
 


Step 4: Create a New Region for Dependant LOV

Right Click on “ExternalLovProject” -> New -> Web Tier -> OA Components -> Region


Enter Name, Package & Style



Step 5: Select DependantLovRN.xml Go to Structure Pane Right click on DependantLovRN -> New -> table Using Wizard


Select Application Module oracle.apps.fnd.externallov.server.ExternalLovAM and DependantLovVO.


Region Style: table



Select All the Fields.



Go to DependantLovVO Property Inspector, change the scope to Public.



Step 6: Create an Item (Form Value) ProjectIdJoin to store the Project Id for dependant LOV.

Right Click on MainRN -> New -> Item


Update the properties

ID
ProjectIdJoin
Item Style
formValue
Data Type
NUMBER


The following diagram will help you to understand the Dependant Lov Logic.





Step 7: New LOV Mappings

Select ExternalLOVPG go to structure pane PageLayoutRN -> ProjectName -> lovMappings 
Right click on it.

New -> lovMap

ID
ProjectIdMap
Lov Region Item
ProjectId
Return Item
ProjectIdJoin



 Step 8: Right click on MainRN -> New -> messageLovInput




Update the below properties


ID
TaskName
Item Style
messageLovInput
External Lov
/oracle/apps/fnd/externallov/webui/DependantLovRN
Maximum Length
20
Prompt
Task Name
Length
20


Update the LOV mapping properties

ID
TaskLovMap
Lov Region Item
TaskName
Return Item
TaskName
Required
FALSE
Programmatic Query
TRUE


Step 9: Add New LOV Mapping in TaskName

ID
ProjectIdTaskMap
Lov Region Item
ProjectId
Criterial Item
ProjectIdJoin
Required
TRUE
Programmatic Query
FALSE


Step 10: Save all your work and run the ExternalLovPG.xml




Congratulations, you have done it!

1 comment:

  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