Blitz Reports – 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

All Enginatics report details can be seen here: https://www.enginatics.com/library/?pg=1&category[&utm_source=oraclereporting.com&utm_medium=referral&utm_campaign=oracle-ebs-sql&utm_content=blitz-reports]=Enginatics

Blitz Reports with parameters and assignments.

Show Parameters, Show Upload Parameters, Show Upload Columns and Show Assignments list different detail rows and can be used only one at a time: each is greyed out while another one is set, and Parameter Name or Parameter Type count as Show Parameters. Show Upload Parameters includes the setup of the upload column each parameter maps to. 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’.

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

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, Disabled, 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

Oracle EBS Tables Used

xxen_reports_v, 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

Report Categories

Enginatics

Blitz Report History, GL Account Distribution Analysis, DIS End User Layers, Blitz Report LOVs, Blitz Report Security, Blitz Report Template Sharing, Blitz Report Assignment Upload

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 Reports 10-Aug-2020 140427.xlsx
Blitz Report™ XML Import Blitz_Reports.xml
SQL Source Blitz Reports.sql
Full Report on Enginatics www.enginatics.com/reports/blitz-reports/

Executive Summary

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.

Business Challenge

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.

Solution

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.

Key Features

Technical Details

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.

© Enginatics GmbH