Monday May 07, 2012

Dependent LOV in OAF

This blog demonstrate the creation of dependent LOV in OAF.Here I will try to create Project and Task LOVs.Task LOV is dependent on Project LOV.Whenever user choose any Project,Task LOV will display only the task pertaining to selected project.

Prerequisites Steps ( OAF BC creation )

1) Create ProjectsVO as mentioned below in xxcust.oracle.apps.fnd.pa.lov.server

 2) Create TasksVO as mentioned below in xxcust.oracle.apps.fnd.pa.lov.server


3) Assign ProjectsVO and TaskVO to ProjectsAccountingLovAM

Project Lov Creation

 1) Create a page DependentLovDemoPG in xxcust.oracle.apps.fnd.pa.webui

2) Attach ProjectsAccountingLovAM to DependentLovDemoPG

3) Create a messageLovInput item ProjectName.It will create listOfValues and lovMappings region under it.

4) Right click listOfValues region and choose "Table using wizard" under "New"

5) Navigate through the shuttle.Choose AM as xxcust.oracle.apps.fnd.pa.lov.server.ProjectsAccountingLovAM

6) Choose "Available View Usage" as "ProjectsVO1"

7) Select all attributes from "Available View Attributes" to "Selected View Attributes"

8) Rename all Ids to _LOV.Change the style of ProjectId_LOV to formValue. This step is optional.

9) Select ProjectName_LOV item and make "Search Allowed" property to True

10) Create mapping for Project Name as follows

11) Create mapping for Project Id as follows.Project Id is a formValue of type NUMBER.

Task Lov Creation

1) Create a messageLovInput ProjectTask. Follow the steps shown below.

2) Rename all Ids to _LOV.Change the style of ProjectId_Task_LOV to formValue. This step is optional.


3) Set the properties of ProjectTaskName as follows

4) Set the properties of ProjectId_Task_LOV as follows

5) Set the properties of TaskName_LOV as follows

Summary of Properties

ID

Property Name

Value

ProjectName

Select Search Criteria

True

ProjectName_LOV

Search Allowed

True

ProjectNameMap

Lov Region Item

ProjectName_LOV


Return Item

Project Name


Criteria Item

Project Name

ProjectIdMap

Lov Region Item

ProjectId_LOV


Return Item

ProjectId

ProjectTaskName

Search Allowed

True


Select Search Criteria

True

ProjectId_Task_LOV

Select Search Criteria

True

TaskName_LOV

Search Allowed

True

TaskNameMap

Lov Region Item

TaskName_LOV


Return Item

ProjectTaskName


Programmatic Query

True

TasKProjectIdMap

Lov Region Item

ProjectId_Task_LOV


Criteria Item

ProjectId


Required

True

Blue color shows the important properties to make Task LOV dependable.

Output

Choose a project.After that choose a task.You can see only task related to project will list in the second LOV.

 If you choose another project the second LOV value will vanish.

About



Oracle Apps Technical Consultant,Bengaluru Area

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today