Search Results hz_per_profiles_ext_tl_pk

Overview

The HZ_PER_PROFILES_EXT_TL table is a core data object within the Oracle E-Business Suite (EBS) Trading Community Architecture (TCA) and Receivables (AR) modules. Its primary function is to provide multilingual support for extensible attributes associated with person profiles. In EBS 12.1.1 and 12.2.2, the TCA model allows for the extension of standard person attributes to capture additional, organization-specific information. This table stores the translated text for those extended attributes, enabling the application to present them in the language specified by the user's session or application setup. It is a critical component for global deployments where data must be maintained and displayed in multiple languages.

Key Information Stored

The table's structure is designed to support the translation model. Its primary key is a composite of the EXTENSION_ID and LANGUAGE columns, ensuring a unique entry for each attribute translation. The EXTENSION_ID links to the specific extensible attribute instance. The LANGUAGE column, which references the FND_LANGUAGES table, stores the language code (e.g., 'US' for American English, 'KO' for Korean) for the translated text. A key foreign key, PERSON_PROFILE_ID, establishes the relationship to the base person profile in the HZ_PERSON_PROFILES table. The table typically contains columns for the translated display name and possibly descriptive text of the extended attribute, allowing for a fully localized user experience.

Common Use Cases and Queries

A primary use case is generating person profile reports or building interfaces that must display extended attribute labels in a user's native language. For instance, a global customer service screen would query this table to fetch the appropriate translated labels based on the user's session language. Common SQL patterns involve joining to the base extension table and the language table. A typical query to retrieve translated attributes for a specific person profile would be:

• SELECT tl.display_name, tl.description
• FROM hz_per_profiles_ext_tl tl,
• hz_person_profiles pp
• WHERE tl.person_profile_id = pp.person_profile_id
• AND tl.language = USERENV('LANG')
• AND pp.party_id = :p_party_id;

Data migration and synchronization scripts for multilingual data also frequently interact with this table to populate or update translated content.

Related Objects

The table has defined relationships with several key EBS foundation and TCA objects, as documented in the provided metadata. Its foreign keys establish critical data integrity links.

• HZ_PERSON_PROFILES: This is the primary parent table. The foreign key column HZ_PER_PROFILES_EXT_TL.PERSON_PROFILE_ID references HZ_PERSON_PROFILES, tying each set of translated attributes to a specific base person profile record.
• FND_LANGUAGES: The foreign key column HZ_PER_PROFILES_EXT_TL.LANGUAGE references FND_LANGUAGES. This ensures that only valid, installed application languages are used for storing translations.
• HZ_PER_PROFILES_EXT_TL_PK: The primary key constraint (on EXTENSION_ID, LANGUAGE) is the anchor for these relationships and ensures data uniqueness.