Bonthu N Reddy

• Feb 18th, 2006

 

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.

Manivannan .S

• Feb 21st, 2006

 

  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.

poojar

 Profile Answers by poojar Questions by poojar

• Mar 3rd, 2006

 

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