| layout | default |
|---|---|
| title | Blitz Report License User History | Oracle EBS SQL Report |
| description | Shows the history of active Blitz Report users at every at every month end, looking back the past 60 days. |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, Blitz, Report, License, User, dual, xxen_report_runs, fnd_user |
| permalink | /Blitz%20Report%20License%20User%20History/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Shows the history of active Blitz Report users at every at every month end, looking back the past 60 days.
dual, xxen_report_runs, fnd_user, xxen_reports_v
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
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 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 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.
- 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.
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.
XXEN_REPORT_RUNS: The source of activity data.FND_USER: To identify the users.DUAL: Likely used to generate the timeline (months).
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).
- (None listed, likely runs automatically for the system history).
- 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