Custom Precise ASD Pages for Oracle Apps

by May 23, 2014

Below is a custom query to display con-current queue activities in Oracle Apps environment.

This query show a count of running request by queue name in in a descending order

SELECT concurrent_queue_name,
COUNT(phase_code) Running
FROM fnd_concurrent_worker_requests
WHERE phase_code = ‘R’
GROUP BY concurrent_queue_name
ORDER BY Running desc
count of Pending processes in queue