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!

Valueset On Multi Org Views

Discussion in 'Oracle Development General' started by kiran.marla, Oct 9, 2013.

  1. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi All,

    How to create table type value set using Multi Org Views and populate values through LOV.

    I am working in R12 Migration. In 11i PO_VENDORS is a table. But in R12 it becomes a multi org view.
    While submitting the concurrent program , the LOV is not populating any values.

    Is there any other settings need to do additionally in order to populate the values through LOV ???

    P.S: I am aware that the above value set can rebuild with using AP_SUPPLIERS table. but the value set is used in more that 50+ concurrent programs.


    Edited : PO_VENDORS View is used for reference.... Please consider the Other multi org views also
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi kiran,

    set the operating unit mode as multiple for that concurrent program in sysadmin resp and check whether it is giving list of values or not?

    i am not sure but lets try this....
     
  3. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi Jagadekara,

    Operating unit mode is available in OA Pages. (Meta Id 420787.1)..
     
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi kiran for that just increase valueset size to 240 then it will give list of values
     
  5. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi Jagadekara,

    This is not valueset size problem. This is with Multiorg Views. I found problems with AP_CHECKS_V views.
     
  6. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi kiran,

    Just now I created one value set based on ap_checks_v column name checkrun_name.

    attached to one conc program at run time it is not showing list of values

    So i went to system administrator resp in that click on Search concurrent program then it will open an webpage and give concurrent program and click on update request tab operating unit mode set as multiple.

    Then go to srs window run our program here it showing list of values....
     
    kiran.marla likes this.
  7. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi Jagadekara,

    Please refer the attached screen shot. Operating unit mode option is providing any check box..

    How to over come this...
     

    Attached Files:

  8. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    H kiran,
    when we enter our program and click on find then click on update on right side then click on request tab then select multiple...
     
    kiran.marla likes this.
  9. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    hai check this....
    op mode.JPG
     
    Ecor likes this.
  10. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi Jagadekara,

    Its working .... Thanks very Much...
     
  11. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    You are welcome!