Results for “mtl_item_catalog_groups_tl”

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

Overview

MTL_ITEM_CATALOG_GROUPS_TL is the translation (TL) table for Item Catalog Groups within the Oracle Inventory (INV) module. Item catalog groups provide a grouping mechanism used classify items for descriptive flexfield and catalog-related functionality, enabling organizations to organize items into logical categories for searching, reporting, and flexfield context validation. This table stores the language-dependent descriptive text for each catalog group, most notably the translated DESCRIPTION column, while the language-independent attributes reside in the companion base table MTL_ITEM_CATALOG_GROUPS_B.

From a Data Vault modeling perspective, this object is heuristically classified as satellite-leaning. It does not represent an independent business concept, nor does it serve as a pure link between two hubs; instead, it carries descriptive, language-specific attributes that hang off the catalog group identifier defined in the base table. The table is owned by the INV schema and is marked VALID in the ETRM 12.2.2 metadata.

Key Information Stored

The table holds ten documented columns. The most functionally significant are described below.

• ITEM_CATALOG_GROUP_ID — The surrogate identifier for the catalog group. Together with LANGUAGE, it forms the composite primary key (MTL_ITEM_CATALOG_GROUPS_TL_PK) and is the foreign key that ties each translation row back to the base table MTL_ITEM_CATALOG_GROUPS_B.
• LANGUAGE — The NLS language code in which the translated text is rendered. It is the second component of the primary key and the discriminator that allows multiple language rows per catalog group.
• DESCRIPTION — The translated description of the item catalog group, which is the principal translated payload of this table.
• SOURCE_LANG — Identifies the source language from which the translation was derived, supporting the oracle translations framework.
• ZD_EDITION_NAME — The editioning column introduced by the E-Business Suite editioning architecture. It participates in the unique index MTL_ITEM_CATALOG_GROUPS_TL_U1 (ITEM_CATALOG_GROUP_ID, LANGUAGE, ZD_EDITION_NAME) and enables online patching (adop) in 12.2.x by isolating edition-specific rows.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN capture the standard who/when audit trail for the translation record.

The business-key candidate is the unique index MTL_ITEM_CATALOG_GROUPS_TL_U1, combining ITEM_CATALOG_GROUP_ID, LANGUAGE, and ZD_EDITION_NAME; the true surrogate identity remains the primary key pair of ITEM_CATALOG_GROUP_ID and LANGUAGE.

Common Use Cases and Queries

Typical usage centers on displaying catalog group descriptions in the user's session language and joining translation text to the base table for reporting.

• Retrieving descriptions in the current NLS language for a given catalog group set.
• Reporting catalog groups with their translated names for organizational documentation.
• Validating that translations exist for all languages required by a multi-country implementation.

A representative query joining base and translation tables:

SELECT b.item_catalog_group_id, t.description
FROM mtl_item_catalog_groups_b b, mtl_item_catalog_groups_tl t
WHERE b.item_catalog_group_id = t.item_catalog_group_id
AND t.language = USERENV('LANG');

A translation-coverage check can group by ITEM_CATALOG_GROUP_ID and compare COUNT(DISTINCT LANGUAGE) against the set of installed languages.

Related Objects

• MTL_ITEM_CATALOG_GROUPS_B — The base (language-independent) table, joined on ITEM_CATALOG_GROUP_ID via the documented foreign key.
• MTL_ITEM_CATALOG_GROUPS_VL / _V — The translated views that join base and TL tables for the current language.
• MTL_ITEM_CATALOG_GROUPS — The synonym commonly referenced in DML and reports.
• MTL_ITEM_CATALOG_GROUPS_TL_PK and _U1 — Primary key and unique index constraints enforcing identity and uniqueness.
• FND_LANGUAGES — Reference table for validating the LANGUAGE and SOURCE_LANG values.
• Item Catalog descriptive flexfields and INVIDITM APIs — Application-tier consumers that resolve catalog group descriptions through this translation table.