Oracle EBS: SQL Script to Check Concurrent Manager Status

Oracle E-Business Suite stores Concurrent Manager configuration and process information in the FND_CONCURRENT_QUEUES_VL view.

The following SQL queries can be used to check Concurrent Manager status, target processes, running processes, assigned nodes and control status.

Check All Concurrent Managers

SET LINESIZE 220
SET PAGESIZE 100

COLUMN concurrent_queue_name      FORMAT A30
COLUMN user_concurrent_queue_name FORMAT A45
COLUMN node_name                  FORMAT A25
COLUMN target_node                FORMAT A25
COLUMN status                     FORMAT A15

SELECT q.concurrent_queue_name,
       q.user_concurrent_queue_name,
       q.node_name,
       q.target_node,
       q.max_processes,
       q.running_processes,
       CASE
           WHEN q.enabled_flag = 'N' THEN 'Disabled'
           WHEN q.control_code = 'A' THEN 'Activating'
           WHEN q.control_code = 'D' THEN 'Deactivating'
           WHEN q.control_code = 'T' THEN 'Terminating'
           WHEN q.control_code = 'V' THEN 'Verifying'
           WHEN q.control_code = 'X' THEN 'Terminated'
           WHEN q.running_processes > 0 THEN 'Running'
           ELSE 'Inactive'
       END status
FROM fnd_concurrent_queues_vl q
WHERE q.manager_type = '0'
ORDER BY q.user_concurrent_queue_name;

Concurrent Manager Status Summary

This query provides a summary of running, inactive and disabled Concurrent Managers.

SELECT CASE
           WHEN enabled_flag = 'N' THEN 'Disabled'
           WHEN running_processes > 0 THEN 'Running'
           ELSE 'Inactive'
       END status,
       COUNT(*) managers,
       SUM(max_processes) target_processes,
       SUM(running_processes) running_processes
FROM fnd_concurrent_queues_vl
WHERE manager_type = '0'
GROUP BY CASE
             WHEN enabled_flag = 'N' THEN 'Disabled'
             WHEN running_processes > 0 THEN 'Running'
             ELSE 'Inactive'
         END
ORDER BY status;

Check a Specific Concurrent Manager

The following example checks the Standard Manager. Replace STANDARD with any part of the required Concurrent Manager name.

SET LINESIZE 200

COLUMN concurrent_queue_name      FORMAT A30
COLUMN user_concurrent_queue_name FORMAT A45
COLUMN node_name                  FORMAT A25
COLUMN target_node                FORMAT A25

SELECT concurrent_queue_name,
       user_concurrent_queue_name,
       node_name,
       target_node,
       max_processes,
       running_processes,
       enabled_flag,
       control_code
FROM fnd_concurrent_queues_vl
WHERE UPPER(user_concurrent_queue_name) LIKE UPPER('%STANDARD%');

Check Internal Concurrent Manager

SELECT concurrent_queue_name,
       user_concurrent_queue_name,
       node_name,
       target_node,
       max_processes,
       running_processes,
       enabled_flag,
       control_code
FROM fnd_concurrent_queues_vl
WHERE concurrent_queue_name = 'FNDICM';

Important Columns

• CONCURRENT_QUEUE_NAME: Internal name of the Concurrent Manager.

• USER_CONCURRENT_QUEUE_NAME: Display name shown in Oracle EBS.

• NODE_NAME: Node on which the manager is currently running.

• TARGET_NODE: Node assigned to run the manager.

• MAX_PROCESSES: Configured number of target processes.

• RUNNING_PROCESSES: Number of processes currently running.

• ENABLED_FLAG: Indicates whether the manager is enabled.

• CONTROL_CODE: Current control action or state.

Common Control Codes

Control code	Meaning
A	Activating
D	Deactivating
T	Terminating
V	Verifying
X	Terminated
NULL	No pending control action

Conclusion

The FND_CONCURRENT_QUEUES_VL view provides a quick way to monitor Oracle EBS Concurrent Managers from the database. It helps identify disabled managers, managers with zero running processes, incorrect node assignments and differences between configured and running processes.

These queries should normally be executed using the APPS database user.

Keywords: Oracle EBS Concurrent Manager, FND_CONCURRENT_QUEUES_VL, Concurrent Manager status query, Standard Manager, Internal Concurrent Manager, Oracle Apps DBA