Blitz Report Assignment Validation – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Lists every Blitz Report with the number of assignments it has at each assignment level, so you can validate that all reports are assigned.

Each level column counts the distinct included assignment targets at that level (Site, Application, Request Group, Responsibility, User, Form, Function, Report). The Excluded column counts exclusion assignments. The zero_to_null function leaves a blank cell where there is no assignment, so reports missing an assignment stand out at a glance - a row that is completely blank across the assignment columns is not assigned to anyone.

Use the Category, Not in Category and Type parameters to limit the scope. Set ‘Not Assigned Only’ to Yes to list only reports that have no include assignment at any level, or pick a level in ‘Not Assigned at Level’ to find reports missing an assignment at one specific level.

Report Parameters

Category, Not in Category, Type, Disabled, Not Assigned Only, Not Assigned at Level

Oracle EBS Tables Used

xxen_reports_v, xxen_report_assignments

Report Categories

Enginatics

Blitz Report Assignment Upload, Blitz Report Template Sharing, Blitz Report Assignments and Responsibilities, Blitz Report Assignments, Blitz Reports, Blitz Report Security, CAC Interface Error Summary, GL Account Distribution Analysis, CAC Inventory Organization 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™ XML Import Blitz_Report_Assignment_Validation.xml
Full SQL on Enginatics www.enginatics.com/reports/blitz-report-assignment-validation/

© 2026 Enginatics