Blitz Report Deletion 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
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
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
None
Oracle EBS Tables Used
Report Categories
Related Reports
CAC Inventory Organization Summary, Blitz Report LOVs, Blitz Reports, Blitz Report History, AP Expense Report Upload, GL Account Distribution Analysis, Blitz Report Text Search
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 Deletion History 03-Apr-2018 095214.xlsx |
| Blitz Report™ XML Import | Blitz_Report_Deletion_History.xml |
| SQL Source | Blitz Report Deletion History.sql |
| Full Report 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
© Enginatics GmbH