Skip to the content.

Blitz Report History – 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

History of Blitz Report executions.

A repeating schedule’s next request gets its run record only when it starts. Include Scheduled Pending adds these pending requests, with the parameters and options of the run they were resubmitted from.

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, Category, Type, Report Name starts with, Submitted by User, Started within Days, Start Date From, Start Date To, Show Parameters, Running or Errored, Include Scheduled Pending, Running longer than x Minutes, Request Id, Run Id, Exclude System Reports, Exclude Submissions from User, License Exceeded, Incremental Alert Mode

Oracle EBS Tables Used

xxen_reports_h, fnd_concurrent_requests, xxen_report_runs, xxen_reports_v, fnd_responsibility_tl, gv$session, fnd_lookup_values, xxen_report_run_param_values

Report Categories

Enginatics

Blitz Report Web Service Sessions, Blitz Upload History, DBA ORDS Configuration Validation, DBA Sessions, FND Concurrent Requests, GL Account Distribution Analysis

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 Example
Blitz Report™ XML Import Blitz_Report_History.xml
SQL Source Blitz Report History.sql
Full Report on Enginatics www.enginatics.com/reports/blitz-report-history/

Blitz Report History - Case Study & Technical Analysis

Executive Summary

Blitz Report History is the detailed transaction log of the Blitz Report system. Unlike the “Execution Summary” which aggregates data, this report lists individual execution records. It is the primary tool for troubleshooting specific failed runs, auditing user activity, and analyzing performance at a granular level.

Business Challenge

Solution

This report provides a comprehensive view of the XXEN_REPORT_RUNS table, often joined with Oracle’s standard concurrent request tables.

Technical Architecture

Key Tables

Logic

The query lists execution records, sorted by start date. It includes logic to decode the status and link to the user and responsibility context.

Parameters


© Enginatics GmbH