Search Results hz_org_profiles_ext_tl_pk

Overview

The HZ_ORG_PROFILES_EXT_TL table is a core data object within the Oracle E-Business Suite (EBS) Receivables (AR) module. It is a translation table that provides multilingual support for extensible attributes associated with organization profiles. In the context of Oracle EBS 12.1.1 and 12.2.2, this table enables the storage of user-defined descriptive flexfield (DFF) attribute values in multiple languages, a critical feature for global implementations. Its primary role is to support the localization and translation of custom organization data captured through the Trading Community Architecture (TCA) extensibility framework, ensuring that organization-specific information is accessible and accurate across different language environments.

Key Information Stored

The table stores translated text for extensible attributes linked to an organization profile. Its structure is defined by a composite primary key and foreign key relationships that enforce data integrity. The most critical columns include:

• EXTENSION_ID: The unique identifier for a specific extensible attribute record. Part of the primary key (HZ_ORG_PROFILES_EXT_TL_PK).
• LANGUAGE: The language code (e.g., 'US', 'F', 'D') for the translated text. Part of the primary key and a foreign key to FND_LANGUAGES.
• ORGANIZATION_PROFILE_ID: The foreign key linking the translation to a specific organization profile in the HZ_ORGANIZATION_PROFILES table.
• Translated Attribute Columns: While the specific column names are defined by the DFF context, this table typically holds the translated values for the VARCHAR2-type descriptive flexfield segments associated with the organization profile extension.

Common Use Cases and Queries

A primary use case is generating multilingual reports or user interfaces that display custom organization attributes. For instance, a report showing a custom "Local Business Identifier" for organizations in both English and French would require a join to this table. A common SQL pattern involves joining the base extension table with its translation table, filtered by the user's session language.

SELECT hp.party_name,
       ext.attribute1, -- Base language value
       tle.attribute1  -- Translated value
FROM   hz_organization_profiles hp,
       hz_org_profiles_ext ext,
       hz_org_profiles_ext_tl tle
WHERE  hp.organization_profile_id = ext.organization_profile_id
AND    ext.extension_id = tle.extension_id
AND    tle.language = USERENV('LANG')
AND    hp.party_id = :p_party_id;

Data maintenance scripts for populating or updating translations for a set of organizations would also directly interact with this table, using the EXTENSION_ID and LANGUAGE keys.

Related Objects

The table has defined relationships with other core EBS objects, as documented in the ETRM metadata:

• HZ_ORGANIZATION_PROFILES: The parent table for organization profile information. The foreign key HZ_ORG_PROFILES_EXT_TL.ORGANIZATION_PROFILE_ID references this table to ensure each translation is tied to a valid profile.
• FND_LANGUAGES: The reference table for installed languages in the EBS instance. The foreign key HZ_ORG_PROFILES_EXT_TL.LANGUAGE references this table to validate the language code.
• HZ_ORG_PROFILES_EXT (implied): While not explicitly listed in the provided foreign keys, the translation table is intrinsically linked to the base extension table (HZ_ORG_PROFILES_EXT) via the shared EXTENSION_ID primary key. The base table holds the seed language values for the extensible attributes.