Search Results xdp_service_packages_tl




Overview
Explore in AI Chat

Overview

The XDP_SERVICE_PACKAGES_TL table is a Translation (TL) table within the Oracle E-Business Suite Provisioning (XDP) module. Its primary function is to store translated, language-specific descriptions for service package entities defined in its base table, XDP_SERVICE_PACKAGES. This design supports the multi-language capabilities of Oracle EBS, allowing the provisioning system to present package information in a user's preferred language. While the provided ETRM documentation states "Not used," this is a common placeholder and does not negate the table's structural role in the application's internationalization framework. The table's existence is integral to the data model, ensuring referential integrity for translated content across supported languages in releases 12.1.1 and 12.2.2.

Key Information Stored

The table stores translated textual attributes for service packages. Its structure is characteristic of Oracle EBS translation tables, combining a source record identifier with a language code. The primary key is a composite of PACKAGE_ID and LANGUAGE. The PACKAGE_ID column is a foreign key that links directly to the XDP_SERVICE_PACKAGES base table, identifying the specific service package. The LANGUAGE column holds the ISO language code (e.g., 'US' for American English, 'KO' for Korean) specifying the translation locale. While the specific translated column names are not detailed in the provided excerpt, typical TL tables in EBS contain columns such as PACKAGE_NAME, DESCRIPTION, or SOURCE_LANG. These columns hold the translated text corresponding to the language code for each PACKAGE_ID.

Common Use Cases and Queries

The primary use case is retrieving service package information in a user's session language for UI display, reports, and integration outputs. Application logic automatically queries this table based on the session's NLS_LANGUAGE setting. A common reporting query involves joining the base and translation tables to get a complete, language-specific view. For example, to retrieve all package names and descriptions in American English, one might use:

  • SELECT B.PACKAGE_ID, T.PACKAGE_NAME, T.DESCRIPTION
  • FROM XDP_SERVICE_PACKAGES B, XDP_SERVICE_PACKAGES_TL T
  • WHERE B.PACKAGE_ID = T.PACKAGE_ID
  • AND T.LANGUAGE = USERENV('LANG');

Data maintenance for this table is typically performed via the application's translation forms or underlying APIs, not via direct DML, to preserve integrity with the base table and seed data.

Related Objects

The table has a direct and fundamental relationship with its base table, XDP_SERVICE_PACKAGES, enforced by a foreign key constraint on the PACKAGE_ID column. This defines a strict master-detail relationship where a record in the TL table cannot exist without a corresponding record in the base table. As a translation table, it is also intrinsically linked to the application's language and translation infrastructure (FND_LANGUAGES). While not explicitly listed, it is common for database views to be built upon this table and its base table to simplify querying translated data. Any application screens, reports, or interfaces within the XDP module that display service package descriptions in a multi-lingual context will ultimately depend on the data stored in XDP_SERVICE_PACKAGES_TL.