Search Results xdp_proc_body_tl




Overview
Explore in AI Chat

Overview

The XDP_PROC_BODY_TL table is a core component of the Oracle E-Business Suite Provisioning (XDP) module, specifically designed to support Multi-Language Support (MLS) or translation capabilities. It functions as the language-specific counterpart to the base XDP_PROC_BODY table. In the context of Oracle EBS 12.1.1 and 12.2.2, this table enables the storage of translated textual descriptions for provisioning process bodies, ensuring that the application can present user-facing content in multiple languages based on the user's session settings. Its existence is critical for global deployments of Oracle EBS where multilingual support is a requirement.

Key Information Stored

The table stores translated attributes for provisioning process bodies. Its structure is defined by a composite primary key that uniquely identifies each translated record. The most critical columns are:

  • PROC_NAME: The unique identifier for the provisioning process body. This column forms a foreign key relationship to the XDP_PROC_BODY table, linking the translation to its base definition.
  • LANGUAGE: The language code (e.g., 'US' for American English, 'KO' for Korean) for the translated text. Combined with PROC_NAME, it forms the table's primary key.
  • SOURCE_LANG: A standard column in Oracle EBS TL tables that indicates the language in which the data was originally entered.
  • Translated descriptive columns, which typically include fields such as DESCRIPTION or DISPLAY_NAME, holding the user-facing text in the specified language.

Common Use Cases and Queries

This table is primarily accessed by the application's MLS engine to retrieve locale-specific text. A common operational query involves joining the base and translation tables to get a process body's description for the current session language. For example, to retrieve all process body descriptions in American English, a developer might use: 

SELECT b.PROC_NAME, t.DESCRIPTION
FROM XDP_PROC_BODY b,
     XDP_PROC_BODY_TL t
WHERE b.PROC_NAME = t.PROC_NAME
  AND t.LANGUAGE = userenv('LANG')
  AND t.SOURCE_LANG = userenv('LANG');

Reporting use cases include generating audits of translation completeness or identifying processes missing descriptions in specific languages. Administrators may also query this table directly to troubleshoot or verify translated content during implementation or upgrade projects.

Related Objects

The table has defined relationships with other key objects in the XDP schema, as documented in the ETRM metadata. The primary relationships are:

  • Primary Key: XDP_PROC_BODY_TL_PK on columns (PROC_NAME, LANGUAGE).
  • Foreign Key (References): The table has a foreign key constraint where XDP_PROC_BODY_TL.PROC_NAME references the XDP_PROC_BODY table. This enforces referential integrity, ensuring every translated record corresponds to a valid base process body definition.

As a TL table, it is intrinsically linked to its base table, XDP_PROC_BODY. Any application logic or API that retrieves or maintains process body descriptions will interact with this pair of tables. The data is typically accessed via views that automatically handle language filtering.

  • Table: XDP_PROC_BODY_TL 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_PROC_BODY_TL,  object_name:XDP_PROC_BODY_TL,  status:VALID,  product: XDP - Provisioning ,  description: XDP_PROC_BODY_TL is the MLS (Multi-Language Support) table for the XDP_PROC_BODY table ,  implementation_dba_data: XDP.XDP_PROC_BODY_TL , 

  • Table: XDP_PROC_BODY_TL 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_PROC_BODY_TL,  object_name:XDP_PROC_BODY_TL,  status:VALID,  product: XDP - Provisioning ,  description: XDP_PROC_BODY_TL is the MLS (Multi-Language Support) table for the XDP_PROC_BODY table ,  implementation_dba_data: XDP.XDP_PROC_BODY_TL , 

  • View: XDP_PROC_BODY_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_PROC_BODY_VL,  object_name:XDP_PROC_BODY_VL,  status:VALID,  product: XDP - Provisioning ,  description: This View shows all the User defined Procedures in SFM ,  implementation_dba_data: APPS.XDP_PROC_BODY_VL , 

  • View: XDP_PROC_BODY_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_PROC_BODY_VL,  object_name:XDP_PROC_BODY_VL,  status:VALID,  product: XDP - Provisioning ,  description: This View shows all the User defined Procedures in SFM ,  implementation_dba_data: APPS.XDP_PROC_BODY_VL , 

  • Table: XDP_PROC_BODY 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_PROC_BODY,  object_name:XDP_PROC_BODY,  status:VALID,  product: XDP - Provisioning ,  description: XDP_PROC_BODY stores the source of all the user defined procedures ,  implementation_dba_data: XDP.XDP_PROC_BODY , 

  • Table: XDP_PROC_BODY 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_PROC_BODY,  object_name:XDP_PROC_BODY,  status:VALID,  product: XDP - Provisioning ,  description: XDP_PROC_BODY stores the source of all the user defined procedures ,  implementation_dba_data: XDP.XDP_PROC_BODY ,