Results for “document_title”

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

Overview

In Oracle E-Business Suite 12.1.1 and 12.2.2, AHL.AHL_DOCUMENTS_TL is a translation-level (TL) table owned by the AHL schema, which supports the Complex Maintenance Repair and Overhaul (CMRO) module. Its documented purpose is to store the translated column information for documents. In Oracle EBS, TL tables hold the language-dependent descriptive attributes of a base entity, while the corresponding base ("_B") table holds language-independent attributes. Because each document can exist in multiple installed languages, AHL_DOCUMENTS_TL carries one row per document per language, allowing document titles and related display text to be presented in the session language without duplicating operational data.

The table is classified, as a heuristic modeling suggestion, as satellite-leaning within a Data Vault style. This reflects its structural role: it is a dependent, descriptive table that hangs off the base document entity via a single foreign key, carrying mutable, non-identifying descriptive attributes (the document title and language context) keyed by the parent entity's identifier plus language.

Key Information Stored

The documented physical schema describes ten columns. The most significant are:

• DOCUMENT_ID — the surrogate identifier of the parent document, forming part of the composite primary key and joining to the base table.
• LANGUAGE — the language code for this translation row; together with DOCUMENT_ID it forms the primary key and the unique index candidate.
• DOCUMENT_TITLE — the translated, language-dependent title of the document; the core descriptive payload of this table.
• SOURCE_LANG — the language in which the source title was originally created, supporting Oracle's translation and language-derivation model.
• SECURITY_GROUP_ID — the security grouping used for data access and multi-tenant style filtering (referenced via foreign key to FND_SECURITY_GROUPS).
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — the standard Oracle "WHO" audit columns recording creation and last-modification metadata for each translation row.

The surrogate/composite primary key is AHL_DOCUMENTS_TL_PK (DOCUMENT_ID, LANGUAGE). The unique index AHL_DOCUMENTS_TL_U1 (DOCUMENT_ID, LANGUAGE) is documented as a business-key candidate, reinforcing that a document has at most one translation row per language.

Common Use Cases and Queries

Typical usage centers on retrieving the document title in the appropriate language while resolving the base document record. A representative query joins the base and translation tables:

• SELECT b.document_id, t.document_title, t.language FROM ahl_documents_b b, ahl_documents_tl t WHERE b.document_id = t.document_id AND t.language = USERENV('LANG');
• Reporting on all languages available for a given document: filter on a specific DOCUMENT_ID and select LANGUAGE and DOCUMENT_TITLE.
• Auditing translation coverage: compare the number of rows per DOCUMENT_ID in the TL table against the expected set of installed languages.
• Security-scoped reporting: join to FND_SECURITY_GROUPS on SECURITY_GROUP_ID when access filtering is required.

Related Objects

The FK/relationship data identifies the principal dependencies of this table:

• AHL_DOCUMENTS_B — the base document table; joined on AHL_DOCUMENTS_TL.DOCUMENT_ID = AHL_DOCUMENTS_B.DOCUMENT_ID. This is the primary parent.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for security grouping.

In practice, related document attributes (such as the language-independent fields held in AHL_DOCUMENTS_B) and any views or DFF-enabled UI layers that present document titles for the CMRO module also depend on this table. Because the documentation names only AHL_DOCUMENTS_B and FND_SECURITY_GROUPS as foreign-key targets, those remain the authoritative, ETRM-documented related objects.