Search Results eng_attachment_changes




Overview
Explore in AI Chat

Overview

ENG_ATTACHMENT_CHANGES is an Engineering (ENG) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments that stores attachment-related changes recorded against revised engineering items. It functions as the transactional log for attachment operations on Engineering Change Orders (ECOs) and revised items, capturing actions such as adding, replacing, deleting, or modifying file attachments and their associated metadata (file names, descriptions, categories, and repository attributes).

The table resides in the ENG schema and is documented as VALID in ETRM 12.2.2 with 36 physical columns and a single unique index, ENG_ATTACHMENT_CHANGES_U1, on CHANGE_DOCUMENT_ID. The ETRM Data Vault classification heuristic returns "standalone," meaning the FK structure does not strongly bind this table into a dimensional hub/link/satellite topology; it behaves as an independent change-audit table. Where a Data Vault model is desired, this object is best treated as a satellite-like change log keyed by its own surrogate, with CHANGE_DOCUMENT_ID as the natural business key candidate.

Key Information Stored

Notable columns include the following:

Common Use Cases and Queries

Typical usage is auditing and reporting on attachment activity within engineering change workflows. Example queries include:

  • Listing all attachment changes for a given revised item:
    SELECT change_id, action_type, file_name, new_file_name, attached_user_id, creation_date FROM eng.eng_attachment_changes WHERE revised_item_sequence_id = :seq_id ORDER BY creation_date;
  • Auditing renames and reclassifications:
    SELECT change_document_id, file_name, new_file_name, category_id, new_category_id FROM eng.eng_attachment_changes WHERE file_name <> new_file_name OR category_id <> new_category_id;
  • User activity reporting:
    SELECT attached_user_id, COUNT(*) FROM eng.eng_attachment_changes GROUP BY attached_user_id;
  • Joining to ENG_REVISED_ITEMS to enrich with ECO context.

Related Objects

  • ENG_REVISED_ITEMS — joined on ENG_ATTACHMENT_CHANGES.REVISED_ITEM_SEQUENCE_ID = ENG_REVISED_ITEMS.SEQUENCE_ID.
  • AS_CONTACT_FAMILY — joined on ENG_ATTACHMENT_CHANGES.FAMILY_ID = AS_CONTACT_FAMILY.FAMILY_ID.
  • FND_ATTACHED_DOCUMENTS / FND_DOCUMENTS — attachment framework tables linked via ATTACHMENT_ID.
  • ENG_ECO_DEFINITIONS / ENG_CHANGE_ORDERS — ECO context for the associated change document.
  • FND_USER — references ATTACHED_USER_ID, CREATED_BY, and LAST_UPDATED_BY for user attribution.