FND Attached Documents – 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

FND attachments stored in the fnd_lobs table and their corresponding application entity e.g. sales orders that they are attached to.

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

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_operation_sequences, bom_operational_routings, bom_structures_b, wip_discrete_jobs, wip_entities, wsh_delivery_details, wsh_new_deliveries, ra_customer_trx_all, ra_customer_trx_lines_all, hz_cust_accounts, qa_results, qa_plans, 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

Enginatics

Related Reports

GL Account Distribution Analysis, GL Account Analysis, GL Account Analysis (Drilldown) (with inventory and WIP), PO Procure to Pay Tracker, AP Invoices with PO, Intercompany and SLA Details, INV Movement Statistics, PO Purchase Requisitions with PO Details, INV Intercompany Invoice Reconciliation, PO Receiving Transactions

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 Attached Documents 09-Sep-2018 083127.xlsx
Blitz Report™ XML Import	FND_Attached_Documents.xml
SQL Source	FND Attached Documents.sql
Full Report 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_ALL via pk1_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 Entity or Attached to Application to 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

© Enginatics GmbH