Query to check concurrent program assigned to concurrent manager

Query to check concurrent program assigned to concurrent manager

In this post , We will be discuss about Query to check concurrent program assigned to concurrent manager. This sql query will help to extract the details of Concurrent manager assigned to concurrent program requests. We will be able to find out the assigned concurrent managers for concurrent programs in oracle apps using this sql query. This is one of the useful sql query for concurrent request monitoring. Please find below the detail about Query to check concurrent program assigned to concurrent manager.

Important Table used by Query to check concurrent program assigned to concurrent manager

 1.FND_CONCURRENT_QUEUE_CONTENT

 2.FND_CONCURRENT_PROGRAMS

 3.FND_CONCURRENT_QUEUES_VL

4.fnd_concurrent_processes

5.fnd_concurrent_requests

Detail SQL Query to check concurrent program assigned to concurrent manager

Query 1:-

SELECT  A2.CONCURRENT_PROGRAM_NAME,

       A1.QUEUE_APPLICATION_ID,

       A3.USER_CONCURRENT_QUEUE_NAME

  FROM APPLSYS.FND_CONCURRENT_QUEUE_CONTENT A1,

       APPLSYS.FND_CONCURRENT_PROGRAMS A2,

       APPS.FND_CONCURRENT_QUEUES_VL A3

 WHERE     type_id = A2.concurrent_program_id

       AND A2.concurrent_program_name = :P_PROGRAM_SHORT_NAME

       AND A3.concurrent_queue_id = A1.concurrent_queue_id

Query 2:- 

 select b.USER_CONCURRENT_QUEUE_NAME

from fnd_concurrent_processes a,

fnd_concurrent_queues_vl b, fnd_concurrent_requests c

where  a.CONCURRENT_QUEUE_ID = b.CONCURRENT_QUEUE_ID

and    a.CONCURRENT_PROCESS_ID = c.controlling_manager

and    c.request_id = :P_Request_Id;

Query to check concurrent program assigned to concurrent manager