Blitz Report Application Categories – 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
Oracle application -> Blitz Report assignment via lookup XXEN_REPORT_APPS_CATEGORIES.
This setup controls how automatically imported BI publisher reports and concurrent programs are assigned to Blitz Report categories.
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
fnd_lookup_values, fnd_application_vl
Report Categories
Related Reports
GL Balance by Account Hierarchy, GL Account Analysis, AP Invoice Upload
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 | Blitz Report Application Categories 18-Jan-2018 225804.xlsx |
| Blitz Report™ XML Import | Blitz_Report_Application_Categories.xml |
| SQL Source | Blitz Report Application Categories.sql |
| Full Report on Enginatics | www.enginatics.com/reports/blitz-report-application-categories/ |
Blitz Report Application Categories - Case Study & Technical Analysis
Executive Summary
The Blitz Report Application Categories report is a configuration audit and setup tool. It defines the mapping between Oracle E-Business Suite Applications (e.g., “Payables”, “Receivables”) and Blitz Report Categories. This mapping drives the automatic categorization of reports when they are imported from standard Concurrent Programs or BI Publisher, ensuring an organized and intuitive report repository.
Business Challenge
When migrating hundreds of legacy reports into Blitz Report, organization is key.
- Clutter: Without categorization, a library of 500 reports becomes unsearchable.
- Manual Effort: Manually assigning a category to every imported report is tedious.
- Consistency: Different developers might categorize “Invoice Aging” differently (e.g., “AP” vs. “Payables” vs. “Finance”).
Solution
The Blitz Report Application Categories setup automates this organization:
- Auto-Assignment: When a report is imported (e.g.,
APXAGING), the system looks up its application (SQLAP), finds the mapped category (e.g., “Accounts Payable”), and assigns it automatically. - Standardization: Enforces a consistent taxonomy across the organization.
- Maintenance: Allows for easy re-mapping if category structures change.
Technical Architecture
The logic relies on a specific lookup type that acts as the mapping table.
Key Tables & Joins
- Mapping:
FND_LOOKUP_VALUES(specifically the lookup typeXXEN_REPORT_APPS_CATEGORIES) stores the relationship.- Lookup Code: The Oracle Application Short Name (e.g., ‘SQLAP’).
- Meaning: The Blitz Report Category Name (e.g., ‘Accounts Payable’).
- Application:
FND_APPLICATION_VLvalidates the application codes.
Logic
- Retrieval: Lists all defined mappings from the lookup type.
- Validation: Ensures that the Application Short Name exists in FND_APPLICATION.
- Usage: This mapping is consumed by the “Import” feature in Blitz Report.
Parameters
- None: Typically runs as a full list of all mappings.
FAQ
Q: What happens if an application is not mapped? A: If a report belongs to an application that isn’t in this mapping, it is usually assigned to a default category (e.g., “Uncategorized” or “Other”) or the category matching the application name itself.
Q: Can I map multiple applications to one category? A: Yes. For example, you could map both ‘SQLAP’ (Payables) and ‘AP’ (Payables Intelligence) to the single category “Accounts Payable”.
Q: How do I add a new mapping?
A: You add a new code to the XXEN_REPORT_APPS_CATEGORIES lookup type via the standard Oracle Lookups form or via a setup 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
© Enginatics GmbH