Search Results hz_party_sites




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

Table Name: HZ_PARTY_SITES
Module: Customer Data Management (CDM) / Fusion Customer Data Hub (CDH)

Purpose:
The HZ_PARTY_SITES table stores physical location information for parties (customers, suppliers, partners) in the Oracle EBS system. It represents the geographical sites or addresses associated with a specific party.

Key Columns:
1. PARTY_SITE_ID (Primary Key)
- Unique identifier for each party site
- Typically a system-generated sequence number

2. PARTY_ID
- Foreign key linking to HZ_PARTIES table
- Identifies the party associated with this site

3. LOCATION_ID
- References HZ_LOCATIONS table
- Contains detailed address information

4. ORIG_SYSTEM_REFERENCE
- Optional external system reference code
- Used for integration with legacy systems

5. STATUS
- Indicates site status (Active/Inactive)

6. PRIMARY_FLAG
- Denotes if this is the primary site for the party
- Values: 'Y' or 'N'

7. CREATION_DATE
- Timestamp of site record creation

8. CREATED_BY
- User who created the site record

Common Usage:
- Store multiple addresses for a single party
- Track shipping, billing, and other site addresses
- Support multi-site customer/vendor configurations

Relationships:
- Links HZ_PARTIES and HZ_LOCATIONS tables
- Used in customer/supplier site management processes