Blitz Report Category Assignment Upload – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Upload to maintain Blitz Report category assignments - the categories that reports and uploads are grouped under.
Run modes:
-
Create with ‘Create Empty File’ = Yes: opens an empty Excel file to enter new report and category rows.
-
Create with ‘Create Empty File’ = blank: queries a list of reports (by name, category or type) as blank rows to assign categories to.
-
Create, Update: queries existing category assignments, which can be removed by setting the Delete column to Yes.
Enter any Category name. If the category does not exist yet, it is created automatically in all installed languages and the report is assigned to it. Set Delete = Yes to remove a report from a category; the category itself is kept even if it becomes empty.
Report Parameters
Upload Mode, Create Empty File, Report Name starts with, Report Category, Report Type
Oracle EBS Tables Used
xxen_reports_v, xxen_report_category_assigns_v
Report Categories
Related Reports
Blitz Report Parameter Table Alias Validation, Blitz Report Category Assignments, Blitz Report Default Templates, Blitz Report Comparison between environments, Blitz Report RDF Import Validation, Blitz Upload Dependencies, Blitz Report Assignment Upload
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_Category_Assignment_Upload.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/blitz-report-category-assignment-upload/ |
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