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!

Need help , Uing Flex value set

Discussion in 'Oracle Apps Technical' started by sambuduk, Apr 17, 2012.

  1. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi

    i am working on one Report. The report having 3 parameters

    1. Branch -- Mandatory ( values like b1,b2,b3)
    2. Unit -- Optional ( values like U1,u2,u3 under branchh b1 , U4,U5 are Under b2 , U6,U7,U8 are under b3 )
    3. Employees -- mandatory ( values like e1,e2 are under U1 , e3,e4,e5 are under U2 , e6,e7,e8 under U3 --- etc)

    case 1: If i select Branch value as b1 then in the Unit list of values U1,u2,U3 has to come
    case 2: Then If I select unit value as U3 then Employees list of values e6,e7,e8 has to come

    case 1 and case 2 are working properly ( by using " $FLEX$.BRANCH " and "$FLEX$.UNIT" )


    case 3: here Unit is optional parameter . So if wont select unit value ,then in the Employees list all employees under that branch has to come

    that means if I select b1 branch and wont select any unit then in the Employees list e1,e2,e3,e4,e5,e6,e7,e8 has to come

    for this i used the query like below

    select xe.emp_id
    from xx_emp xe
    where xe.unit_id = NVL:)$FLEX$.UNIT,xe.unit_id)
    AND xe.branch_id = NVL:)$FLEX$.BRANCH,xe.branch_id)

    Once I select the branch value then Unit prameter gets Enabled and once i select the Unit then Employees parameter gets enabled.(It is because of $FLEX$ functionality).

    Here i am getting the problem , Unit is optional parameter so If i dont select the unit parameter Employees pameter wont get enable.So i am unable to enter the value in Employees parameter...

    Anyone Provide me solution for this.....

    Thanks and regards
    Samba
     
  2. a_kamalraj

    a_kamalraj Forum Advisor

    Messages:
    121
    Likes Received:
    23
    Trophy Points:
    280
    HI Samba,

    Did you get this issue solved?.

    Can you tell me what type of valueset you used for Employee list. Can you explain hw you getting employee lists please. So i can work out and give you as solution.

    Cheers
    Kamal (kamal.love@gmail.com)
     
  3. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi Kamal,

    Still issue is remain...

    valueset type is table type i used ...

    Thanks in Advance

    ---
    Samba
     
  4. a_kamalraj

    a_kamalraj Forum Advisor

    Messages:
    121
    Likes Received:
    23
    Trophy Points:
    280
    Hi Samba,

    Can you try in the Unit (Add a Null Value in the LOV including U1,U2,U3) and make the NULL value as Default so when You not selecting the Unit it defaults to NULL and ur Employee will be Enabled.

    Just give a try and i hope it works fine.

    Cheers
    Kamal (kamal.love@gmail.com)
     
  5. a_kamalraj

    a_kamalraj Forum Advisor

    Messages:
    121
    Likes Received:
    23
    Trophy Points:
    280
    Hi Samba,

    Is this working ... let me know if its not working we will find out something else for this.
    Expecting your reply on this.

    Cheers
    Kamal
     
    sambuduk likes this.
  6. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi Kamal,

    Actually this issue happened in my previous project, anyway i wil try in Vision instance and i will let you know.

    Thanking You.

    Regards
    Samba
    (sambuduk@gmail.com)