Results for “hz_per_profiles_ext_tl”

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

Overview

HZ_PER_PROFILES_EXT_TL is a translation (TL) table in the Oracle E-Business Suite Receivables (AR) schema. It provides multilingual support for extensible person attributes defined in the Trading Community Architecture (TCA) person model. In Oracle EBS 12.1.1 and 12.2.2, TCA allows customers to define additional descriptive attributes beyond the seeded columns of the person profile. The base definitions and their default-language values are held in the corresponding base table, HZ_PER_PROFILES_EXT_B, while HZ_PER_PROFILES_EXT_TL stores the translated values of those attribute strings for each installed language.

Because the table's primary key and foreign keys link a language-independent parent to a language lookup, the metadata's heuristic Data Vault classification is link. Under that modeling suggestion, the table functions as an associative structure joining a person-profile extension record to a language, rather than serving as an independent hub of business identity. Each row represents one extension record expressed in one language.

Key Information Stored

The table contains 30 documented columns. The most significant are:

• EXTENSION_ID — Surrogate identifier for the extension record; part of the composite primary key HZ_PER_PROFILES_EXT_TL_PK (EXTENSION_ID, LANGUAGE). It joins back to the base table's extension definition.
• PERSON_PROFILE_ID — Foreign key to HZ_PERSON_PROFILES, identifying the person profile to which the extension attributes belong.
• LANGUAGE — Foreign key to FND_LANGUAGES; the installed language in which the attribute values below are expressed. It is the second component of the primary key and of the unique index HZ_PER_PROFILES_EXT_TL_U1 (EXTENSION_ID, LANGUAGE).
• SOURCE_LANG — The language from which the current values were derived, supporting the standard EBS translation-source convention.
• ATTR_GROUP_ID — Identifier grouping related extension attributes together.
• TL_EXT_ATTR1 through TL_EXT_ATTR20 — Twenty translated extensible attribute columns. These hold the actual language-specific text values of the user-defined person attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording insert and update context.

The surrogate primary key (EXTENSION_ID, LANGUAGE) is distinct from any business-key candidate; the documented unique index HZ_PER_PROFILES_EXT_TL_U1 carries the same column pair, confirming that one translation row exists per extension per language.

Common Use Cases and Queries

Typical usage involves retrieving translated person attribute values for display or reporting in a specific language, and joining the translation to its base and profile records. A representative query pattern:

• Join HZ_PER_PROFILES_EXT_TL to HZ_PER_PROFILES_EXT_B on EXTENSION_ID to combine the base definition with the language-specific values.
• Filter by LANGUAGE = USERENV('LANG') or a specific FND_LANGUAGES code to return the correct translation row.
• Join to HZ_PERSON_PROFILES on PERSON_PROFILE_ID to attribute the values back to the correct person.

Reporting scenarios include generating multilingual person profile extracts, auditing which extension records have translations in which languages, and validating that attribute groups (ATTR_GROUP_ID) resolve to translated strings. Administrators also query this table during implementation to confirm that custom extensible attributes were captured and translated correctly.

Related Objects

The following objects are most significant to HZ_PER_PROFILES_EXT_TL:

• HZ_PERSON_PROFILES — Referenced via PERSON_PROFILE_ID; the parent person profile record.
• FND_LANGUAGES — Referenced via LANGUAGE; supplies the installed language definitions validated by the translation rows.
• HZ_PER_PROFILES_EXT_B — The base table holding language-independent extension definitions; joined on EXTENSION_ID.
• HZ_PER_PROFILES_EXT_TL_PK — The primary key constraint enforcing uniqueness of EXTENSION_ID and LANGUAGE.
• HZ_PER_PROFILES_EXT_TL_U1 — The unique index over the same columns, serving as the documented business-key candidate.

Together these objects form the TCA extensible-attribute translation layer within the Receivables schema.