Search Results fnd_concurrent_worker_requests

Overview

FND_CONCURRENT_WORKER_REQUESTS is an APPS-owned database view in the Oracle E-Business Suite FND (Application Object Library) product. Its documented purpose is to present concurrent requests that are assigned to a specific concurrent manager queue. In other words, the view exposes the working set of requests held by a given manager — those that have been dispatched to a worker process for execution, or that are pending within that manager's queue.

Because concurrent processing is the backbone of nearly all long-running EBS operations (report submission, interface programs, request sets, and scheduled jobs), this view is a primary reporting and diagnostic surface. Administrators and developers query it to determine what a particular manager is currently running, to confirm queue depth, to investigate why a request is stalled, and to reconcile requests against the concurrent managers that own them. In integration scenarios, the view can be used to build custom monitoring dashboards or to feed external scheduling tools that need visibility into in-flight work. The object is VALID across the 12.1.1 and 12.2.2 releases, and ETRM classifies it as a VIEW under the FND module.

Underlying Base Objects

The view is defined over a set of FND synonyms that resolve to the core Concurrent Manager tables. The ETRM metadata lists the referenced base objects as FND_CONCURRENT_PROCESSES, FND_CONCURRENT_PROGRAMS, FND_CONCURRENT_PROGRAMS_TL, FND_CONCURRENT_QUEUES, FND_CONCURRENT_QUEUES_TL, FND_CONCURRENT_REQUESTS, FND_CONFLICTS_DOMAIN, and FND_ORACLE_USERID.

• FND_CONCURRENT_REQUESTS — the central table holding every submitted concurrent request and its phase/status; this is the dominant source of rows.
• FND_CONCURRENT_PROCESSES — identifies the running concurrent manager and worker processes.
• FND_CONCURRENT_QUEUES and FND_CONCURRENT_QUEUES_TL — the manager queue definition and its translated (language) name.
• FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_PROGRAMS_TL — the executable/program definition and its translated user-facing name.
• FND_CONFLICTS_DOMAIN — conflict domain assignments used to determine which requests may run simultaneously.
• FND_ORACLE_USERID — the Oracle schema under which the request executes.

The view joins these objects so that a single row correlates a request with its owning queue, its program, and its runtime context. It is effectively a queue-scoped projection of the concurrent request data.

Key Columns

Although the view is a SELECT * projection, its meaningful columns follow the joined base objects:

• REQUEST_ID — unique identifier of the concurrent request.
• CONCURRENT_PROGRAM_ID / USER_CONCURRENT_PROGRAM_NAME — the program being executed and its translated name.
• CONCURRENT_QUEUE_ID / CONCURRENT_QUEUE_NAME — the manager queue that owns the request.
• PHASE_CODE / STATUS_CODE — current execution phase (e.g., Pending, Running, Completed) and status (Normal, Warning, Error).
• REQUESTED_START_DATE / ACTUAL_START_DATE / COMPLETION_DATE — timing attributes for queue-delay and runtime analysis.
• PRIORITY / REQUESTED_BY — scheduling priority and the requesting user.
• ORACLE_ID / ORACLE_USERNAME — the schema context from FND_ORACLE_USERID.

Common Use Cases and Queries

Typical usage includes identifying which manager is running a program, computing queue wait times, and validating conflict-domain behaviour. A representative query lists active work per manager queue:

• SELECT request_id, concurrent_program_id, concurrent_queue_name, phase_code, status_code FROM fnd_concurrent_worker_requests WHERE phase_code = 'R'; — currently running requests.
• SELECT concurrent_queue_name, COUNT(*) FROM fnd_concurrent_worker_requests GROUP BY concurrent_queue_name; — load per queue.
• SELECT request_id, requested_start_date, actual_start_date FROM fnd_concurrent_worker_requests WHERE phase_code = 'P'; — pending requests and their wait.

These queries support day-to-day administration, capacity planning, and custom monitoring integrations built on the documented FND objects.