Results for “ahl_doc_file_assoc_tl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AHL_DOC_FILE_ASSOC_TL is the translation table for AHL_DOC_FILE_ASSOC_B within the Oracle E-Business Suite AHL (Complex Maintenance Repair and Overhaul) product. Its documented purpose is to store the translated values of the base table's descriptive attributes, keyed by language. In Oracle EBS multilanguage deployments, every "_B" (base) table that carries user-facing translatable text is paired with a "_TL" (translation) table, and this object follows that standard pattern. It is owned by the AHL schema and is marked VALID in the ETRM 12.2.2 metadata, with the same identity in 12.1.1.

The heuristic Data Vault classification derived from the foreign key structure is satellite-leaning. In modeling terms, this suggests treating AHL_DOC_FILE_ASSOC_TL as a satellite attached to the base association entity, capturing language-dependent descriptive attributes rather than participating as a hub or link in its own right. The translation row's grain is association plus language, so it is best considered a dependent, descriptive child of the base association record.

Key Information Stored

The table contains ten documented columns. The most significant are the following:

• ASSOCIATION_ID — Together with LANGUAGE, forms the primary key constraint AHL_DOC_FILE_ASSOC_TL_PK. It is a foreign key to AHL_DOC_FILE_ASSOC_B, tying each translated row to its base document-file association record.
• LANGUAGE — The language code for the translated content and the second component of the primary key. Also appears in the unique index AHL_DOC_FILE_ASSOC_TL_U1 (ASSOCIATION_ID, LANGUAGE), which is the business-key candidate and enforces one translated row per association per language.
• SOURCE_LANG — Identifies the source language of the translatable text, used by the translation framework to determine whether a row holds the original or a derived translation.
• FILE_DESC — The translatable descriptive text for the file association; this is the principal user-facing attribute that varies per language.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting the EBS security group partitioning model.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — The standard EBS WHO audit columns recording who created and last changed each row and when.

The surrogate primary key is ASSOCIATION_ID plus LANGUAGE; there is no single-column surrogate of an independent nature, and the unique index AHL_DOC_FILE_ASSOC_TL_U1 mirrors the primary key columns as the business-key candidate.

Common Use Cases and Queries

Typical reporting joins resolve the language-specific description for a given association. A common pattern restricts to the session or reporting language, with a fallback to the base row's source language when a translation is absent:

• Join AHL_DOC_FILE_ASSOC_TL to AHL_DOC_FILE_ASSOC_B on ASSOCIATION_ID, filtering LANGUAGE to the desired code, to retrieve FILE_DESC in that language.
• Query by ASSOCIATION_ID to enumerate all available translations for an association.
• Use SOURCE_LANG to distinguish original text from translated text in translation-completeness audits.
• Report untranslated associations by comparing base records against translation rows per LANGUAGE.
• Filter by SECURITY_GROUP_ID in multi-organization or secured-access reporting.

Related Objects

• AHL_DOC_FILE_ASSOC_B — The base table; joined on ASSOCIATION_ID. It holds the language-independent association data and is the parent of this translation table.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID; supplies security group definitions used across EBS.
• FND_LANGUAGES — The reference source for LANGUAGE and SOURCE_LANG values, used to decode language names in reports.
• AHL_DOC_FILE_ASSOC_TL_PK / AHL_DOC_FILE_ASSOC_TL_U1 — The primary key and unique constraints that enforce the association-plus-language grain.
• Associated AHL document and file objects — The AHL document management tables that depend on the underlying association entity and, through it, on this translation table for display text.