Blitz Report User History – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Lists all active EBS users with their active responsibilities and blitz report execution counts. The report can be used to analyze blitz report usage within the EBS user community e.g. to find the most active users or to spot the ones not using blitz report to it’s full potential yet.

Report Parameters

Last Logon Date within x days, Executions within x days

Oracle EBS Tables Used

fnd_user, fnd_user_resp_groups, fnd_responsibility_vl, fnd_application_vl, fnd_request_groups, xxen_report_runs

Report Categories

Enginatics

Blitz Report Assignments and Responsibilities, FND Responsibility Access 11i, FND Responsibilities, FND Responsibility Access, INV Items, INV Item Upload, CAC ICP PII Material Account Detail, CAC Inventory Organization Summary

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 User History 10-Nov-2020 205738.xlsx
Blitz Report™ XML Import Blitz_Report_User_History.xml
Full SQL on Enginatics www.enginatics.com/reports/blitz-report-user-history/

Executive Summary

The Blitz Report User History report is an analytical tool designed to track and evaluate user engagement with Blitz Reports in the Oracle E-Business Suite. It provides a detailed list of active users, their responsibilities, and the number of Blitz Reports they have executed, offering valuable insights into adoption and usage patterns.

Business Challenge

Understanding how users interact with reporting tools is crucial for maximizing the return on investment in software like Blitz Report. Organizations often struggle to identify which users are actively leveraging the tool and which may need additional training or support. Without this visibility, it is difficult to drive adoption, optimize license usage, or ensure that the reporting capabilities are being utilized to their full potential.

Solution

The Blitz Report User History report addresses this challenge by aggregating usage data into a clear and actionable format. It lists active EBS users along with their assigned responsibilities and execution counts for Blitz Reports. This allows administrators and managers to pinpoint power users, identify underutilized accounts, and tailor training programs to improve overall efficiency.

Key Features

Technical Details

The report queries standard Oracle FND tables such as fnd_user, fnd_user_resp_groups, fnd_responsibility_vl, fnd_application_vl, and fnd_request_groups, as well as the Blitz Report specific table xxen_report_runs. This combination of data sources ensures a comprehensive view of user activity and report execution history.

© 2026 Enginatics