Search Results xdp_service_wi_map_tl




Overview
Explore in AI Chat

Overview

The XDP_SERVICE_WI_MAP_TL table is a critical component within the Oracle E-Business Suite (EBS) Provisioning (XDP) module, specifically for versions 12.1.1 and 12.2.2. It functions as the Multi-Language Support (MLS) or Translated Language table for its base table, XDP_SERVICE_WI_MAP. Its primary role is to store translated textual content, enabling the provisioning application to present user-facing data, such as descriptions or names, in multiple languages. This design separates language-specific data from the core transactional data, which is stored in the base table, thereby facilitating international deployments and supporting the global capabilities of Oracle EBS.

Key Information Stored

The table's structure is defined by a composite primary key and columns for translated text. The key columns are SERVICE_WI_MAP_ID, which is a foreign key linking directly to a record in the base XDP_SERVICE_WI_MAP table, and LANGUAGE, which identifies the language code (e.g., 'US' for American English) for the translation. The most significant data column is typically DESCRIPTION, which holds the translated text for the corresponding service-to-work-item mapping defined in the base table. Additional columns may include CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY for auditing purposes, following the standard Oracle Applications convention.

Common Use Cases and Queries

The primary use case is retrieving user interface labels and descriptions in the session language of the logged-in user within the Provisioning module. For instance, when a service order triggers a workflow, the system may need to display the mapped work item's description in the user's preferred language. A common query pattern involves joining the base and translation tables while filtering on the language. A typical SQL pattern is:

  • SELECT b.SERVICE_TYPE_CODE, t.DESCRIPTION
  • FROM XDP_SERVICE_WI_MAP b, XDP_SERVICE_WI_MAP_TL t
  • WHERE b.SERVICE_WI_MAP_ID = t.SERVICE_WI_MAP_ID
  • AND t.LANGUAGE = USERENV('LANG');

Reporting use cases include generating lists of service mappings with descriptions for all installed languages for administrative or translation audit purposes.

Related Objects

The table has a direct and fundamental relationship with its base table, as defined by the documented foreign key. The key related objects are:

  • XDP_SERVICE_WI_MAP (Base Table): This is the primary transactional table. The XDP_SERVICE_WI_MAP_TL table references it via the foreign key column SERVICE_WI_MAP_ID (XDP_SERVICE_WI_MAP_TL.SERVICE_WI_MAP_ID → XDP_SERVICE_WI_MAP). Every record in the TL table must correspond to a valid record in this base table.
  • XDP_SERVICE_WI_MAP_TL_PK (Primary Key Constraint): The unique identifier for this table, defined on the columns (SERVICE_WI_MAP_ID, LANGUAGE). This ensures that only one translation exists per language for each base table record.