Search Results igs_pe_stat_details

Overview

The HZ_PERSON_PROFILES table is a core data object within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically under the Receivables (AR) product family. It functions as the central repository for storing detailed, profile-level information about individuals (people) within the Trading Community Architecture (TCA) model. While the HZ_PARTIES table defines the fundamental existence of a party, HZ_PERSON_PROFILES holds the extensive descriptive attributes and demographic details that characterize a person, such as employment, education, and personal identifiers. Its primary role is to support complex customer relationship management, targeted marketing, compliance, and detailed reporting on individual constituents across various EBS modules.

Key Information Stored

The table's structure is anchored by the PERSON_PROFILE_ID primary key and the PARTY_ID foreign key, which links each profile to a specific person-type record in HZ_PARTIES. While the provided metadata does not list all columns, typical critical attributes stored in this and its extension tables include personal titles, gender, date of birth, marital status, employment information (job title, employer), income level, education level, and household role. It often serves as the hub for collecting various personal identifiers and classification data used for segmentation and analysis. The existence of extension tables (HZ_PER_PROFILES_EXT_B and HZ_PER_PROFILES_EXT_TL) indicates that the core table is designed to be extended with additional, possibly product-specific or localized, attributes.

Common Use Cases and Queries

A primary use case is generating detailed person-centric reports for marketing campaigns or compliance audits. For instance, querying for individuals within a specific demographic or professional segment. Another common scenario is integrating person profile data into customer service or collections processes within Receivables. A typical SQL pattern involves joining to the party table to retrieve basic party information alongside the rich profile details.

SELECT hp.party_name,
       hpp.date_of_birth,
       hpp.employment_status,
       hpp.education_level
FROM   hz_parties hp,
       hz_person_profiles hpp
WHERE  hp.party_id = hpp.party_id
AND    hp.party_type = 'PERSON'
AND    hpp.education_level = 'GRADUATE_DEGREE';

Data maintenance is typically performed via the TCA Public APIs (e.g., HZ_PARTY_PUB) rather than through direct DML on the table.

Related Objects

HZ_PERSON_PROFILES maintains defined foreign key relationships with several other TCA objects, as documented in the metadata:

• HZ_PARTIES: The foundational relationship. HZ_PERSON_PROFILES.PARTY_ID references HZ_PARTIES.PARTY_ID, ensuring every person profile is associated with a master party record.
• HZ_PER_PROFILES_EXT_B: References HZ_PERSON_PROFILES via HZ_PER_PROFILES_EXT_B.PERSON_PROFILE_ID. This is a base extension table for additional attributes.
• HZ_PER_PROFILES_EXT_TL: References HZ_PERSON_PROFILES via HZ_PER_PROFILES_EXT_TL.PERSON_PROFILE_ID. This is a translation table for multilingual support of the extended attributes.
• IGS_PE_STAT_DETAILS: References HZ_PERSON_PROFILES via IGS_PE_STAT_DETAILS.PERSON_PROFILE_ID. This indicates integration with the Oracle Student Systems (OSS) module, linking person profile data to student-specific statutory details.