Search Results fnd_concurrent_queue_params




Overview
Explore in AI Chat

Overview

The FND_CONCURRENT_QUEUE_PARAMS table is a core repository for configuration parameters that define the operational behavior of concurrent managers within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. As part of the Application Object Library (FND) module, this table stores key-value pairs of settings that are applied to specific concurrent manager queues. These parameters govern critical runtime aspects such as memory allocation, process control, and specialized operational rules, enabling administrators to fine-tune the performance and functionality of the concurrent processing environment beyond the base definitions stored in FND_CONCURRENT_QUEUES.

Key Information Stored

The table's structure is designed to associate parameters with a specific concurrent manager queue. Its primary key is a composite of QUEUE_APPLICATION_ID, CONCURRENT_QUEUE_ID, and NAME, ensuring unique parameter definitions per queue. The NAME column stores the identifier of the configurable parameter (e.g., CACHE_SIZE, SLEEP_SECONDS, MAX_PROCESSES). While the ETRM excerpt does not list a VALUE column explicitly, such a column is standard in parameter tables to hold the setting for the named parameter. The QUEUE_APPLICATION_ID and CONCURRENT_QUEUE_ID columns are foreign keys that precisely link each parameter row to its parent manager definition in the FND_CONCURRENT_QUEUES table.

Common Use Cases and Queries

This table is primarily accessed for advanced configuration, troubleshooting, and auditing of concurrent manager setups. Common administrative scenarios include reviewing all custom parameters set for a particular manager to diagnose performance issues or to replicate a configuration. A typical query involves joining with FND_CONCURRENT_QUEUES to get the manager name:

  • SELECT q.CONCURRENT_QUEUE_NAME, p.NAME, p.VALUE FROM FND_CONCURRENT_QUEUE_PARAMS p, FND_CONCURRENT_QUEUES q WHERE p.QUEUE_APPLICATION_ID = q.APPLICATION_ID AND p.CONCURRENT_QUEUE_ID = q.CONCURRENT_QUEUE_ID AND q.CONCURRENT_QUEUE_NAME = 'STANDARD';

Direct manipulation of data in this table is generally performed through the official Concurrent Manager definition forms (Administer Concurrent Managers form) or supported APIs to maintain system integrity.

Related Objects

The table has a direct and singular documented foreign key relationship, as per the provided metadata. It is a child table to FND_CONCURRENT_QUEUES.

  • FND_CONCURRENT_QUEUES: This is the parent table containing the master definition of each concurrent manager. The relationship is enforced through the foreign key on the composite columns (FND_CONCURRENT_QUEUE_PARAMS.QUEUE_APPLICATION_ID, FND_CONCURRENT_QUEUE_PARAMS.CONCURRENT_QUEUE_ID) referencing the primary key of FND_CONCURRENT_QUEUES. Any parameter record must correspond to an existing queue in this parent table.