FND Applications – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Application Object Library · all Application Object Library reports
Overview
Shows all applications, their installation status, correponding database schema, application top name and audit status
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
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
Related Reports
FND Audit Setup, DBA Users, FND Lookup Search, FND Responsibility Access, FND Responsibilities, FND Histogram Columns, CAC Interface Error Summary, FND Data Groups
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 | FND Applications 20-Dec-2022 093439.xlsx |
| Blitz Report™ XML Import | FND_Applications.xml |
| SQL Source | FND Applications.sql |
| Full Report 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
- 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