Basics of Value Sets in Oracle Applications

Explained below is the basics of Value Set.
What is a value set and where is it used?
Value set is primarily the List of Values(LOV) to restrict and mantain consistencies in entering or
selecting the values. It is also the place holders to allow user enter a value. Oracle Application
Object Library uses value sets as important components of key flexfields, descriptive flexfields,
and Concurrent Request Submission.
What are the Format Types the value set have?
* Character
* Number
* Time
* Standard Date, Standard Date Time
* Date, Date Time
Note that Date and Date Time value set formats are obsolete and are provided for backward
compatibility only. For new value sets, use the the format types Standard Date and Standard
Date Time.
What are the validation types?
None:
* There is no validation done for this type of value set, hence allows user to enter any value.
Independent:
* It provides a list of pre-defined values. The predefined values are entered seperately.
Dependent:
* Same like Independent Value Set, except the List of Values shown to you will depends on
which the Independent value you have selected in the Prior Segment.
* Must define your independent value set before you define the dependent value set that
depends on it.
* Must create at least one dependent value for each independent value.
Table:
* The list of value is created based on database tables
* Allows to write simple queries, joins, order by etc
* The value, meaning and ID can be used to display a value, description to the value but return
ID to the calling program or screen.
1