Blitz Report License User History – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Shows the history of active Blitz Report users at every at every month end, looking back the past 60 days.
Report Parameters
Oracle EBS Tables Used
dual, xxen_report_runs, fnd_user, xxen_reports_v
Report Categories
Related Reports
Blitz Upload History, Blitz Report License Users, Blitz Reports, Blitz Report History, Blitz Upload Data, CAC Interface Error Summary, CAC Inventory Organization Summary, Blitz Report Execution 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 License User History 15-Mar-2024 212941.xlsx |
| Blitz Report™ XML Import | Blitz_Report_License_User_History.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/blitz-report-license-user-history/ |
Blitz Report License User History - Case Study & Technical Analysis
Executive Summary
Blitz Report License User History is a compliance and usage tracking report. It tracks the number of active Blitz Report users over time, typically providing a snapshot at each month-end. This is used to monitor license compliance (if the license is user-based) and to understand adoption trends.
Business Challenge
- License Compliance: Ensuring the organization is within its purchased user limit.
- Trend Analysis: Is usage growing? Do we need to purchase more licenses next year?
- Cost Allocation: Potentially charging back costs to departments based on their active user count.
Solution
This report calculates the “Active Users” metric historically.
- Lookback: The description mentions “looking back the past 60 days,” suggesting it counts users who have run at least one report in that window as “active.”
- Monthly Snapshots: It provides a trend line rather than just a current snapshot.
Technical Architecture
Key Tables
XXEN_REPORT_RUNS: The source of activity data.FND_USER: To identify the users.DUAL: Likely used to generate the timeline (months).
Logic
The query likely generates a series of dates (month ends) and for each date, counts the distinct users who appeared in XXEN_REPORT_RUNS in the preceding period (e.g., 60 days).
Parameters
- (None listed, likely runs automatically for the system history).
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
© 2026 Enginatics