Blitz Report Deletion History – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Shows deleted Blitz Reports and can be used to recover accidentally deleted reports. The history of deleted reports can be purged completely by running concurrent ‘Blitz Report Monitor’ with parameter ‘Purge delete reports SQL history’ set to Yes
Report Parameters
Oracle EBS Tables Used
Report Categories
Related Reports
GL Account Distribution Analysis, GL Account Analysis (Distributions), Blitz Reports, Blitz Report History, Blitz Report Text Search, DIS Import Performance
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | Blitz Report Deletion History 03-Apr-2018 095214.xlsx |
| Blitz Report™ XML Import | Blitz_Report_Deletion_History.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/blitz-report-deletion-history/ |
Blitz Report Deletion History - Case Study & Technical Analysis
Executive Summary
Blitz Report Deletion History is an audit and recovery tool. It tracks reports that have been deleted from the system. Crucially, it can be used to recover accidentally deleted reports because Blitz Report often performs a “soft delete” or archives the definition before removal.
Business Challenge
- Accidental Deletion: A developer intends to delete a test report but accidentally deletes the production version.
- Audit Trail: Security requires a log of who deleted a critical financial report and when.
- Recovery: Restoring the SQL logic of a deleted report without having to rewrite it from scratch.
Solution
This report queries the history tables (XXEN_REPORTS_H) to find records where the report status indicates deletion.
- Recovery: The SQL text and parameters are preserved in the history table, allowing them to be copied back into a new report definition.
- Purge: The description notes that this history can be permanently purged using the ‘Blitz Report Monitor’ concurrent program.
Technical Architecture
Key Tables
XXEN_REPORTS: The active report table.XXEN_REPORTS_H: The history table that stores version changes and deleted records.
Logic
The report filters the history table for records that represent a deletion event.
Parameters
- (None listed in the README, but likely supports standard filters like Date or User if customized).
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
© 2026 Enginatics