How to Create a Dependent Parameters using Dependent Value set

By | January 20, 2014

Definition: A dependent value set is similar to an independent value set, except that the available values in the list and the meaning of a given value depend on which independent value was selected in a prior segment of the flex field structure. You can think of a dependent value set as a collection of little value sets, with one little set for each independent value in the corresponding independent value set. You must define your independent value set before you define the dependent value set that depends on it.

For example let’s take two values sets:
1. XX_CAR_MAKES (A Value set for different Car Makes (manufacturers))
2. XX_CAR_MODEL (A Value set for different Car Models of a Car Make)

The value set values should look like the below structure

Car Make (XX_CAR_MAKES) Car Model (XX_CAR_MODEL)
Maruthi Suzuki
Alto 800
Swift
Wagon R
Hyundai
Eon
i10
i20
Verna
Tata
Nano
Indica
Manza

Since car model is dependent on car make, car model value set XX_CAR_MODEL should be defined as dependent value set and car make value set XX_CAR_MAKES should be defined independent value set.

Step 1: Create Independent Value Set

Create a value set XX_CAR_MAKES as shown in the below screen shot

1

Step 2: Create Dependent Value Set

Create a value set XX_CAR_MODEL as shown in the below screen shot

2

3

Step 3: Add Values for Independent Value set

Navigate to System Administrator responsibility –> Application –> Validation –> Values
Enter value set name as XX_CAR_MAKES and click on Find button

4

Enter the values as shown in the below screen shot

5

Step 5: Add values for Dependent Value Set

Navigate to System Administrator responsibility –> Application –> Validation –> Values
Enter value set name as XX_CAR_MODEL, Independent Value as ‘Maruthi Suzuki’ and click on Find button

6_0

Enter different car models of Maruthi Suzuki as values as shown in the below screen shot

6

Similarly enter list of values for other independent values of dependent value set

7

8

Steps 6: Assign value sets to Flex Fields or Concurrent Program parameters

9

10

11

12

You can use this method when list of values are small and fixed in number. If list of values are more and values should come dynamically then we can use $FLEX$.XX_VALUE_SET_NAME method.

Read this article from oracle.com for more information on Dependent Value set.

WOW! Did you like this post? We'll send more interesting posts like How to Create a Dependent Parameters using Dependent Value set to you!
Enter your Email Address: