1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Value Sets In Oracle Apps

Discussion in 'General' started by bhaskarlella, Mar 7, 2011.

  1. bhaskarlella

    bhaskarlella Guest

    Introduction

    Value Set is a collection of values. It validates the values entered by the user for a flex-field, report parameters or a concurrent.

    The navigation path: Application :- Validation :- Sets

    Value Set is associated with the following validations which holds the key to the value sets.

    Types of Validations:


    1. None :- Validation is minimal.
    2. Independent :- The data input is based on previously defined list of values.
    3. Dependent :- The data input is checked against a defined set of values.
    4. Table :- The data input is checked against values in a table.
    5. Special :- The data input is checked against a flex-field.
    6. Pair :- The data input is checked against two flex-field specified range of values.
    7. Translatable independent :- The data input is checked against previously defined list of values.
    8. Translatable dependent :- The data input is checked against defined set of values.

    Significance of $FLEX$

    $FLEX$: enables to match the prior segment with either value set name or segment name. Let v2 be the value set definition of 2nd parameter and v1 be the value set definition for the first parameter then:

    In the value set definition of v2 = value $FLEX$.v1

    Changes You Should Never Make

    You should never make these types of changes (old value set to new value set) because you will corrupt your existing key flex-field combinations data:


    1. Independent to Dependent
    2. Dependent to Independent
    3. None to Dependent
    4. Dependent to Table
    5. Table to Dependent
    6. Translatable Independent to Translatable Dependent
    7. Translatable Dependent to Translatable Independent
    8. None to Translatable Dependent
    9. Translatable Dependent to Table
    10. Table to Translatable Dependent
    Hope this gave a basic idea. Many thanks to Rakesh Sreenivasa for contributing yet another article for Get Apps Training.
     
  2. MHSHAHEN1

    MHSHAHEN1 Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    :hurray;)THANKS ALOT