Search Results xdp_adapter_type_attrs_tl




Overview
Explore in AI Chat

Overview

The XDP_ADAPTER_TYPE_ATTRS_TL table is a core data object within the Oracle E-Business Suite Provisioning (XDP) module. It functions as a translation table, specifically designed to store language-specific, translatable text for adapter-type attributes. In the context of Oracle Provisioning, adapters are software components that interface with external systems, and their types have configurable attributes. This table enables the multilingual display of attribute names and descriptions, ensuring that the Provisioning interface can present localized content to users based on their session language settings. Its role is critical for the international deployment and usability of the Provisioning module in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's primary purpose is to hold translated strings. Its structure is characteristic of Oracle EBS translation tables, centering on a key identifier and a language column. The most significant columns include ADAPTER_TYPE_ATTRS_ID, which is the primary key and serves as the foreign key link to the base table (XDP_ADAPTER_TYPE_ATTRS_B) that stores the non-translatable attribute data. The LANGUAGE column holds the language code (e.g., 'US' for American English), and the SOURCE_LANG column indicates the original language of the record. The core translatable content is stored in columns such as DISPLAY_NAME and DESCRIPTION, which contain the localized text for the attribute's label and explanatory text, respectively.

Common Use Cases and Queries

The primary use case is retrieving localized attribute metadata for user interfaces or integration points within the Provisioning module. A typical query involves joining this table with its base table and filtering by the desired language. For example, to fetch all display names for adapter-type attributes in a specific language for reporting or auditing purposes, one might use:

  • SELECT b.ATTR_NAME, tl.DISPLAY_NAME, tl.DESCRIPTION
  • FROM xdp_adapter_type_attrs_b b,
  • xdp_adapter_type_attrs_tl tl
  • WHERE b.adapter_type_attrs_id = tl.adapter_type_attrs_id
  • AND tl.language = USERENV('LANG');

Another common scenario is during implementation or upgrade, where data scripts may populate this table with new translations for custom adapter attributes to support additional languages.

Related Objects

This table has a direct and dependent relationship with its corresponding base table. As documented in the provided metadata:

  • Primary Key: XDP_ADAPTER_TYPE_ATTRS_TL_PK on column ADAPTER_TYPE_ATTRS_ID.
  • Foreign Key Relationship: The table XDP_ADAPTER_TYPE_ATTRS_TL references the table XDP_ADAPTER_TYPE_ATTRS_B. The join is made on the column XDP_ADAPTER_TYPE_ATTRS_TL.ADAPTER_TYPE_ATTRS_ID, which points to the primary key of the base table. This is a classic EBS architecture pattern where the '_B' table holds the base, non-translatable data, and the '_TL' table holds the language-specific translations.