Search Results css_def_attachments_b

Overview

The CSS_DEF_ATTACHMENTS_B table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically designed for the CSS (Support) module. As indicated by its name, its primary role is to store metadata and references for file attachments linked to support defects. This table functions as the base table for attachment records, managing the relationship between a defect and its associated file content. It is critical to note that the CSS - Support module is marked as obsolete in the provided documentation, meaning this table is part of a legacy functional area that may not be actively developed but remains present in the database for existing implementations.

Key Information Stored

The table's structure centers on linking an attachment to a specific defect and its physical file data. The primary key, ATTACHMENT_ID, uniquely identifies each attachment record. The two critical foreign key columns define its core relationships: DEFECT_ID links the attachment to a specific record in the CSS_DEF_DEFECTS_B table, establishing which defect the file belongs to. FILE_ID references the FND_LOBS table, which is the standard Oracle Applications repository for storing the actual binary Large Object (LOB) data of the attached file. While the full column list is not detailed in the excerpt, typical columns in such a table would include creation date, created by, last update date, and file metadata like the original file name and MIME type.

Common Use Cases and Queries

The primary use case is retrieving attachments for a given support defect for display or download within the application interface. A common reporting need is to list all attachments across defects, perhaps for auditing or migration purposes. Sample SQL to fetch attachment metadata for a specific defect would involve joining to the defects and LOB tables:

• SELECT att.attachment_id, att.file_id, lob.file_name, lob.file_content_type, lob.file_data FROM css_def_attachments_b att, fnd_lobs lob WHERE att.file_id = lob.file_id AND att.defect_id = :p_defect_id;

Given the module's obsolete status, direct interaction with this table is typically confined to data extraction, legacy report generation, or data cleansing activities rather than new application development.

Related Objects

CSS_DEF_ATTACHMENTS_B is intrinsically linked to a small set of key database objects. Its most direct relationship is with the CSS_DEF_DEFECTS_B table via the DEFECT_ID foreign key; this is the parent table for defect records. The connection to FND_LOBS via the FILE_ID foreign key is essential, as it separates the attachment metadata from the physical file storage, following standard EBS design patterns. While not explicitly listed, a corresponding _TL (Translation) table named CSS_DEF_ATTACHMENTS_TL likely exists to store translated descriptions of the attachments. Furthermore, this base table is typically associated with a database view (e.g., CSS_DEF_ATTACHMENTS) that provides a more application-friendly interface, potentially incorporating descriptive flexfield columns and join logic.