Blitz Report Application Categories – Oracle EBS SQL Report

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

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.

Report Parameters

Oracle EBS Tables Used

fnd_lookup_values, table, fnd_application_vl

Report Categories

Enginatics

AP Invoice Upload, CAC Receiving Expense Value (Period-End), GL Account Distribution Analysis, CAC Receiving Account Detail, GL Balance by Account Hierarchy, GL Account 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 Application Categories 18-Jan-2018 225804.xlsx
Blitz Report™ XML Import Blitz_Report_Application_Categories.xml
Full SQL 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.

Solution

The Blitz Report Application Categories setup automates this organization:

Technical Architecture

The logic relies on a specific lookup type that acts as the mapping table.

Key Tables & Joins

Logic

  1. Retrieval: Lists all defined mappings from the lookup type.
  2. Validation: Ensures that the Application Short Name exists in FND_APPLICATION.
  3. Usage: This mapping is consumed by the “Import” feature in Blitz Report.

Parameters

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.

© 2026 Enginatics