Results for “xdp_adapter_types_tl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The XDP_ADAPTER_TYPES_TL table is a translation (language-specific) table within the XDP – Provisioning product module of Oracle E-Business Suite. It stores the multilingual display text associated with adapter type definitions maintained in the Oracle EBS provisioning and service activation framework. As a "_TL" table, it follows the standard Oracle Applications multilingual design pattern: language-independent attributes reside in the base table XDP_ADAPTER_TYPES_B, while translatable attributes such as the display name are held in this table, keyed by both the business entity identifier and the LANGUAGE code. The table is owned by the XDP schema and is documented as VALID in both EBS 12.1.1 and 12.2.2.

Under the heuristic Data Vault classification mined from its foreign key structure, this object is satellite-leaning. In Data Vault terms, XDP_ADAPTER_TYPES_B behaves as the hub holding the durable adapter type business key, and XDP_ADAPTER_TYPES_TL acts as a satellite carrying descriptive, language-dependent context for that hub. Modeling exercises that reconstruct the provisioning schema should treat the translation row as dependent descriptive data rather than an independent business entity.

Key Information Stored

The physical schema documents twelve columns. The most operationally significant are:

• ADAPTER_TYPE – The business identifier of the adapter type; part of the composite primary key and the foreign key referencing XDP_ADAPTER_TYPES_B.
• LANGUAGE – The NLS language code for the translation; the second component of the composite primary key.
• SOURCE_LANG – The language from which the current translation was derived, used during the translation maintenance cycle.
• DISPLAY_NAME – The translated, user-facing name of the adapter type, and the principal reason this table exists.
• SECURITY_GROUP_ID – Foreign key to FND_SECURITY_GROUPS, supporting multi-org and data security filtering.
• OBJECT_VERSION_NUMBER – Optimistic locking column used by the Oracle Applications framework to detect concurrent updates.
• ZD_EDITION_NAME – Editioning column supporting Online Patching (adopted in 12.2.x).
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard WHO audit columns present on nearly all Oracle EBS transactional and setup tables.

The surrogate primary key is defined by the constraint XDP_ADAPTER_TYPES_TL_PK on (ADAPTER_TYPE, LANGUAGE). A second unique index, XDP_ADAPTER_TYPES_TL_U1, spans (ADAPTER_TYPE, LANGUAGE, ZD_EDITION_NAME), confirming the composite business key in the editioned 12.2.x model.

Common Use Cases and Queries

Typical usage centers on resolving the human-readable adapter type name for a given session language, and on validating that translations exist for every required language. A representative query joins the base and translation tables:

• SELECT b.adapter_type, t.display_name FROM xdp_adapter_types_b b, xdp_adapter_types_tl t WHERE b.adapter_type = t.adapter_type AND t.language = USERENV('LANG') — returns adapter types in the current user's language.
• SELECT adapter_type, COUNT(*) FROM xdp_adapter_types_tl GROUP BY adapter_type — identifies adapter types missing translations.
• SELECT * FROM xdp_adapter_types_tl WHERE language = 'US' AND display_name LIKE 'SOA%' — supports reporting and diagnostics on a specific language set.

Reporting use cases include translation completeness audits, adapter type inventories for provisioning integration teams, and troubleshooting of adapter selection logic where the displayed name is incorrect.

Related Objects

• XDP_ADAPTER_TYPES_B – Base table; joined on ADAPTER_TYPE. Holds the language-independent adapter type definition.
• FND_SECURITY_GROUPS – Referenced via SECURITY_GROUP_ID for data security.
• FND_LANGUAGES – Supplies the valid LANGUAGE values and NLS metadata (implied reference for translation columns).
• XDP_ADAPTER_TYPES_TL_PK / XDP_ADAPTER_TYPES_TL_U1 – Primary key constraint and unique index enforcing the business key.

These objects together form the canonical pattern for provisioning adapter configuration and translation in Oracle EBS 12.1.1 and 12.2.2.