Search Results xla_mapping_sets_tl




Overview
Explore in AI Chat

Overview

XLA_MAPPING_SETS_TL is the translation table within the Oracle Subledger Accounting (XLA) schema that stores the language-dependent, descriptive attributes of mapping sets. A mapping set in Subledger Accounting defines an ordered collection of account derivation rules and mapping rules that together determine how a subledger transaction's accounting attributes are transformed into a final account combination. Where the base table XLA_MAPPING_SETS_B holds the language-independent, operational definition of each mapping set, this _TL companion stores the human-readable name and description for each installed language, enabling multilingual presentation of the same underlying definition.

The object resides in the XLA schema and carries VALID status in both Oracle EBS 12.1.1 and 12.2.2. ETRM's heuristic data vault classification flags this object as standalone, meaning it is not mined as a dependent satellite or link through foreign key structure. From a modeling perspective, the base configuration row can be treated as a hub-like entity keyed by the mapping set identifier, while this translation table behaves as a language-specific descriptive satellite attached to it. The heuristic should be read as a suggestion rather than a mandated warehouse design.

Key Information Stored

The table contains twelve documented columns. Its surrogate primary key is defined by XLA_MAPPING_SETS_TL_PK, composed of MAPPING_SET_CODE and LANGUAGE. Business-key candidates are captured through unique indexes. The most significant columns are:

  • MAPPING_SET_CODE — The identifier linking the translated row to its parent mapping set definition; part of the primary key.
  • LANGUAGE — The language code for the translated row; part of the primary key and the discriminator for multilingual retrieval.
  • NAME — The translated display name of the mapping set, exposed through unique index XLA_MAPPING_SETS_TL_U2 (AMB_CONTEXT_CODE, NAME, LANGUAGE, ZD_EDITION_NAME).
  • DESCRIPTION — The translated long description of the mapping set's purpose.
  • SOURCE_LANG — The language from which the translation was derived, used to track translation provenance.
  • AMB_CONTEXT_CODE — The application message context that scopes the mapping set; a business-key component in both XLA_MAPPING_SETS_TL_U1 and XLA_MAPPING_SETS_TL_U2.
  • ZD_EDITION_NAME — The edition identifier used for edition-based redefinition and upgrade compatibility; included in both unique indexes.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle who-columns providing audit and concurrency metadata.

The business-key candidate XLA_MAPPING_SETS_TL_U1 is composed of AMB_CONTEXT_CODE, MAPPING_SET_CODE, LANGUAGE, and ZD_EDITION_NAME, confirming the natural multi-attribute identity that governs uniqueness.

Common Use Cases and Queries

Reporting against mapping sets typically joins the translation table to the base table on MAPPING_SET_CODE, filtering by the user's session language. A representative pattern is:

  • SELECT b.mapping_set_code, t.name, t.description FROM xla_mapping_sets_b b, xla_mapping_sets_tl t WHERE b.mapping_set_code = t.mapping_set_code AND t.language = USERENV('LANG')
  • Filtering by AMB_CONTEXT_CODE to isolate mapping sets belonging to a specific application or context.
  • Auditing translation coverage by comparing row counts between the base and translated tables to detect mapping sets lacking a translation in a target language.
  • Extract-transformation-load routines that load translated reference data into a reporting warehouse, keyed on MAPPING_SET_CODE and LANGUAGE.

Related Objects

  • XLA_MAPPING_SETS_B — The base table holding language-independent mapping set attributes; join on MAPPING_SET_CODE.
  • XLA_MAPPING_SETS_VL — The translated view exposing the joined base and _TL columns for end-user queries.
  • XLA_MAPPINGS and XLA_MAPPINGS_TL — The mapping rules that reference the containing mapping set.
  • XLA_ACCOUNTING_RULES — Account derivation rules that employ mapping sets.
  • FND_LANGUAGES — Language reference table; join on LANGUAGE.
  • XLA_AMB_CONTEXTS — Context registry for AMB_CONTEXT_CODE.