Re: OPP Issue

Posted by raja on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/OPP-Issue-tp5085p5118.html

Hi Erman


Query i got it from Concurrent manager forms. I got the query from forms by Help >Diagnostics>Examine screen

SELECT ROWID,ROW_ID,CONCURRENT_QUEUE_NAME,USER_CONCURRENT_QUEUE_NAME,TARGET_NODE,MAX_PROCESSES,APPLICATION_ID,CONCURRENT_QUEUE_ID,CONTROL_CODE,MANAGER_TYPE FROM FND_CONCURRENT_QUEUES_VL WHERE enabled_flag='Y'  order by Decode(application_id, 0, Decode(concurrent_queue_id, 1, 1, 4, 2)), sign(max_processes) desc, concurrent_queue_name, application_id



My query:

SELECT b.user_concurrent_queue_name "Concurrent Manager", b.target_node "Node", a.running_processes "Actual Processes", a.max_processes "Target Processes"
    FROM apps.fnd_concurrent_queues a, apps.fnd_concurrent_queues_vl b
   WHERE a.concurrent_queue_id = b.concurrent_queue_id
    AND a.concurrent_queue_name = 'FNDCPOPP' ;