Search Results mtl_categories_tl




Overview
Explore in AI Chat

Overview

The MTL_CATEGORIES_TL table is a core data object within the Oracle E-Business Suite (EBS) Inventory (INV) module. It functions as the translation table for item categories, storing language-specific descriptions for category names. This table is integral to the EBS Multi-Org and Multi-Language architecture, enabling a single installation to support multiple languages by separating the static, language-independent category data (stored in MTL_CATEGORIES_B) from the translatable text. Its primary role is to provide the appropriate category description to users based on their session language, which is critical for global operations, reporting, and data entry within inventory, order management, and procurement flows.

Key Information Stored

The table's structure is designed to manage translated text linked to a base category identifier. Its most critical columns include:

  • CATEGORY_ID: The unique identifier linking each row to its corresponding base category record in the MTL_CATEGORIES_B table. This column is part of the table's primary key.
  • LANGUAGE: The language code (e.g., 'US' for American English) for the translated description. This column completes the primary key, ensuring only one translation exists per category per language.
  • DESCRIPTION: The translated, user-facing name of the item category in the specified language. This is the primary data element stored in this table.
  • Standard Translation table columns such as SOURCE_LANG, which records the original language of the record, and CREATION_DATE, CREATED_BY.

Common Use Cases and Queries

This table is primarily accessed indirectly via the view MTL_CATEGORIES_V, which joins MTL_CATEGORIES_B and MTL_CATEGORIES_TL based on the user's session language. Common use cases include generating multi-language reports, validating category descriptions in data migration scripts, and troubleshooting display issues in forms. A typical query to retrieve category information for a specific language would be:

  • SELECT mc_tl.category_id, mc_tl.description, mc_tl.language FROM inv.mtl_categories_tl mc_tl WHERE mc_tl.language = 'DE';

For development or data fixes, a standard pattern is to update a translation for a specific category and language:

  • UPDATE inv.mtl_categories_tl SET description = 'Neue Beschreibung', last_update_date = SYSDATE WHERE category_id = 1000 AND language = 'DE';

Related Objects

MTL_CATEGORIES_TL has a fundamental relationship with several key Inventory objects, as indicated by its foreign key constraint.

  • MTL_CATEGORIES_B: This is the base table containing the non-translatable category attributes. The foreign key from MTL_CATEGORIES_TL.CATEGORY_ID to MTL_CATEGORIES_B ensures referential integrity.
  • MTL_CATEGORIES_V: This is the primary view used by applications and reports. It performs an outer join between MTL_CATEGORIES_B and MTL_CATEGORIES_TL, filtered by the user's session language (USERENV('LANG')).
  • MTL_ITEM_CATEGORIES: This table assigns items to specific categories, which are defined in MTL_CATEGORIES_B and described in MTL_CATEGORIES_TL.
  • FND_LANGUAGES: While not a direct foreign key, the LANGUAGE column conceptually relates to the languages defined in this application dictionary table.