Search Results hz_parties




Here's a detailed description of the HZ_PARTIES table in Oracle E-Business Suite (EBS):

Table Name: HZ_PARTIES
Module: Customer Data Management (CDM)
Purpose: Central repository for party (entity) information across different modules

Key Characteristics:
- Contains information about individuals, organizations, and other entities
- Used across multiple Oracle applications (Financials, CRM, etc.)
- Part of the Trading Community Architecture (TCA)

Significant Columns:
1. PARTY_ID (Primary Key)
- Unique identifier for each party
- Used in joins with other tables

2. PARTY_NUMBER
- External reference number for the party
- Often used for reporting and integration

3. PARTY_TYPE
- Identifies type of party (ORGANIZATION, PERSON)
- Determines additional attributes and behavior

4. STATUS
- Current status of the party record
- Examples: Active, Inactive

5. PARTY_NAME
- Legal or registered name of the party

6. CREATED_BY
- User who created the party record

7. LAST_UPDATE_DATE
- Timestamp of last modification

Common Use Cases:
- Customer creation
- Supplier management
- Partner tracking
- Address and contact management

Typical Relationships:
- Linked to HZ_PARTY_SITES
- Connected with HZ_CUST_ACCOUNTS
- Joins with HR_ALL_ORGANIZATION_UNITS

Recommended Best Practices:
- Maintain data consistency
- Use standardized naming conventions
- Implement duplicate prevention strategies