Search Results mtl_category_sets_tl




Overview
Explore in AI Chat

Overview

The MTL_CATEGORY_SETS_TL table is a core data object within the Oracle E-Business Suite (EBS) Inventory (INV) module. It functions as a translation table, storing the multilingual, user-facing text for Category Sets. A Category Set is a critical grouping mechanism that defines a specific collection of item categories for a particular business purpose, such as reporting, costing, or planning. While the structural and control attributes of a Category Set are stored in the base table MTL_CATEGORY_SETS_B, this table (MTL_CATEGORY_SETS_TL) holds the translated Name and Description for each set, enabling the application's user interface and reports to display these labels in the language of the user's session. Its role is essential for supporting global deployments of Oracle EBS where multiple languages are required.

Key Information Stored

The table's primary purpose is to maintain language-specific translations for Category Set attributes. Its key columns, as indicated by its primary key and description, include:

  • CATEGORY_SET_ID: The unique identifier for the Category Set. This column links each translation row back to its corresponding master record in the MTL_CATEGORY_SETS_B table.
  • LANGUAGE: The language code (e.g., 'US' for American English, 'F' for French) for which the translated text is applicable.
  • CATEGORY_SET_NAME: The translated name of the Category Set as it appears in lists and forms (e.g., "Inventory", "Purchasing", "Costing").
  • DESCRIPTION: The translated descriptive text that provides further detail about the purpose and usage of the Category Set.
  • Standard Oracle translation table columns such as SOURCE_LANG, CREATION_DATE, and LAST_UPDATE_DATE are also present to manage the translation lifecycle.

Common Use Cases and Queries

A primary use case is generating user-friendly reports or building list of values (LOV) queries that respect the user's session language. For example, an application form displaying a picklist of available Category Sets will join to this table to retrieve the correctly translated NAME. A common reporting query to list all Category Sets with their descriptions in the current session language would resemble:

  • SELECT cs.CATEGORY_SET_NAME, cs.DESCRIPTION FROM MTL_CATEGORY_SETS_TL cs WHERE cs.LANGUAGE = USERENV('LANG');

Another critical scenario involves data migration or setup scripts, where it is necessary to populate translations for a newly created Category Set across multiple installed languages, ensuring the setup is complete for all global users.

Related Objects

MTL_CATEGORY_SETS_TL has a direct and fundamental relationship with its base table, as documented in the provided metadata. The key related objects are:

  • MTL_CATEGORY_SETS_B: This is the base table containing the non-translatable attributes and control data for Category Sets. The documented foreign key relationship states that MTL_CATEGORY_SETS_TL.CATEGORY_SET_ID references MTL_CATEGORY_SETS_B. A standard join for querying complete Category Set information is: SELECT b.*, tl.CATEGORY_SET_NAME, tl.DESCRIPTION FROM MTL_CATEGORY_SETS_B b, MTL_CATEGORY_SETS_TL tl WHERE b.CATEGORY_SET_ID = tl.CATEGORY_SET_ID AND tl.LANGUAGE = USERENV('LANG').
  • MTL_CATEGORIES_TL: While not directly linked via a documented foreign key in the provided metadata, this is a related translation table for the individual Categories that are assigned to the Category Sets defined here, forming a complete translated hierarchy for item classification.