Search Results fnd_concurrent_queues_tl




Overview
Explore in AI Chat

Overview

The FND_CONCURRENT_QUEUES_TL table is a core Application Object Library table within the Oracle E-Business Suite (EBS) architecture, specifically for versions 12.1.1 and 12.2.2. It functions as a translation table, storing multilingual descriptions for concurrent manager queues defined in the base table, FND_CONCURRENT_QUEUES. Its primary role is to support the global deployment of EBS by enabling the user-facing names and descriptions of concurrent queues to be displayed in the language of the user's session, a fundamental aspect of the application's NLS (National Language Support) capabilities. This table is owned by the APPLSYS schema and is integral to the concurrent processing subsystem.

Key Information Stored

The table stores translated text for each concurrent queue, keyed by language. Its structure is defined by a composite primary key and critical descriptive columns. The primary key consists of APPLICATION_ID, CONCURRENT_QUEUE_ID, and LANGUAGE, ensuring a unique translated record for each queue per language. The most significant user-facing column is USER_CONCURRENT_QUEUE_NAME, which holds the translated name of the concurrent queue as it appears in the application interface. Other important columns include DESCRIPTION for a longer explanatory text and CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN for tracking row history. The SOURCE_LANG column indicates the original language in which the record was created.

Common Use Cases and Queries

This table is primarily accessed by the EBS application runtime to resolve queue names for the user's session language. Common technical and administrative use cases include auditing installed languages for concurrent processing setup, troubleshooting display issues in non-base languages, and generating reports of manager configurations for multilingual implementations. A typical query to retrieve translated names for a specific queue across all installed languages would be:

  • SELECT fcq.CONCURRENT_QUEUE_NAME, fcqtl.LANGUAGE, fcqtl.USER_CONCURRENT_QUEUE_NAME FROM FND_CONCURRENT_QUEUES fcq, FND_CONCURRENT_QUEUES_TL fcqtl WHERE fcq.APPLICATION_ID = fcqtl.APPLICATION_ID AND fcq.CONCURRENT_QUEUE_ID = fcqtl.CONCURRENT_QUEUE_ID AND fcq.CONCURRENT_QUEUE_NAME = '&queue_short_name';

For performance, applications typically join to this table with an additional filter on LANGUAGE equal to the user's session language (USERENV('LANG')). Direct data manipulation in this table is strongly discouraged; translations are managed via the application's translation tools or underlying seed data scripts.

Related Objects

As indicated by the provided metadata, FND_CONCURRENT_QUEUES_TL has a direct and essential foreign key relationship with its base table, FND_CONCURRENT_QUEUES. The foreign key is on the combination of APPLICATION_ID and CONCURRENT_QUEUE_ID. This table is referenced by various Application Object Library views and packages that handle concurrent manager definitions and runtime logic. Key related objects include the FND_CONCURRENT_QUEUES_VL view (which performs the standard join to the _TL table to present translated data) and the FND_CONCURRENT_PROCESSES table, which defines the actual processes belonging to the queues described here. The integrity of this translation table is enforced by the primary key constraint FND_CONCURRENT_QUEUES_TL_PK.