Blitz Report License Exceeding Users – 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

Users whose Blitz Report runs were refused with ‘Invalid License: maximum users exceeded’ within the past 60 days, and who do not hold one of the licensed user seats now.

The row count is the number of additional user licenses needed to admit all of them. A user who has since obtained a seat, because another licensed user did not run reports for 60 days, is not listed.

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

None

Oracle EBS Tables Used

xxen_report_runs, fnd_user, xxen_reports_v, xxen_report_license_users

Report Categories

Enginatics

Blitz Report License Users, Blitz Report Execution Summary, Blitz Report History Summary, Blitz Report Assignment Upload, Blitz Upload History

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 Example
Blitz Report™ XML Import Blitz_Report_License_Exceeding_Users.xml
SQL Source Blitz Report License Exceeding Users.sql
Full Report on Enginatics www.enginatics.com/reports/blitz-report-license-exceeding-users/

© Enginatics GmbH