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

Discussion in 'Oracle Apps Technical' started by kiran.marla, Dec 14, 2010.

  1. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi All,
    I have a requirement in creating table type value sets.

    Req:

    Value set: Location_vs --- this is independent type
    values : Mumbai, Bangalore

    there is one more value set named vs1, is of table type value set, in which we need to fetch the data based on value selected from Location_vs.

    if we select Mumbai, we should get attribute1 column data into vs1
    if we select Bangalore , we should get attribute2 column data into vs1.

    attribute1 and attribute2 belongs to table xxx.

    any ideas ???
    Thanks in advance.
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Hi Kiran

    Can't you create a dependent value set?
     
  3. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    No, these are dynamic values needs to fetch from the table.
     
  4. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    You can dynamically manipulate your DFF value sets where condition but not the select condition. That is you could create your second dependednt value set as a table validated value set and in it's where condition use :$FLEX$.VALUE_SET1.ID (let's assume you are storing ID for 1st value set). But you can't dynamically change the selected column. You should re-consider your design.
     
  5. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Ok , any other ideas working around this problem ?? But my value set must be of table type only.