FND Help Documents and Targets – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
None
Report Parameters
Application Name, Application Short Name, Show Targets, Show File Data, Cutomization Level from, Language Code
Oracle EBS Tables Used
fnd_application_vl, fnd_help_documents, fnd_lobs, fnd_help_targets
Report Categories
Related Reports
AP Invoices and Lines, FND Attached Documents, GL Journals (Drilldown)
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 Help Documents and Targets 12-May-2020 185936.xlsx |
| Blitz Report™ XML Import | FND_Help_Documents_and_Targets.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-help-documents-and-targets/ |
Executive Summary
The FND Help Documents and Targets report lists the custom help files and targets registered in the Oracle EBS Help System.
Business Challenge
- Training Support: Verifying that custom help documents are properly linked to application screens.
- Content Management: Reviewing the list of uploaded help files to identify obsolete content.
The Solution
This Blitz Report lists the help configuration:
- Application: The owning application.
- Target: The link target (used to call help from a form).
- File Data: Can optionally show the content of the help file.
Technical Architecture
The report queries FND_HELP_DOCUMENTS and FND_HELP_TARGETS.
Parameters & Filtering
- Application Name: Filter by module.
- Show File Data: Toggle to include the BLOB/CLOB content (use with caution).
Performance & Optimization
- Large Data: Avoid “Show File Data” unless you are looking for a specific document, as it can pull large amounts of text.
FAQ
- Q: Is this commonly used?
- A: Less so in modern R12 environments where UPK or external knowledge bases are preferred, but still relevant for legacy help customizations.
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
© 2026 Enginatics