Search Results ahl_doc_file_assoc_b




Overview
Explore in AI Chat

Overview

The AHL_DOC_FILE_ASSOC_B table is a core data object within the Oracle E-Business Suite Complex Maintenance, Repair, and Overhaul (CMRO) module. It serves as the foundational base table for managing the association between technical documents and their attached files. Its primary role is to establish and maintain the formal link between a specific document revision and a binary file stored within the database, enabling the CMRO application to support rich, file-based documentation essential for maintenance and repair operations. This functionality was introduced as part of the 11.5.10 enhancements to the AHL product line.

Key Information Stored

The table's structure is designed to manage the relationship metadata between documents and files. The central column is the ASSOCIATION_ID, which serves as the primary key uniquely identifying each document-file link. The REVISION_ID is a critical foreign key that links the association to a specific version of a document in the AHL_DOC_REVISIONS_B table. The FILE_ID column is another essential foreign key that references the FND_LOBS table, which is the Oracle EBS repository for storing the actual binary content of the attached file. Additional columns, not detailed in the excerpt but typical for such association tables, would include standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) for auditing and the OBJECT_VERSION_NUMBER for optimistic locking.

Common Use Cases and Queries

This table is central to any process involving document attachments within CMRO. A common use case is retrieving all files attached to a specific document revision for display or download within the application. Developers and support personnel may query this table to diagnose missing attachments or to generate reports on document usage. A typical SQL pattern involves joining to the related document and file tables:

  • To list file associations for a document revision: SELECT assoc.association_id, lob.file_name FROM ahl_doc_file_assoc_b assoc, fnd_lobs lob WHERE assoc.file_id = lob.file_id AND assoc.revision_id = :p_rev_id;
  • To identify documents with attachments: SELECT DISTINCT rev.document_id FROM ahl_doc_file_assoc_b assoc, ahl_doc_revisions_b rev WHERE assoc.revision_id = rev.revision_id;

Related Objects

The AHL_DOC_FILE_ASSOC_B table is part of a tightly integrated schema. Its primary key is enforced by the AHL_DOC_FILE_ASSOC_B_PK1 constraint. It maintains critical foreign key relationships with the AHL_DOC_REVISIONS_B table (via REVISION_ID) to link to the document revision, and with the FND_LOBS table (via FILE_ID) to link to the physical file data. Furthermore, it has a one-to-many relationship with the AHL_DOC_FILE_ASSOC_TL table, which holds translated descriptive information for the association, linking via the ASSOCIATION_ID column. Any application logic creating or managing document attachments will interact with this table and its related APIs.