Skip to content

README.md

Latest commit

 

History

History
88 lines (57 loc) · 5.12 KB

README.md

File metadata and controls

88 lines (57 loc) · 5.12 KB
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/

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

Enginatics

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

© 2026 Enginatics