Value Set

Navigation To create value set
System Administrator >> Application >> Validation >> Set
System Administrator >> Application >> Validation >> Values

What is value set?

Value set is primarily a container for your values, you define your value set such that it can control the types of values that are allowed into the value set (either predefined or non–validated). You can specify the format of your values.



When to defining Values for Value Sets

• After you register your Flexfields & report parameters, if you are using independent or dependent value sets, you can enter values into each corresponding value set using the Segment Values form.
• Values for the Value Sets, we are defining will be kept in the Oracle Application Object Library’s tables.

How many Format Types the value set have

• Character
• Number
• Time
• Standard Date, Standard Date Time
• Date, Date Time

Is value set attached to all the fields that require validations?
A big NO



Then where lies the usage of value sets?
Answer: Broadly speaking, value sets are attached to segments in Flexfields. You can argue that value sets are also attached to parameters of concurrent program(but in reality oracle treats parameters as Descriptive Flexfields)

Specify the List Type for your value set.

• Poplist - fewer than 10 values expected
• List of Values - between 10 and 200 values expected
• Long List of Values - more than 200 values expected

What is Security type in value set?

• No Security - All security is disabled for this value set
• Hierarchical Security :- any security rule that applies to a parent value also applies to its child values.
• Non-Hierarchical Security :-  a security rule that applies to a parent value does not "cascade down" to its child values.

How many Character Formatting Options have for value set?

Numbers Only (0–9)

• We cannot prevent users from entering a value that contains the radix character.
• Cannot be used in Translatable Independent and Translatable Dependent value sets.

Uppercase Only

• Here also we cannot use in Translatable Independent and Translatable Dependent value sets.

Right–justify and Zero–fill Numbers

• If you have selected Numbers Only (0–9) flag, then it wont allow you to affect this flag.
• We are recommended to use this in Accounting Flex fields.

Minimum and Maximum Value Range

• Your Minimum/maximum value may not be longer than the maximum size you specify for this value set.
• Once you specify a range of values, you cannot define a new valid value that falls outside this range.
• The Minimum Value and Maximum Value fields can therefore allow you to create a value set with a validation type of None.

Types of Validations in value sets

Validation Type: Refers to the type of validation applied when values are entered for the fields associated with the value set

• None : The values enteres is not validated against any pre-defined set of values , the values is only validated against the format type specified.
• Independent : The value entered is validated against a pre-defined set of values
• Dependent : The value is validated against a set of values which depend on an indipendent value set .
• Table: The value entered is validated against against a list of values which are dependent on a table
• Special and Pair : The valu is validated against a set of values in another flex field
• Translatable Independent and dependent : The value is validated against a previously defined list of values.