How to create value set with distinct values

The problem  is  while creating a "Table Value Set" the value set  showing duplicate data.

Here is the solution for the problem.
 While creating the value set we can write a sql query in the table name.

Example: We are creating a Receipt number value set from table rcv_shipment_headers

Step 1. create the value set with all mandatory fields.

Now click on edit information:

Then write the sql query : (select distinct receipt_num from  rcv_shipment_headers)a in table name field.
Table columns Value : a.receipt_num

 

Click Test and done.

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.