Blitz Report User 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

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.

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

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, Blitz Report Template Sharing, FND Responsibility Upload, FND Responsibilities, FND Responsibility Access, INV Item Upload 11i, FND Users

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 User History 10-Nov-2020 205738.xlsx
Blitz Report™ XML Import Blitz_Report_User_History.xml
SQL Source Blitz Report User History.sql
Full Report 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.

© Enginatics GmbH