Query to find Find Concurrent Programs associated to Managers in Oracle EBS

If we want to check:

  • Which concurrent programs are run by a specific manager, or
  • Which manager runs a particular concurrent program


Query:

SELECT * 
FROM (
   -- Programs assigned to specific concurrent managers
   SELECT cq.user_concurrent_queue_name concurrent_queue_name,
          a.application_name,
          cp.user_concurrent_program_name concurrent_program_name
     FROM fnd_concurrent_queue_content sr,
          fnd_concurrent_programs_vl cp,
          fnd_concurrent_queues_vl cq,
          fnd_application_vl a
    WHERE sr.type_id = cp.concurrent_program_id
      AND cq.concurrent_queue_id = sr.concurrent_queue_id
      AND cp.application_id = a.application_id
      AND type_code = 'P'
      AND include_flag = 'I'

   UNION ALL

   -- Programs assigned to Standard Manager (default)
   SELECT 'Standard Manager',
          a.application_name,
          cp.user_concurrent_program_name
     FROM fnd_concurrent_programs_vl cp,
          fnd_application_vl a
    WHERE cp.application_id = a.application_id
      AND NOT EXISTS (
             SELECT 1
               FROM fnd_concurrent_queue_content cqn,
                    fnd_concurrent_queues_vl cq
              WHERE cq.concurrent_queue_id = cqn.concurrent_queue_id
                AND cq.application_id = cqn.queue_application_id
                AND cqn.type_id = cp.concurrent_program_id
                AND cqn.type_application_id = cp.application_id
                AND include_flag = 'E'
                AND user_concurrent_queue_name = 'Standard Manager'
                AND type_code = 'P'
          )
)
-- Optional filters:
-- WHERE concurrent_program_name LIKE '%%'
-- WHERE concurrent_queue_name LIKE '%%'
ORDER BY 1, 2, 3;

How to use filters:


To find a specific program:
WHERE concurrent_program_name LIKE '%Your Program%'


To check which programs a specific manager runs:

WHERE concurrent_queue_name LIKE '%Manager Name%'










Please do like and subscribe to my youtube channel: https://www.youtube.com/@foalabs If you like this post please follow,share and comment