Skip to content

FND Applications

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

FND Applications

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
DESCRIPTION.md
DESCRIPTION.md
 
 
FND Applications.sql
FND Applications.sql
 
 
README.md
README.md
 
 

README.md

layout default
title FND Applications | Oracle EBS SQL Report
description Shows all applications, their installation status, correponding database schema, application top name and audit status
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, FND, Applications, fnd_data_group_units, fnd_oracle_userid, xxen_report_license_key
permalink /FND%20Applications/

FND Applications – Oracle EBS SQL Report

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

Overview

Shows all applications, their installation status, correponding database schema, application top name and audit status

Report Parameters

Application Short Name, Application Name

Oracle EBS Tables Used

fnd_data_group_units, fnd_oracle_userid, xxen_report_license_key, fnd_application_vl, fnd_product_installations, dba_users, fnd_audit_schemas, fnd_mo_product_init

Report Categories

Enginatics

Related Reports

FND Audit Setup, FND Lookup Search, FND Responsibility Access, FND Responsibilities, FND Responsibility Access 11i, CAC Interface Error Summary, FND Histogram Columns, CAC Receiving Value (Period-End), 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 FND Applications 20-Dec-2022 093439.xlsx
Blitz Report™ XML Import FND_Applications.xml
Full SQL on Enginatics www.enginatics.com/reports/fnd-applications/

Executive Summary

The FND Applications report provides a high-level inventory of all registered applications within the Oracle E-Business Suite. It details their installation status, base paths, and audit configurations.

Business Challenge

  • License Management: Identifying which modules are installed and active.
  • System Auditing: Verifying which applications have audit trails enabled.
  • Environment Assessment: Quickly understanding the footprint of the EBS implementation.

The Solution

This Blitz Report offers a comprehensive system overview:

  • Installation Status: Shows if an app is 'Installed', 'Shared', or 'Inactive'.
  • Schema Mapping: Links the application to its Oracle ID (schema name).
  • Audit Status: Indicates if the "AuditTrail:Activate" profile is set and if the schema is audited.

Technical Architecture

The report joins FND_APPLICATION_VL with FND_PRODUCT_INSTALLATIONS and FND_ORACLE_USERID. It also checks FND_AUDIT_SCHEMAS to report on audit configurations.

Parameters & Filtering

  • Application Name/Short Name: Filter for specific modules (e.g., 'Payables', 'SQLGL').

Performance & Optimization

  • Fast Execution: This report runs very quickly as it queries small metadata tables.
  • No Parameters: Running without parameters gives the full list of 200+ standard modules.

FAQ

  • Q: What does "Shared" status mean?
    • A: It means the application is available for use, but its data model might be shared with another installed application (common in older EBS versions).
  • Q: Can I see patch levels here?
    • A: No, this report shows registration status. For patch levels, use "AD Applied Patches".

Useful Links

© 2026 Enginatics