Search Results hz_org_profiles_ext_b




Overview
Explore in AI Chat

Overview

The table HZ_ORG_PROFILES_EXT_B is a core data object within the Oracle E-Business Suite (EBS) Trading Community Architecture (TCA) framework, specifically under the Receivables (AR) product family. Its primary role is to store extensible, or user-defined, attributes for organization profiles. This table enables the vertical extension of the standard organization data model, allowing implementations to capture additional, custom information about business entities (such as customers, suppliers, or partners) without modifying the core application tables. It is integral to maintaining a flexible and scalable customer master data repository in versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to support the extensible attributes model. The documented metadata highlights the EXTENSION_ID column as the primary key, which uniquely identifies each record of custom attribute data. The critical foreign key column is ORGANIZATION_PROFILE_ID, which links each set of extended attributes to a specific master organization profile record in the HZ_ORGANIZATION_PROFILES table. While the specific custom attribute columns are not detailed in the provided metadata, tables of this type typically include numerous ATTRIBUTE and CATEGORY columns (e.g., ATTRIBUTE1 through ATTRIBUTE20, CATEGORY_CODE) to hold the actual custom data values and their classification.

Common Use Cases and Queries

This table is primarily accessed for reporting and data integration involving custom organization attributes. Common scenarios include generating customer lists filtered by a custom industry classification stored as an extensible attribute, or populating data warehouses with bespoke customer demographics. A typical query joins this table to the core organization profile to retrieve both standard and custom data. For example:

  • SELECT hp.party_name, ext.attribute1 AS "Custom Field" FROM hz_organization_profiles hp, hz_org_profiles_ext_b ext WHERE hp.organization_profile_id = ext.organization_profile_id AND ext.category_code = 'INDUSTRY_DATA';

Data manipulation should generally be performed via the public TCA APIs (e.g., HZ_PARTY_V2PUB) to maintain data integrity, rather than through direct SQL DML.

Related Objects

The table maintains a direct and essential relationship with the core organization profile table, as documented by its foreign key constraint.

  • Primary Key Table: HZ_ORGANIZATION_PROFILES - The master table for organization profile information.
  • Foreign Key Relationship: The column HZ_ORG_PROFILES_EXT_B.ORGANIZATION_PROFILE_ID references HZ_ORGANIZATION_PROFILES. This is a one-to-one or one-to-many relationship where an organization profile can have zero or more associated records of extensible attributes.

This table is also conceptually related to other TCA extension tables (e.g., HZ_PERSON_PROFILES_EXT_B for individuals) and is accessed by the underlying TCA data dictionary and API layers that manage the flexfield infrastructure.