Results for “hz_org_profiles_ext_b”

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

Overview

HZ_ORG_PROFILES_EXT_B is a table owned by the AR (Receivables) schema within Oracle E-Business Suite, validated in both 12.1.1 and 12.2.2. It stores extensible attributes for organizations, functioning as the descriptive-attribute extension of the organization profile record maintained in the Trading Community Architecture (TCA) model. In practice, the table captures user-defined or seeded flexfield values that do not fit within the fixed column set of HZ_ORGANIZATION_PROFILES, allowing organizations to be qualified by additional operational, regulatory, or reporting characteristics.

The ETRM metadata classifies this object as satellite-leaning under a heuristic Data Vault assessment. That classification is a modeling suggestion rather than a physical designation: the table's dense attribute column set, its dependence on a parent business entity (HZ_ORGANIZATION_PROFILES via ORGANIZATION_PROFILE_ID), and its surrogate EXTENSION_ID key are characteristic of a satellite structure surrounding an organization hub. Each row therefore represents an extension record attached to exactly one organization profile.

Key Information Stored

The primary key is EXTENSION_ID, defined by constraint HZ_ORG_PROFILES_EXT_B_PK and reinforced by the unique index HZ_ORG_PROFILES_EXT_B_U1. This is a surrogate identifier with no business meaning outside the table itself. The true business linkage is the foreign key column ORGANIZATION_PROFILE_ID, which references the parent profile in HZ_ORGANIZATION_PROFILES. The table also carries ATTR_GROUP_ID, which designates the attribute group or context under which the extension values were captured, and OLD_EXTENSION_ID, which supports migration or re-keying of prior extension records.

The extensible data itself is held in three groups of fifty generic columns, of which the most significant are the character, numeric, and date attributes. The C_EXT_ATTR1 through C_EXT_ATTR20 columns store character values, the N_EXT_ATTR1 through N_EXT_ATTR20 columns store numeric values, and the D_EXT_ATTR1 through D_EXT_ATTR10 columns store dates. These generic columns are mapped to meaningful business attributes by descriptive flexfield definitions rather than being self-describing in the base table. Standard audit and concurrency columns round out the structure: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. The table contains 59 columns in total as documented for 12.2.2.

Common Use Cases and Queries

Typical usage involves retrieving the extended attribute values for a specific organization, often in conjunction with the parent profile. A basic lookup joins the two tables on the foreign key:

• SELECT e.organization_profile_id, e.c_ext_attr1, e.n_ext_attr1, e.d_ext_attr1 FROM hz_org_profiles_ext_b e WHERE e.organization_profile_id = :profile_id;
• SELECT p.party_id, e.attr_group_id, e.c_ext_attr1, e.c_ext_attr2 FROM hz_organization_profiles p, hz_org_profiles_ext_b e WHERE p.organization_profile_id = e.organization_profile_id AND e.attr_group_id = :group_id;
• Aggregate reporting that counts populated extension records: SELECT attr_group_id, COUNT(*) FROM hz_org_profiles_ext_b GROUP BY attr_group_id;

Because the C_EXT_ATTR, N_EXT_ATTR, and D_EXT_ATTR columns are flexfield segments, list-of-values and attribute-mapping logic is ordinarily driven from the flexfield definition tables rather than queried directly. Concurrent programs, interfaces, and third-party integrations that load organization data should insert or update rows in this table only after the parent HZ_ORGANIZATION_PROFILES row is created, and should populate ATTR_GROUP_ID consistently with the flexfield context being applied.

Related Objects

The principal relationship is to the parent organization profile. The most significant related objects and their join columns are:

• HZ_ORGANIZATION_PROFILES — referenced via HZ_ORG_PROFILES_EXT_B.ORGANIZATION_PROFILE_ID; the parent hub record holding the base organization profile.
• HZ_ORG_PROFILES_EXT_TL — the translated companion table that carrries language-specific extension content keyed to the same extension identifier.
• FND_DESCR_FLEX_CONTEXTS and FND_DESCR_FLEX_COL_USAGE — definition and column-mapping metadata that interpret the C_EXT_ATTR, N_EXT_ATTR, and D_EXT_ATTR columns.
• HZ_PARTIES — the underlying party record associated with the organization profile, reachable through the profile's party relationship.
• HZ_CUST_ACCOUNTS — customer accounts derived from the organization profile, frequently joined when extension attributes drive receivables setup.
• TCA registration and party APIs — the supported programmatic route for creating and maintaining organization profiles and their extensions, rather than direct DML.