Blitz Report Assignments – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
None
Report Parameters
Type, Category, Assignment Level, Level Value, Show Form Parameter Defaults
Oracle EBS Tables Used
xxen_reports_v, xxen_report_assignments_v, xxen_report_zoom_param_vals_v
Report Categories
Related Reports
Blitz Report Assignment Upload, Blitz Report Parameter Default Values, Blitz Report History, Blitz Report Parameter Table Alias Validation, CAC Inventory Organization Summary, Blitz Reports, Blitz Report Security, CAC Interface Error Summary, GL Account Distribution Analysis
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 Assignments 26-Dec-2021 185157.xlsx |
| Blitz Report™ XML Import | Blitz_Report_Assignments.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/blitz-report-assignments/ |
Blitz Report Assignments - Case Study & Technical Analysis
Executive Summary
Blitz Report Assignments is a system administration report that provides a comprehensive view of how Blitz Reports are distributed across the organization. It details which reports are assigned to which Users, Responsibilities, Applications, or Operating Units. This visibility is crucial for security auditing, license management, and ensuring that users have access to the necessary reporting tools.
Business Challenge
As the number of custom reports grows, tracking who has access to what becomes complex.
- Security Audits: Auditors need to verify that sensitive financial reports are only accessible to authorized personnel.
- Troubleshooting: A user complains they cannot see a specific report. Is it assigned to their responsibility? Is the assignment active?
- Cleanup: Identifying reports that are assigned but no longer used or assigned to obsolete responsibilities.
Solution
The Blitz Report Assignments report solves these challenges by listing all active assignments. It allows administrators to:
- Filter by User or Responsibility: Quickly see all reports available to a specific entity.
- Filter by Report: See everyone who has access to a specific sensitive report.
- Verify Parameters: Check if specific assignments have forced default parameters (e.g., restricting a report to a specific Operating Unit).
Technical Architecture
The report queries the core Blitz Report security tables.
Key Tables
XXEN_REPORTS_V: The definition of the report itself.XXEN_REPORT_ASSIGNMENTS_V: The intersection table linking reports to security levels (User, Responsibility, etc.).XXEN_REPORT_ZOOM_PARAM_VALS_V: Stores parameter defaults that are specific to an assignment (e.g., “When run from the ‘UK General Ledger’ responsibility, default the Ledger parameter to ‘UK Primary Ledger’”).
Logic
The query joins the report definitions with the assignment table. It decodes the assignment level (Site, Application, Responsibility, User, Organization, etc.) to provide a human-readable context for each access rule.
Parameters
- Type: Filter by report type (e.g., SQL, PL/SQL, BI Publisher).
- Category: Filter by report category (e.g., Finance, Supply Chain).
- Assignment Level: Filter by the level of assignment (e.g., show only User-level assignments).
- Level Value: Specific value for the level (e.g., a specific User Name or Responsibility Name).
- Show Form Parameter Defaults: Toggle to display if specific parameter values are enforced for the assignment.
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