Skip to the content.

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

Enginatics

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.

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.


© Enginatics GmbH