Value Sets in Oracle Applications

Value Sets are a Set or List of Values (LOV) that are usually predefined and are used in Flexfields and concurrent programs. Value sets can be said as container of values.

A value set is used in Oracle Applications to restrict the values entered by a user. The values can be of any data type (Char, Number etc.)

Here, I’m explaining about defining value sets for the Descriptive Flexfield (DFF) which is enabled for Service Request Screen.

For Enabling DFF refer my post 
Descriptive Flexfield in Oracle Apps
Navigate to System Administrator Responsibility à Application à Validation à Set à Value Sets Window opens 

Type a Value Set Name, Description, Select List Type, Security Type, Format Type, Maximum Size, etc

I’m going to explain only about Independent and Dependant Validation Type here. For Creating a Value Set with validation type as Dependant, initially we have to create a Value Set with validation type as Independant.

Select Validation Type as Independent and Save.

Now, Navigate to System Administrator Responsibility à Application à Validation à Values à Find value Set window opens

Enter the Value Set Name we have created already in the Name field and click Find.

Segment Value window opens. In the Values, Effective tab, enter the values you wanted to include in Value Sets and save.

Now, Navigate to System Administrator Responsibility à Application à Validation à Set à Value Sets Window opens. Type the Value Set Name, etc and select the Validation Types as Dependant.

Now, Click on the Edit Information button. Dependant Value Set Information window opens. Select the Value Set Name we have created with validation type Independant. Enter dependant default values as None and Save. 

Now, Navigate back to Value Set Screen and Save the record.

Navigate to System Administrator Responsibility à Application à Validation à Values à Find value Set window opens. Enter the Value Set Name and Independant Value as India and Click Find.

Segment Values window opens. Enter the Values as required in the Values, Effective tab and Save. The same way you have to query for other 2 locations and enter the values and save.

Navigate to System Administrator Responsibility à Applications à Flexfield à Descriptive à Segments

Query the DFF and click Segments.

Segment Summary window opens. Enter the Segment Name and assign the Value Set Country_Locations to it. Now, Click open Button. Segments window opens. Type the Description and Check the Security enabled check box and Save. 

Same way do it for next segment and Save.

Navigate back to Descriptive Flexfield Segments, Check the Freeze Flexfield Definition check box and Compile the record.

Now, Navigate back to Service Request Screen and click on the DFF [ ]. You can see the List of Values.

Please note, if you select the Country as INDIA, States defined in the Value Sets INDIA will only be displayed.

Articles related to this post
Descriptive Flexfield in Oracle Apps
Context Sensitive Segments in DFF