FND Concurrent Managers – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Application Object Library · all Application Object Library reports
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
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
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, ECC Admin - Concurrent Programs, Blitz Report Custom Reports Converter, FND Concurrent Requests Summary, FND Concurrent Request Conflicts, FND Gather Statistics History, DBA Sessions
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | FND Concurrent Managers 27-Jan-2019 005502.xlsx |
| Blitz Report™ XML Import | FND_Concurrent_Managers.xml |
| SQL Source | FND Concurrent Managers.sql |
| Full Report 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
© Enginatics GmbH