Custom Precise ASD Pages for Oracle Apps

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

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

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

    SELECT concurrent_queue_name,
    COUNT(phase_code) Pending_Request
    FROM fnd_concurrent_worker_requests
    WHERE phase_code = ‘P’AND
    hold_flag != ‘Y’AND
    requested_start_date <= sysdate
    GROUP BY concurrent_queue_name
    ORDER BY Pending_Request desc