Search Results mtl_system_items_tl_pk

Overview

The MTL_SYSTEM_ITEMS_TL table is a core translation table within the Oracle E-Business Suite Inventory (INV) module. It is a companion table to the base item definition table, MTL_SYSTEM_ITEMS_B. Its primary role is to support the multilingual capabilities of the application by storing translated text for item descriptions and other translatable attributes. This structure allows a single inventory item, defined by its INVENTORY_ITEM_ID and ORGANIZATION_ID in the base table, to be presented with language-specific descriptions to users in different global locales, a critical requirement for multinational deployments of EBS 12.1.1 and 12.2.2.

Key Information Stored

The table stores language-specific translations for items. Its structure is defined by a composite primary key and translatable columns. The primary key, MTL_SYSTEM_ITEMS_TL_PK, consists of INVENTORY_ITEM_ID, ORGANIZATION_ID, and LANGUAGE. This ensures a unique translation record per item, per organization, per language. The LANGUAGE column holds the language code (e.g., 'US' for American English, 'D' for German). The most critical translatable column is DESCRIPTION, which holds the item description in the specified language. Other columns may exist for additional translatable attributes, but the description is the most commonly utilized. The table also includes standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing.

Common Use Cases and Queries

A primary use case is generating reports or building user interfaces that display item information in the user's session language. Developers must join this table with MTL_SYSTEM_ITEMS_B to retrieve a complete item record. A standard query pattern is:

• SELECT msib.segment1 item_code, mstl.description, mstl.language
• FROM mtl_system_items_b msib, mtl_system_items_tl mstl
• WHERE msib.inventory_item_id = mstl.inventory_item_id
• AND msib.organization_id = mstl.organization_id
• AND mstl.language = USERENV('LANG');

Another common task is verifying or populating translations for items during data migration or localization projects. Administrators may query for items missing a translation in a target language or compare descriptions across languages. The table is also essential for any custom integration that must serve item data in multiple languages.

Related Objects

The table has a direct and mandatory relationship with the base items table. As per the provided metadata, it has a foreign key relationship with MTL_SYSTEM_ITEMS_B on the columns INVENTORY_ITEM_ID and ORGANIZATION_ID. This enforces referential integrity, ensuring every translation record corresponds to a valid item-organization combination. The primary transactional view for items, MTL_SYSTEM_ITEMS_KFV, typically incorporates logic to select the description from MTL_SYSTEM_ITEMS_TL based on the user's session language. Key APIs, such as the Item Import API and the INV_ITEM_EFF_PKG, interact with this table to create and manage translated item data. The E-Business Suite's standard translation tools, like the Oracle Translation Hub integration, ultimately populate this table.