Blitz Report Execution Summary – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Blitz Report · all Blitz Report reports
Overview
Count and performance summary of historic Blitz Report executions
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
Report Name, Submitted By, Submitted within Days, Exclude System Reports, Exclude own Submissions
Oracle EBS Tables Used
xxen_reports_v, xxen_report_runs
Report Categories
Related Reports
Blitz Report License User History, Blitz Report History Summary, Blitz Reports, Blitz Report History, Blitz Upload History, Blitz Upload Data
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 | Blitz Report Execution Summary 24-Jul-2017 145940.xlsx |
| Blitz Report™ XML Import | Blitz_Report_Execution_Summary.xml |
| SQL Source | Blitz Report Execution Summary.sql |
| Full Report on Enginatics | www.enginatics.com/reports/blitz-report-execution-summary/ |
Blitz Report Execution Summary - Case Study & Technical Analysis
Executive Summary
Blitz Report Execution Summary is a performance and usage analytics report. It provides high-level statistics on how often reports are run and how they perform. This is essential for identifying the most popular reports (candidates for optimization) and the most resource-intensive reports (candidates for tuning).
Business Challenge
- Performance Tuning: Which reports are consuming the most database resources?
- Adoption Tracking: Are users actually using the new “Inventory Aging” report we built?
- Cleanup: Which reports have not been run in the last year and can be retired?
Solution
This report aggregates execution data from the XXEN_REPORT_RUNS table.
- Counts: Shows the total number of executions per report.
- Performance: Likely shows average run times or total duration.
- User Activity: Can be filtered to see who is submitting the most reports.
Technical Architecture
Key Tables
XXEN_REPORTS_V: Report definitions.XXEN_REPORT_RUNS: The log table recording every execution of a Blitz Report.
Logic
The query groups by Report Name (and potentially User) and calculates counts and averages.
Parameters
- Report Name: Filter for a specific report.
- Submitted By: Filter by user.
- Submitted within Days: Time window for the analysis (e.g., last 30 days).
- Exclude System Reports: Hide internal Blitz Report maintenance jobs.
- Exclude own Submissions: Filter out the administrator’s own tests.
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