Search Results mtl_cross_references_tl




Overview
Explore in AI Chat

Overview

MTL_CROSS_REFERENCES_TL is a translation (TL) table within the Oracle Inventory (INV) product schema, responsible for storing the language-specific translated values of the Description column belonging to the base cross-reference entity. In Oracle EBS 12.1.1 and 12.2.2, cross-references establish relationships between a given inventory item and an alternate identifier used by a customer, supplier, manufacturer, or internal system, such as an OEM part number, customer item number, or competitor part number. The base transactional data for those relationships is held in MTL_CROSS_REFERENCES_B, while MTL_CROSS_REFERENCES_TL carries the multilingual descriptive text that accompanies each cross-reference record, one row per installed language.

The object is documented in the ETRM repository with the owner INV, status VALID, and is classified as a standalone entity under the heuristic Data Vault analysis (mined from the foreign-key structure). This classification is a modeling suggestion rather than a physical constraint; it implies the table is treated as an independent descriptive satellite rather than a link between two hubs within a Data Vault representation.

Key Information Stored

The table contains nine documented columns. The most significant are summarized below, distinguishing the surrogate primary key from business-key candidates.

  • CROSS_REFERENCE_ID — Surrogate identifier linking each translation row back to its parent cross-reference record in MTL_CROSS_REFERENCES_B. It is part of the primary key.
  • LANGUAGE — The NLS language code for the translated text. Together with CROSS_REFERENCE_ID it forms the primary key.
  • SOURCE_LANG — Indicates the source language of the stored translation, used by the Oracle Translation (TL) framework to support language derivation.
  • DESCRIPTION — The translated description text of the cross-reference. This is the sole business data column carried by the TL table.
  • CREATION_DATE, CREATED_BY — Standard audit columns capturing when and by whom the row was inserted.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Audit columns recording the most recent modification event and the login context of the updating user.

The primary key is defined by MTL_CROSS_REFERENCES_TL_PK on the composite of (CROSS_REFERENCE_ID, LANGUAGE). A unique index, MTL_CROSS_REFERENCES_TL_U1, is documented on the identical column pair, confirming that no more than one translation row may exist per cross-reference per language.

Common Use Cases and Queries

The primary reporting use case is retrieving a localized cross-reference description for a given item and alternate identifier. A typical query joins the TL table to its base table while constraining on the session language, using the NLS convenience view rather than the TL table directly. For example, selecting item, cross-reference type, and translated description by joining MTL_CROSS_REFERENCES_B to MTL_CROSS_REFERENCES_TL on CROSS_REFERENCE_ID and filtering LANGUAGE for the desired locale. In practice, developers often query the MTL_CROSS_REFERENCES_VL view, which performs this join transparently and returns the appropriate translation for the runtime session.

Additional scenarios include multilingual item catalogs, customer-facing documentation that must present cross-reference descriptions in the user's language, and data-quality audits that verify a translation row exists for each required language. A common integrity check counts cross-reference records lacking a description in a target language, joining the base and TL tables on CROSS_REFERENCE_ID and testing LANGUAGE against the desired code.

Related Objects

  • MTL_CROSS_REFERENCES_B — The base table holding transactional cross-reference data. Joined on CROSS_REFERENCE_ID.
  • MTL_CROSS_REFERENCES_VL — The NLS view that merges base and TL rows, providing language-aware access.
  • MTL_CROSS_REFERENCES_V — Legacy view for cross-reference inquiry.
  • MTL_SYSTEM_ITEMS_B — Inventory item master referenced by cross-reference rows via INVENTORY_ITEM_ID.
  • MTL_CROSS_REFERENCE_TYPES — Defines the cross-reference type (customer, supplier, manufacturer) assigned to each record.
  • FND_LANGUAGES — Provides the valid LANGUAGE codes used in the TL table.
  • MTL_CROSS_REFERENCES_PKG / Public APIs — Inventory APIs that insert and maintain cross-reference records, cascading writes to the TL table.