There r six diffrent types of Value sets available in Oracle Apps.

1)Independent.

2)Dependent.

3)Table.

4)Special.

5)Pair.

6)None.

Cheers

Bonthu.

The valueset are like how we define constraints in Oracle Database. In oracle Apps there are six value sets

1. Independent - The Value which we provide to the Segments are independent (Ex. Company Segment - 01 02 03) (Ex. Primary key)

2. Dependent - The Value which we provide to the dependent segments are depends upon some other value set. (Foreign Key). Ex. Major Segment is Independent Minor Segment is dependent segment which depends upon Major Segment. (Ex. Computer - Major Segment)(Mouse Keyboard - Minor segment (Depends upon Computer). To provide value to dependent segments always depends upon some other values.

3. Table - The value for these segments will be retrived from some tables in the database.

4. Special - These value set are used for reports paramaters. The Special is always used for Report Parameters where the parameters are the values from Key Flexfield.

5. Pair - Same has special but have low and high values.

there are 8 types of valuesets in apps 11.5.9. they are

none

independent

dependent

table

translated independent

translated dependent

special

pair

trns independent and trns dependent are used for multilanguage support.

--oraclehari@gmail.com