FND Concurrent Managers – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Concurrent managers’ setup and current status, e.g. processes and requests running, pending etc. Shows the same information as Concurrent->Manager->Administer and Concurrent->Manager->Define
Report Parameters
Manager Name, Show Specialization Rules, Show Processes, Active Processes only, Show Requests, Active Requests only
Oracle EBS Tables Used
fnd_concurrent_queues_vl, fnd_application_vl, fnd_cp_services_vl, fnd_concurrent_worker_requests, fnd_concurrent_queue_content, fnd_concurrent_programs_vl, fnd_concurrent_processes, fnd_concurrent_requests
Report Categories
Related Reports
FND Concurrent Requests 11i, FND Concurrent Requests, ECC Admin - Concurrent Programs, FND Concurrent Requests Summary, FND Concurrent Request Conflicts, FND Attachment Functions, XDO Publisher Data Definitions
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | FND Concurrent Managers 27-Jan-2019 005502.xlsx |
| Blitz Report™ XML Import | FND_Concurrent_Managers.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-concurrent-managers/ |
Executive Summary
The FND Concurrent Managers report provides a real-time dashboard of the concurrent processing system. It details the configuration and current status of all concurrent managers, including their workload and specialization rules.
Business Challenge
- Bottleneck Detection: Identifying managers that have a backlog of pending requests.
- Capacity Planning: Determining if more processes (workers) need to be assigned to a specific manager.
- Troubleshooting: Checking if a manager is actually running or if it has deactivated due to errors.
The Solution
This Blitz Report replicates and enhances the “Administer Concurrent Managers” form:
- Comprehensive Status: Shows Target vs. Actual processes, Running Requests, and Pending Requests.
- Specialization Visibility: Details the “Include/Exclude” rules that determine which programs a manager can run.
- Queue Analysis: Provides insight into the depth of the queue for each manager.
Technical Architecture
The report queries FND_CONCURRENT_QUEUES (Managers) and joins with FND_CONCURRENT_PROCESSES (Workers) and FND_CONCURRENT_REQUESTS (Workload). It calculates the “Pending” and “Running” counts dynamically.
Parameters & Filtering
- Manager Name: Filter for a specific manager (e.g., “Standard Manager”).
- Show Specialization Rules: Toggle to list the programs included/excluded for the manager.
Performance & Optimization
- Real-Time Data: This report queries active transaction tables. It is generally fast but reflects the system state at the exact moment of execution.
FAQ
- Q: What is the “Standard Manager”?
- A: It is the default manager that picks up any request not routed to a specialized manager.
- Q: Why is “Actual” less than “Target”?
- A: The Internal Manager Manager (ICM) might still be starting up processes, or the manager might have encountered an error and scaled down.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics