Skip to the content.

FND Concurrent Requests Summary – 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 programs sorted by the sum of their historic execution times

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

Started within Days, Running from Date, Running to Date, Program Name, System Program Name, Executable Short Name, Execution Method, Show Argument Text, Show Reports only

Oracle EBS Tables Used

fnd_concurrent_requests, fnd_concurrent_programs_vl, fnd_user, fnd_executables, fnd_responsibility_vl

Report Categories

Enginatics

ECC Admin - Concurrent Programs, FND Concurrent Requests, Blitz Report Custom Reports Converter, FND Responsibility Access, DBA Sessions, XDO Publisher Data Definitions

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 Summary 15-Oct-2023 092431.xlsx
Blitz Report™ XML Import FND_Concurrent_Requests_Summary.xml
SQL Source FND Concurrent Requests Summary.sql
Full Report on Enginatics www.enginatics.com/reports/fnd-concurrent-requests-summary/

Executive Summary

The FND Concurrent Requests Summary report provides a performance profile of your concurrent processing system. It aggregates historical execution data to highlight the most resource-intensive programs.

Business Challenge

The Solution

This Blitz Report aggregates data from FND_CONCURRENT_REQUESTS:

Technical Architecture

The report groups data by PROGRAM_APPLICATION_ID and CONCURRENT_PROGRAM_ID. It calculates metrics like SUM(ACTUAL_COMPLETION_DATE - ACTUAL_START_DATE).

Parameters & Filtering

Performance & Optimization

FAQ


© Enginatics GmbH