Search Results request_class_name

Overview

The FND_CONCURRENT_REQUEST_CLASS table is a core Application Object Library (FND) table in Oracle E-Business Suite (EBS) that defines the master list of concurrent request types, or classes. It serves as a reference data store for categorizing and managing concurrent programs and requests. The table's primary role is to provide a controlled classification system, enabling administrators to group related programs, assign them to specific work shifts via queue content rules, and manage their execution behavior. This classification is fundamental to the concurrent processing architecture in both EBS 12.1.1 and 12.2.2, impacting scheduling, reporting, and program dependencies.

Key Information Stored

The table stores the essential identifiers and descriptors for each request class. Its structure is defined by two primary key constraints. The composite primary key FND_CONC_REQUEST_CLASS_PK consists of APPLICATION_ID and REQUEST_CLASS_ID, ensuring uniqueness of the class within the context of its owning application. A unique key, FND_CONC_REQUEST_CLASS_UK1, on APPLICATION_ID and REQUEST_CLASS_NAME, enforces unique naming. While specific column details are not fully enumerated in the provided metadata, the key relationships indicate the table centrally stores the class identifier (REQUEST_CLASS_ID), its associated application (APPLICATION_ID), and its name (REQUEST_CLASS_NAME). These attributes are referenced extensively by other concurrent processing tables.

Common Use Cases and Queries

This table is central to administrative reporting and setup tasks. Common use cases include auditing all defined request classes in the system, identifying which concurrent programs belong to a specific class, and troubleshooting queue content rules. A typical query joins this table with FND_CONCURRENT_PROGRAMS to list all programs and their assigned classes:

• SELECT fcrc.request_class_name, fcp.concurrent_program_name, fat.application_name FROM apps.fnd_concurrent_request_class fcrc, apps.fnd_concurrent_programs fcp, apps.fnd_application_tl fat WHERE fcrc.application_id = fcp.class_application_id AND fcrc.request_class_id = fcp.concurrent_class_id AND fcrc.application_id = fat.application_id AND fat.language = USERENV('LANG') ORDER BY 1,3;

Another critical use is analyzing the configuration of concurrent manager work shifts by joining with FND_CONCURRENT_QUEUE_CONTENT to see which classes are assigned to which managers and queues.

Related Objects

As indicated by the foreign key relationships, FND_CONCURRENT_REQUEST_CLASS is a central reference point for several key concurrent processing tables:

• FND_APPLICATION: References via APPLICATION_ID to validate the owning application.
• FND_CONCURRENT_PROGRAMS: Links via CLASS_APPLICATION_ID and CONCURRENT_CLASS_ID to assign a class to a program.
• FND_CONCURRENT_QUEUE_CONTENT: Links via TYPE_APPLICATION_ID and TYPE_ID to include a request class in a manager's specialization rules.
• FND_CONCURRENT_REQUESTS: Links via REQUEST_CLASS_APPLICATION_ID and CONCURRENT_REQUEST_CLASS_ID to record the class of a submitted request.
• FND_CONCURRENT_COMPLEX_LINES: Links via TYPE_APPLICATION_ID and TYPE_ID to define a request class as a step in a complex concurrent program.