Results for “ahl_item_groups_tl_h_u1”

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

Overview

AHL_ITEM_GROUPS_TL_H is a translation-enabled history table in the AHL (Complex Maintenance Repair and Overhaul) schema of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores translated, language-specific descriptive information for historical versions of item groups used within the AHL module. The _H suffix indicates this is an audit/history table: it captures prior or versioned states of item group records rather than only the current definition, which is held in the corresponding base table. The _TL component confirms that the table holds translated (multi-language) content. Item groups in AHL are used to categorize and organize items for maintenance, repair, and overhaul activities, and the translated descriptions make those group names usable across the multiple languages configured in an EBS installation.

From a Data Vault modeling perspective, the metadata suggests a satellite-leaning classification. The table's grain is driven by the combination of the parent history surrogate key and the language code, which is characteristic of a descriptive satellite attached to a parent hub/keyed history entity, rather than an independent hub or a many-to-many link.

Key Information Stored

The table is defined with ten columns in the documented 12.2.2 schema. The most significant are:

• ITEM_GROUP_H_ID — The surrogate key linking each translation row to its parent item group history record. This is the primary foreign-key relationship to AHL_ITEM_GROUPS_B_H.
• LANGUAGE — The language code for the translated content, combined with ITEM_GROUP_H_ID to form the composite primary key AHL_ITEM_GROUPS_TL_H_PK.
• DESCRIPTION — The translated descriptive text for the item group history entry.
• SOURCE_LANG — The base language from which the translation originates, used for fallback resolution in EBS multi-language reporting.
• SECURITY_GROUP_ID — The security group assignment, a foreign key to FND_SECURITY_GROUPS, controlling data access partitioning.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS WHO columns that provide audit trail information for the record.

The surrogate primary key is the composite (ITEM_GROUP_H_ID, LANGUAGE). A unique index, AHL_ITEM_GROUPS_TL_H_U1, is defined on the same columns, serving as the business-key candidate that enforces uniqueness of one translation per language per history record.

Common Use Cases and Queries

Typical uses include multi-language reporting on historical item group names, auditing how descriptions changed across revisions, and joining translation history to base history for reconciliation. A representative query joins this table to the base history table by the shared surrogate key and filters on language:

SELECT b.ITEM_GROUP_ID, t.LANGUAGE, t.DESCRIPTION
FROM   AHL.AHL_ITEM_GROUPS_B_H b,
       AHL.AHL_ITEM_GROUPS_TL_H t
WHERE  b.ITEM_GROUP_H_ID = t.ITEM_GROUP_H_ID
AND    t.LANGUAGE = USERENV('LANG');

For security-aware reporting, add a predicate on SECURITY_GROUP_ID. Change-tracking reports can order by LAST_UPDATE_DATE to reconstruct a timeline of translated descriptions.

Related Objects

• AHL_ITEM_GROUPS_B_H — The base history table; joined via ITEM_GROUP_H_ID. This is the primary parent of the translated rows.
• AHL_ITEM_GROUPS_TL — The current translation table, corresponding to the "live" (non-history) item group definitions.
• AHL_ITEM_GROUPS_B — The current base item group table.
• FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID for access control.
• FND_LANGUAGES — Provides the valid LANGUAGE codes used in the translation rows.

Together these objects support the complete item group lifecycle—current and historical, base and translated—within the AHL module.