Results for “organization_profile_id”

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

Overview

HZ_ORG_PROFILES_EXT_TL is a translation (TL) table in the Oracle E-Business Suite Receivables (AR) schema that provides multilingual support for extensible organization attributes. It stores language-specific values for user-defined descriptive flexfield attributes associated with organization profiles, enabling the same organization profile record to display different attribute text depending on the session language of the user.

The table is owned by the AR schema, holds VALID status in EBS 12.1.1 and 12.2.2, and contains 30 documented columns in the ETRM 12.2.2 physical schema. Its design follows the standard Oracle EBS multilingual pattern: the base (non-translated) values reside in HZ_ORG_PROFILES_EXT, while HZ_ORG_PROFILES_EXT_TL carries the translated string values keyed by language. The SOURCE_LANG and LANGUAGE columns follow the FND_LANGUAGES convention used throughout the applications.

Based on the foreign-key structure mined from the schema, the heuristic Data Vault classification for this object is a link table. It connects an organization profile extensibility record to a specific language, functioning as a bridge between the base organization profile entity and the FND_LANGUAGES reference data while holding the translated attribute payload. This is offered as a modeling suggestion only; the table is a standard EBS translated child table, not a formally modeled Data Vault construct.

Key Information Stored

• EXTENSION_ID — Surrogate identifier for the extensible attribute record; part of the composite primary key HZ_ORG_PROFILES_EXT_TL_PK.
• LANGUAGE — The language code for the row; the second component of the primary key and a foreign key to FND_LANGUAGES.
• ORGANIZATION_PROFILE_ID — Foreign key to HZ_ORGANIZATION_PROFILES, identifying the parent organization profile that owns the extensible attributes.
• ATTR_GROUP_ID — Identifies the attribute group (flexfield context or grouping) to which the extensible attributes belong.
• SOURCE_LANG — The source language of the record, used in the translation framework to indicate the originating language.
• TL_EXT_ATTR1 through TL_EXT_ATTR20 — Twenty translated extensible attribute columns holding multilingual descriptive flexfield values. These are the translated counterparts to the base attribute columns on HZ_ORG_PROFILES_EXT.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS who-audit columns recording row creation and change history.

The documented primary key is HZ_ORG_PROFILES_EXT_TL_PK on (EXTENSION_ID, LANGUAGE). A unique index HZ_ORG_PROFILES_EXT_TL_U1 on the same (EXTENSION_ID, LANGUAGE) pair serves as the business-key candidate, enforcing one translated row per extension record per language.

Common Use Cases and Queries

This table is queried primarily to retrieve organization profile extensible attributes in the user's current language, and to audit translation completeness across installed languages.

Retrieve translated attributes for a profile in the current session language:

• SELECT t.extension_id, t.organization_profile_id, t.attr_group_id, t.tl_ext_attr1, t.tl_ext_attr2 FROM hz_org_profiles_ext_tl t WHERE t.organization_profile_id = :profile_id AND t.language = userenv('LANG');

Identify extension records missing a translation for a target language:

• SELECT e.extension_id, t.language FROM hz_org_profiles_ext e LEFT JOIN hz_org_profiles_ext_tl t ON t.extension_id = e.extension_id AND t.language = 'FR' WHERE t.extension_id IS NULL;

Report all translations for a profile's attributes:

• SELECT t.language, t.source_lang, t.tl_ext_attr1 FROM hz_org_profiles_ext_tl t WHERE t.organization_profile_id = :profile_id ORDER BY t.language;

Typical reporting scenarios include multilingual customer and supplier profile reporting, translation gap analysis across supported languages, and attribute-level auditing where descriptive flexfield text must be validated against language standards.

Related Objects

• HZ_ORGANIZATION_PROFILES — Parent entity; joined via HZ_ORG_PROFILES_EXT_TL.ORGANIZATION_PROFILE_ID = HZ_ORGANIZATION_PROFILES.ORGANIZATION_PROFILE_ID.
• HZ_ORG_PROFILES_EXT — Base (non-translated) extensible attribute table supplying the parent EXTENSION_ID and untranslated attribute values.
• FND_LANGUAGES — Reference table for supported language codes; joined via HZ_ORG_PROFILES_EXT_TL.LANGUAGE = FND_LANGUAGES.LANGUAGE_CODE.
• HZ_ORG_PROFILES_EXT_TL_PK / HZ_ORG_PROFILES_EXT_TL_U1 — Primary key constraint and unique index enforcing uniqueness on (EXTENSION_ID, LANGUAGE).