Search Results diagnostic_level

Overview

FND_CONCURRENT_QUEUES_VL is a seeded, read-mostly view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the FND (Application Object Library) product and presents the definition of concurrent managers and their associated worker queues, combining the administrative attributes stored against each queue with the language-specific attributes held in the translation table. The _VL suffix denotes a "view with language" — a translated view whose multilingual columns are filtered to the session language through USERENV('LANG'), so that descriptions and user-defined queue names are returned in the language of the querying session.

The view is the principal supported interface for reporting on and integrating with concurrent manager configuration. Because it consolidates the base queue table with its translation table, it exposes both technical attributes (process counts, node and queue targets, control codes) and descriptive attributes (queue description, user-defined queue name). Reporting tools, custom concurrent programs, and monitoring scripts query it in preference to the base tables, since the join and language filtering are performed automatically. Since the underlying configuration tables are maintenance objects owned by the Concurrent Manager administration forms, the view should be treated as a query-only source; DML against concurrent manager definitions is performed through the standard administrative forms and their supporting APIs.

Underlying Base Objects

The view is defined over two base objects, both referenced through synonyms: FND_CONCURRENT_QUEUES (aliased B) and FND_CONCURRENT_QUEUES_TL (aliased T). The join condition matches APPLICATION_ID and CONCURRENT_QUEUE_ID between the two, and restricts the translation row to the current session language via T.LANGUAGE = USERENV('LANG'). The view text selects the ROWID of the base queue row as ROW_ID, and the translated DESCRIPTION and USER_CONCURRENT_QUEUE_NAME columns from the translation table. All remaining columns are projected from FND_CONCURRENT_QUEUES. This structure mirrors the standard EBS multilingual ("_VL") pattern: a base (_B) table holding untranslated attributes and a translation (_TL) table holding language-specific text.

Key Columns

• APPLICATION_ID, CONCURRENT_QUEUE_ID — composite primary key identifying the queue.
• CONCURRENT_QUEUE_NAME — the internal developer name; USER_CONCURRENT_QUEUE_NAME — the translated, user-visible name.
• NODE_NAME, NODE_NAME2 — the primary and secondary node assignments for the manager; the second is used in multi-node or failover configurations.
• OS_QUEUE, OS_QUEUE2 — the operating system queue names corresponding to the primary and secondary node assignments.
• MAX_PROCESSES, MIN_PROCESSES, TARGET_PROCESSES, RUNNING_PROCESSES, CACHE_SIZE, SLEEP_SECONDS — process management and throughput parameters.
• MANAGER_TYPE, CONTROL_CODE, DIAGNOSTIC_LEVEL, ENABLED_FLAG — operational state and control attributes.
• RESTART_TYPE, RESTART_INTERVAL — restart behavior after failure.
• DATA_GROUP_ID, PROCESSOR_APPLICATION_ID, CONCURRENT_PROCESSOR_ID, RESOURCE_CONSUMER_GROUP — assignment and specialization attributes.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE12 — descriptive flexfield segments.
• WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) — audit information.

Common Use Cases and Queries

Typical uses include auditing manager configuration, checking node and queue assignments (particularly the NODE_NAME2/OS_QUEUE2 pair used for secondary node setup), and feeding monitoring dashboards. The following query lists enabled managers and their node assignments in the session language:

• SELECT concurrent_queue_name, user_concurrent_queue_name, node_name, node_name2, os_queue, os_queue2, max_processes, running_processes, enabled_flag FROM fnd_concurrent_queues_vl WHERE enabled_flag = 'Y' ORDER BY concurrent_queue_name;
• SELECT concurrent_queue_name, manager_type, target_processes, sleep_seconds, control_code FROM fnd_concurrent_queues_vl WHERE manager_type IN (1,2);
• SELECT cq.concurrent_queue_name, cq.node_name2, cq.description FROM fnd_concurrent_queues_vl cq WHERE cq.node_name2 IS NOT NULL;

These queries return configuration and translated text in one pass, avoiding manual joins between the base and translation tables.