What is Value Set & validation types?

The value set is a collection (or) container of values. Whenever the value set associated with any report parameters. It provides list of values to the end user to accept one of the values as report parameter value. If the list of values needed to be dynamic and ever changing and define a table based values set. Value set defines the segment size, data format and validation technique.

1.     None                ------ validation is minimal.

2.     Independent      ------ input must exist on previously defined list of values.

3.     Dependent        ------ input is checked against a subset of values based on a prior value.

4.    

Table                ------ input is checked against values in an application table

5.     Special             ------ values set uses a flex field itself.

6.     Pair                  ------ two flex fields together specify a range of valid values.

7.     Translatable independent           ----- input must exist on previously defined list of values; translated values can be used.

8.     Translatable dependent             ----- input is checked against a subset of values based on a prior values; translated value can be used.

The name of the table where value set stores:

FND_FLEX_VALUE_SETS

The name of the table where values stores:

FND_FLEX_VALUES

FND_FLEX_VALUES_TL