This discussion is archived
5 Replies Latest reply: Nov 12, 2012 8:37 PM by user447531 RSS

Regaring Value Sets

user447531 Newbie
Currently Being Moderated
Hi All,

we had an requirement regarding value sets as we have to create 4 parameters with lov's P1 is mandatory, P2(optional), P3(date from -- optional), P4(date to -- optional) here requirement is if we select P2 than value should not be entered be P3 & P4 and if P2 is blank than we can enter data in P3 & P4, please let me know how can we solve this issue.


Many Thanks,
  • 1. Re: Regaring Value Sets
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    970123 wrote:
    Hi All,

    we had an requirement regarding value sets as we have to create 4 parameters with lov's P1 is mandatory, P2(optional), P3(date from -- optional), P4(date to -- optional) here requirement is if we select P2 than value should not be entered be P3 & P4 and if P2 is blank than we can enter data in P3 & P4, please let me know how can we solve this issue.


    Many Thanks,
    Please see old threads.

    https://forums.oracle.com/forums/search.jspa?threadID=&q=Dependant+AND+Value+AND+Set&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001
    https://forums.oracle.com/forums/search.jspa?threadID=&q=Dependant+AND+LOV&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001
    https://forums.oracle.com/forums/search.jspa?threadID=&q=Dependant+AND+ValueSet&objID=c3&dateRange=all&userID=&numResults=15&rankBy=10001

    Please do not post duplicates -- https://forums.oracle.com/forums/profile.jspa?userID=970123

    Thanks,
    Hussein
  • 2. Re: Regaring Value Sets
    user447531 Newbie
    Currently Being Moderated
    Hi Hussein,

    I tried different options as per the forum its not working thats the reason i raised request so i can get better answer, pls let me know if u are familiar.


    Thanks,
  • 3. Re: Regaring Value Sets
    597001 Journeyer
    Currently Being Moderated
    Make P3 and P4 as Special valueset. Validate the values against P2 by checking where it is NULL / it has some data. If NULL, then give an error message while the user tries to press Submit button.
    Cheers,
    ND
    Use the "helpful" or "correct" buttons to award points to replies / Mark the thread as answered, if your question is answered.
  • 4. Re: Regaring Value Sets
    Sanjay Desai Journeyer
    Currently Being Moderated
    Hi

    Pl. refer following links.

    http://www.applikast.net/technical/concurrent-programs/enabling-disabling-concurrent-program-parameters
    http://sureshvaishya.blogspot.in/2008/05/disable-concurrent-program-parameter.html

    HTH
    Sanjay
  • 5. Re: Regaring Value Sets
    user447531 Newbie
    Currently Being Moderated
    Hi ND / Sanjay,

    Thanks for your feedback...

    I tried both the scenario's earlier but it doesn't work..

    I have created P2 (vendor)with table value set and P3 & P4 these are Date From and To Parameters all these three are optional my requirement is if i select P2 from lov than P3 & P4 should be disabled and if i dont select P2 than P3 & P4 should be enabled where i can give date.

    I tried as you mentioned it works like this -- if i submit request i can see P2 where P3 & P4 greyed out suppose if i enter data in P2 and click on Tab than automatically P3 & P4 enabled but thats not the case it should be read-only and vice-versa is not happening..

    Please let me know where am wrong...


    Thanks,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points