Search Results fnd_lobs

Overview

The FND_LOBS table is a core repository within the Oracle E-Business Suite (EBS) Application Object Library (FND) module. It serves as the central registry for Binary Large Objects (BLOBs) and Character Large Objects (CLOBs) managed by the Generic File Manager (GFM). This infrastructure component provides a unified mechanism for storing, retrieving, and managing file-based content across the application suite. By centralizing LOB storage, it ensures consistent handling, security, and auditing of attachments, documents, images, and other unstructured data, thereby abstracting physical storage complexities from application logic.

Key Information Stored

The table's primary key is FILE_ID, a unique identifier for each stored LOB. While the full column list is not detailed in the provided metadata, a typical FND_LOBS structure includes critical attributes beyond the primary key. These commonly encompass the actual LOB data (in a BLOB or CLOB column), the original file name (FILE_NAME), the content type (CONTENT_TYPE), the size of the data (FILE_SIZE), and creation metadata such as CREATED_BY and CREATION_DATE. The table's design facilitates efficient storage and retrieval of large objects while maintaining referential integrity with transactional data through foreign key relationships.

Common Use Cases and Queries

The primary use case is querying and managing files attached to various EBS entities. Common operations include identifying large or orphaned files for cleanup, auditing attachment usage, and troubleshooting file access issues. A fundamental query retrieves file metadata for a specific document or attachment referenced in another module's table.

• Sample Query (Basic Metadata): SELECT file_id, file_name, content_type, file_size FROM apps.fnd_lobs WHERE file_id = :p_file_id;
• Identifying Referenced Files: Queries often join FND_LOBS with foreign key tables, such as FND_HELP_DOCUMENTS or IBC_CITEM_VERSIONS_TL, to link a file with its business context. Direct manipulation of LOB data in this table is typically performed through the dedicated Generic File Manager APIs (e.g., FND_FILE_API, FND_GFM) rather than via direct SQL DML.

Related Objects

As indicated by the foreign key metadata, FND_LOBS is a foundational table referenced by numerous EBS modules. Key related objects include:

• FND_LOB_ACCESS: Directly related table for managing access control and permissions on the stored LOBs.
• Module-Specific Tables: Includes AHL_DOC_FILE_ASSOC_B (Service), CSS_DEF_ATTACHMENTS_B (Support), FND_HELP_DOCUMENTS (Help), IBC_CITEM_VERSIONS_TL (Content Manager), JTF_AMV_ATTACHMENTS (Marketing), and PRP_* tables (Proposals).
• APIs: The FND_FILE_API and FND_GFM packages provide the standard, supported interface for creating, updating, deleting, and retrieving data stored in FND_LOBS.