Search Results hz_org_contacts

Overview

The HZ_ORG_CONTACTS table is a core data object within the Oracle E-Business Suite Trading Community Architecture (TCA) model, specifically under the AR (Receivables) product family. It serves as the central repository for storing records of individuals who act as contacts for organizational parties. This table is fundamental to managing business relationships, enabling the association of specific people with customer, supplier, or partner organizations for purposes such as communication, order management, service delivery, and marketing. Its role is critical across multiple EBS modules, including Order Management, Service, Marketing, and Sales, by providing a unified, non-redundant source for contact information linked to business entities.

Key Information Stored

While the provided metadata does not list specific columns, the structure is defined by its primary and foreign keys, which reveal its core data relationships. The primary key is ORG_CONTACT_ID, uniquely identifying each contact record. Crucially, the table does not store the contact's personal details directly; instead, it acts as a junction point. The PARTY_RELATIONSHIP_ID foreign key links to HZ_PARTY_RELATIONSHIPS and HZ_RELATIONSHIPS, where the actual person party is defined and related to an organization party. The PARTY_SITE_ID foreign key links to HZ_PARTY_SITES, optionally associating the contact with a specific location of the organization. This design enforces data integrity by reusing the centralized TCA party model.

Common Use Cases and Queries

Common use cases include retrieving all contacts for a specific customer account, finding contacts at a particular site, or identifying contacts for integration with CRM activities. A typical query involves joining to the core TCA tables to resolve party names and details. For example, to find contacts for a given organization party ID:

• SELECT hc.org_contact_id, hp_person.party_name contact_name, hp_org.party_name org_name FROM hz_org_contacts hc, hz_relationships hr, hz_parties hp_person, hz_parties hp_org WHERE hc.party_relationship_id = hr.relationship_id AND hr.subject_id = hp_person.party_id AND hr.object_id = hp_org.party_id AND hp_org.party_id = <ORG_PARTY_ID>;

Reporting often centers on contact roles (via HZ_ORG_CONTACT_ROLES) or their involvement in transactions, such as orders or service requests, where contact IDs are referenced as deliver-to or invoice-to contacts.

Related Objects

The HZ_ORG_CONTACTS table is central to the TCA model, with extensive dependencies. Key related objects, as per the metadata, include:

• Parent/Dimension Tables: HZ_PARTY_RELATIONSHIPS, HZ_RELATIONSHIPS (for the contact-person to organization link), and HZ_PARTY_SITES (for location).
• Child/Fact Tables: HZ_ORG_CONTACT_ROLES (defining contact functions), HZ_STAGED_CONTACT_POINTS, and HZ_STAGED_PARTY_SITES for data quality management.
• Integration Points: Numerous application tables reference ORG_CONTACT_ID, including OE_LINES_IFACE_ALL (for order line contacts), AS_LEAD_CONTACTS_ALL (Marketing), JTF_RS_RESOURCE_EXTNS (Resource Manager), and AMS_EVENT_REGISTRATIONS. This demonstrates its cross-module importance.