FND Attached Documents – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
FND attachments stored in the fnd_lobs table and their corresponding application entity e.g. sales orders that they are attached to.
Report Parameters
Category, Datatype, File Name contains, Short Text contains, Text contains, Creation Date from, Creation Date to, Created within days, Created By, Show Attachment Objects, Attached to Application, Document Entity
Oracle EBS Tables Used
hr_all_organization_units_vl, po_headers_all, po_releases_all, po_requisition_headers_all, po_lines_all, po_requisition_lines_all, po_line_locations_all, ap_invoices_all, mtl_parameters, mtl_system_items_b_kfv, oe_order_headers_all, oe_order_lines_all, bom_operational_routings, bom_operation_sequences, bom_structures_b, wip_entities, wip_discrete_jobs, wsh_delivery_details, wsh_new_deliveries, ra_customer_trx_all, ra_customer_trx_lines_all, hz_cust_accounts, qa_plans, qa_results, per_people_x, pa_projects_all, per_all_assignments_f, per_jobs_vl, bom_standard_operations, gl_je_batches, gl_je_headers, fnd_documents, fnd_documents_tl, fnd_document_datatypes_vl, fnd_document_categories_vl, gl_ledgers, fnd_lobs, fnd_concurrent_programs_vl, fnd_documents_short_text, fnd_documents_long_text, fnd_attached_documents, fnd_document_entities_vl, fnd_dm_nodes
Report Categories
Related Reports
CAC Manufacturing Variance, CAC Purchase Price Variance, CAC Receiving Account Detail, PO Purchase Requisitions with PO Details, AP Invoices and Lines, GL Account Analysis, AP Invoice Upload, PO Headers and Lines
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 Attached Documents 09-Sep-2018 083127.xlsx |
| Blitz Report™ XML Import | FND_Attached_Documents.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-attached-documents/ |
Executive Summary
The FND Attached Documents report is a powerful tool for extracting and analyzing attachments across the entire EBS system. It links generic attachment data (stored in FND_LOBS) back to the specific business objects (like POs, Invoices, or Journals) they belong to.
Business Challenge
- Data Governance: Identifying large or inappropriate files attached to transactions.
- Audit Support: Retrieving all supporting documents (e.g., scanned invoices) for a sample of transactions.
- Storage Management: Analyzing which modules or users are consuming the most database storage with attachments.
The Solution
This Blitz Report bridges the gap between technical storage and business context:
- Entity Mapping: Dynamically links attachments to their parent entity (e.g., linking a file to
PO_HEADERS_ALLviapk1_value). - Content Search: Allows searching within Short Text and Long Text attachments.
- Metadata Analysis: Reports on file size, type, creation date, and author.
Technical Architecture
The report queries FND_ATTACHED_DOCUMENTS, FND_DOCUMENTS, and FND_LOBS. It uses complex dynamic SQL or extensive LEFT JOINS to resolve the pk1_value, pk2_value, etc., into meaningful business keys (like Order Number or Invoice Number) based on the entity_name.
Parameters & Filtering
- Entity/Category: Filter by “Requisition Headers”, “AP Invoices”, etc.
- Date Range: When the attachment was created.
- File Content: Search for keywords in text attachments.
Performance & Optimization
- Entity Filter: Always filter by
Document EntityorAttached to Applicationto avoid scanning the entire attachment repository, which can be massive. - LOB Access: The report typically lists metadata. Downloading the actual BLOB content for thousands of rows would be very slow.
FAQ
- Q: Can I download the files?
- A: The report lists the files. Blitz Report has features to download attachments if configured, or you can use the URL links if generated.
- Q: Why do I see “pk1_value” instead of “Invoice Number”?
- A: If the specific entity mapping isn’t defined in the report’s logic, it falls back to the raw primary key. The report covers most standard entities (PO, AP, OM, GL, WIP).
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