| layout | default |
|---|---|
| title | Blitz Reports | Oracle EBS SQL Report |
| description | Blitz Reports with parameters and assignments. If you are using the free version of Blitz Report, you can use the parameter 'Sort by Free 30 Reports' to… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, Blitz, Reports, xxen_reports_v, table, xxen_reports_h |
| permalink | /Blitz%20Reports/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Blitz Reports with parameters and assignments. If you are using the free version of Blitz Report, you can use the parameter 'Sort by Free 30 Reports' to show your free reports in column 'Free 30 Reports'.
Category, Not in Category, Type, Report Name, Report name <>, Report Name like, Parameter Name, Parameter Type, Show Parameters, Show Upload Parameters, Show Upload Columns, Show Assignments, Show executions within x days, Enabled, DB Package exists, Sort by Free 30 Reports, Include Anchors and Binds, Parameter SQL Text contains, Using LOV, Matching Value contains, Default Value contains, Modified Date From, Created By, Not Created By, Creation Date From, Last Update Date From, Last Updated By, Not Last Updated By, Updated By (Report or Param), Update Date From (Report or Param), SQL Last Update Date From, Non merged copied reports, Not assigned to level
xxen_reports_v, table, xxen_reports_h, xxen_report_assignments, xxen_report_parameters, xxen_report_templates, fnd_user, xxen_report_parameters_v, xxen_report_assignments_v, xxen_report_runs, xxen_upload_parameters_v, xxen_upload_columns_v, anchors, lexicals, binds
GL Account Distribution Analysis, GL Account Analysis (Distributions), CAC Interface Error Summary, ZX US Sales Tax, Blitz Report History, Blitz Report Assignment Upload, Blitz Report Assignments, DIS End User Layers
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.
| Resource | Link |
|---|---|
| Excel Example Output | Blitz Reports 10-Aug-2020 140427.xlsx |
| Blitz Report™ XML Import | Blitz_Reports.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/blitz-reports/ |
The Blitz Reports report is a comprehensive administrative tool that provides a detailed inventory of all Blitz Reports defined in the system. It lists reports along with their parameters, assignments, and other configuration details, serving as a master catalog for the reporting environment.
As the number of reports in an Oracle EBS environment grows, managing them becomes increasingly difficult. Administrators need a way to audit report definitions, check for consistency in parameters, and review user assignments. Without a centralized view, it is challenging to maintain standards, identify redundant reports, or ensure that reports are correctly configured and secured.
The Blitz Reports report solves this by offering a holistic view of the reporting landscape. It allows users to query reports based on a wide range of criteria, including category, type, parameter usage, and creation/update dates. This visibility enables efficient management, easier troubleshooting, and better governance of the reporting solution.
- Comprehensive Inventory: Lists all Blitz Reports with their key attributes.
- Detailed Filtering: Supports extensive parameters for filtering by category, report name, parameter type, and more.
- Configuration Audit: Shows details about parameters, upload columns, and assignments.
- Usage & History: Includes options to show execution counts and filter by creation or update history.
- Free Report Identification: Can sort and identify reports that count towards the free usage tier.
The report queries a multitude of Blitz Report views and tables, including xxen_reports_v, xxen_report_parameters_v, xxen_report_assignments_v, and xxen_report_runs. It also joins with standard Oracle tables like fnd_user to provide user-related information. This complex query structure ensures that all aspects of a report's definition and usage are captured.
- 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