Value Set in oracle Apps

What is value set in oracle application ?

Value set is a set or collection of different values.It also validates the value of item entered in attached flexfield segments.
Value set can be used in keyflexfileds, Descriptive flexfields and Concurrent program parameters ( Oracle Reports).

How to create Value Set in oracle Apps r12?
Navigate to system administrator or Application developer Responsibility ->Application -> validation ->Set.

  Set ->

Types of Value Sets:

1.Dependent
2.Independent
3.Table
4.None
5.Pair
6.Special
7.Translatable dependent
8. Translatable Independent

Now lets create a table value set for invoice number by using table 'RA_CUSTOMER_TRX_ALL'
Value Set name : XX_invoice_number
List Type : List of Values
Format type : Char
Maximum size : 20
Validation type : Table

Click on Edit Information:

Choose the table name from the Table Name LOV : RA_CUSTOMER_TRX_ALL
Table Application : Receivables
Value : Choose the column name of table : TRX_NUMBER
SIZE : 20

Click on Test to confirm .

Table Value set has been created.