Search Results ecx_xref_dtl_tl




Overview
Explore in AI Chat

Overview

The ECX_XREF_DTL_TL table is a core translation table within the XML Gateway (ECX) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary role is to store translated, language-specific descriptions for cross-reference detail records. In the context of XML Gateway, cross-referencing is a critical function that maps internal EBS identifiers (e.g., item codes, transaction types) to external trading partner identifiers and vice-versa, enabling seamless B2B integration. This table supports the multilingual capabilities of the EBS suite by allowing these mapping descriptions to be presented in the language of the user, which is essential for global deployments.

Key Information Stored

The table stores translated text for descriptive fields associated with cross-reference detail entries. Based on its documented primary key structure, the table's critical columns include:

  • XREF_DTL_ID: The foreign key that uniquely identifies the master cross-reference detail record for which a translation is provided. This links to the base table ECX_XREF_DTLS.
  • LANGUAGE: The language code (e.g., 'US' for American English, 'KO' for Korean) specifying the language of the translated text.
  • DESCRIPTION (implied by the table's nature as a "_TL" table): This column, while not explicitly listed in the brief metadata, is standard for Translation tables. It holds the translated, user-facing description for the cross-reference detail record in the specified language.

The combination of XREF_DTL_ID and LANGUAGE forms the table's primary key (ECX_XREF_DTL_TL_PK), ensuring only one translation per language exists for a given detail record.

Common Use Cases and Queries

This table is primarily accessed by the application's user interface to display translated descriptions of trading partner mappings. A common reporting use case is to generate a list of all cross-reference details with their descriptions in a specific language for audit or setup verification. A typical query would join this table to its master table, ECX_XREF_DTLS, and potentially to the header table, ECX_XREFS_HEADER.

SELECT xd.xref_dtl_id,
       xt.description AS translated_description,
       xd.internal_value,
       xd.external_value
FROM   ecx_xref_dtls xd,
       ecx_xref_dtl_tl xt
WHERE  xd.xref_dtl_id = xt.xref_dtl_id
AND    xt.language = USERENV('LANG')
AND    xd.xref_header_id = :header_id;

This pattern ensures that users see mapping descriptions in their session language. The table is maintained automatically by EBS translation tools and seed data loaders.

Related Objects

ECX_XREF_DTL_TL has a direct and dependent relationship with the base table ECX_XREF_DTLS. The documented primary key indicates that XREF_DTL_ID is a foreign key referencing the primary key of ECX_XREF_DTLS. This establishes a one-to-many relationship where a single detail record in ECX_XREF_DTLS can have multiple translated descriptions in ECX_XREF_DTL_TL (one for each language). The translation table is part of a larger hierarchy for cross-referencing, which typically includes:

  • ECX_XREFS_HEADER: The master header defining the cross-reference map.
  • ECX_XREF_DTLS: The detail records containing the actual internal-to-external value mappings. ECX_XREF_DTL_TL is a child of this table.

Applications and APIs that retrieve cross-reference data for UI presentation will inherently query this translation table when a non-base language session is active.