FND Concurrent Requests – 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

Running, scheduled and historic concurrent requests including phase, status, parameters, schedule, timing, delivery and output option information. For performance analysis of running requests, the report contains sid, currently executed sql_id and sql_text and distribution of wait time on different wait classes.

Use parameter ‘Scheduled or Running’ to get a list of all currently scheduled or running requests.

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

Concurrent Program Name, Concurrent Progr. (all languages), Concurrent Program Short Name, Request Id, Requested By, Started within Days, Scheduled or Running, Waiting for x Minutes, Running longer than x Minutes, Output file larger than x MB, Log file larger than x MB, Phase, Status, Show Parameters Display Values, Show BI Pub & Delivery Options, Show Reports only, Show active session SQL Text, Parameter Text contains, Request Set Name, Execution Method, Executable Short Name, Running from Timestamp, Running to Timestamp, Requested Start Date From, Requested Start Date To, Node, Manager Name, Operating Unit, Exclude Conc Program Name, Incremental Alert Mode

Oracle EBS Tables Used

fnd_profile_option_values, fnd_concurrent_requests, fnd_concurrent_processes, fnd_concurrent_queues_vl, fnd_run_requests, fnd_request_set_programs, fnd_request_set_stages, fnd_concurrent_programs_vl, fnd_conc_prog_onsite_info, fnd_executables_vl, fnd_responsibility_vl, fnd_conc_release_classes, hr_all_organization_units_vl, fnd_conflicts_domain, fnd_conc_pp_actions, fnd_cp_delivery_options, fnd_conc_req_outputs, fnd_lookup_values_vl, gv$session, gv$session_event, gv$sql

Report Categories

Enginatics

Related Reports

FND Concurrent Programs and Executables, FND Responsibility Access, FND Concurrent Managers, Blitz Report Custom Reports Converter, FND Concurrent Requests Summary, PAY Payroll Process Summary

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 Requests 27-Jan-2019 140201.xlsx
Blitz Report™ XML Import	FND_Concurrent_Requests.xml
SQL Source	FND Concurrent Requests.sql
Full Report on Enginatics	www.enginatics.com/reports/fnd-concurrent-requests/

Case Study & Technical Analysis: FND Concurrent Requests

Executive Summary

The FND Concurrent Requests report is the definitive operational dashboard for Oracle E-Business Suite System Administrators and Support Analysts. It provides real-time and historical visibility into the Concurrent Processing system, enabling teams to monitor system health, troubleshoot performance bottlenecks, and ensure the timely execution of critical business processes.

Business Challenge

• Operational Blind Spots: Standard Oracle forms are often slow and lack the advanced filtering needed to manage high-volume environments with millions of requests.
• Performance Troubleshooting: Identifying the root cause of a “long-running” request usually requires separate DBA tools to check database sessions and wait events.
• Resource Management: Unchecked requests generating massive log or output files can silently consume disk space and degrade system performance.

The Solution

This report bridges the gap between functional administration and technical performance monitoring.

• Unified Monitoring: It consolidates request status, scheduling parameters, and delivery options into a single, filterable view.
• Real-Time Diagnostics: For currently running requests, it exposes critical database metrics—including the active SQL_ID, execution text, and wait classes—allowing immediate diagnosis of “stuck” jobs.
• Proactive Alerting: Parameters like “Running longer than x Minutes” or “Log file larger than x MB” enable proactive identification of anomalies before they impact users.

Technical Architecture (High Level)

• Primary Tables: FND_CONCURRENT_REQUESTS, FND_CONCURRENT_PROGRAMS_VL, FND_USER, FND_RESPONSIBILITY_VL.
• Performance Views: GV$SESSION, GV$PROCESS, GV$SQL (accessed dynamically for running requests).
• Logical Relationships:
  • The report joins the core Request table to Program, User, and Responsibility definitions to provide human-readable context.
  • For requests with Phase = 'Running', it performs a left join to the database session views (GV$SESSION) using the ORACLE_PROCESS_ID (SPID) to retrieve real-time execution details.
  • It parses and decodes the raw argument string to display meaningful parameter values.

Parameters & Filtering

• Scheduled or Running: A binary flag to instantly filter the list to only active or pending workloads, removing historical clutter.
• Running longer than x Minutes: A critical threshold filter for identifying performance outliers and potential runaways.
• Show active session SQL Text: When enabled, retrieves the actual SQL statement currently executing in the database for running requests.
• Output/Log file larger than x MB: Identifies requests that are consuming excessive file system storage.
• Wait for x Minutes: Highlights requests that have been in a ‘Pending’ state for an extended period, indicating potential manager issues.

Performance & Optimization

• Conditional Logic: The report is optimized to only query heavy performance views (GV$) when relevant (i.e., for running requests), ensuring the report itself runs instantly.
• Indexed Access: Filters on REQUEST_ID, REQUEST_DATE, and PROGRAM_ID leverage standard EBS indexes to ensure fast retrieval of historical data.
• Direct Output: Bypasses the XML Publisher layer to stream data directly to Excel, capable of handling tens of thousands of rows without timeout.

FAQ

Q: Can I see the SQL statement for a request that has already completed? A: No, the “Active Session SQL Text” is retrieved from the live database session cache (GV$SQL). Once a request finishes and the session closes, this runtime information is no longer available in memory.

Q: Why do some requests show a status of ‘Inactive’ but ‘No Manager’? A: This usually indicates that the Concurrent Manager defined to run this specific program is not running or is busy. The report helps identify these bottlenecks by showing the ‘Manager Name’ and ‘Node’.

Q: Does this report show requests from all RAC nodes? A: Yes, it queries global views (GV$) to capture session information across all nodes in a Real Application Clusters (RAC) environment.

---

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