Search Results hz_org_profiles_ext_sg

Overview

The HZ_ORG_PROFILES_EXT_SG table is a staging table within the Oracle E-Business Suite (EBS) Receivables (AR) module. Its primary function is to support the versioning of organization profile extensions within the Trading Community Architecture (TCA) foundation. When a profile for an organization party is updated, this table temporarily holds the relationship between the old and new profile identifiers for any extended, custom attribute data. This ensures data integrity and auditability during the versioning process, allowing the system to correctly map and migrate extension data from one profile version to the next without loss.

Key Information Stored

The table's structure is minimal and focused on its staging purpose. As defined by its primary key constraint, HZ_ORG_PROFILES_EXT_SG_PK, it contains two critical columns that form a composite key. The NEW_PROFILE_ID column stores the identifier for the newly created or updated organization profile version. The OLD_PROFILE_ID column stores the identifier for the previous profile version from which extension data is being copied. This pairing creates a definitive link between two specific iterations of a party's profile for the purpose of managing custom extension data during the versioning operation.

Common Use Cases and Queries

The primary use case is internal to the TCA profile versioning process. It is not typically queried directly for business reporting but may be examined for data validation or troubleshooting during profile updates. A common diagnostic query would verify the staging relationships for a specific profile update. For instance, to see all staging records for a particular old profile, one might use: SELECT * FROM HZ_ORG_PROFILES_EXT_SG WHERE OLD_PROFILE_ID = <profile_id>;. Conversely, to find the source of a new profile's extension data: SELECT * FROM HZ_ORG_PROFILES_EXT_SG WHERE NEW_PROFILE_ID = <profile_id>;. The table is generally transient in nature, with records likely being purged after the versioning process is complete.

Related Objects

The table's sole documented relationship is its primary key. However, given its function, it is intrinsically linked to the core TCA profile tables. It serves as a supporting object for the HZ_ORG_PROFILES table, which stores the main organization profile data. The OLD_PROFILE_ID and NEW_PROFILE_ID values correspond to the PROFILE_ID column in HZ_ORG_PROFILES. Furthermore, it relates to the extension tables for organization profiles, which are typically named in the pattern of HZ_ORG_PROFILES_EXT_B and HZ_ORG_PROFILES_EXT_TL, facilitating the copying of their custom attribute rows from one profile ID to another during the versioning operation managed through this staging table.