OracleOps AI
← All tables
Oracle Fusion/Financials/Customers

HZ_PARTY_SITES

A physical site (address) tied to a party, independent of any specific customer account's use of it.

Key Columns

PARTY_SITE_IDPARTY_IDLOCATION_ID

Parent Table

HZ_PARTIES

Trading Community Architecture (TCA) party master — the underlying person or organization, independent of any role (customer, supplier, contact) it plays.

Common Joins

HZ_PARTIESvia PARTY_ID

The party this site address belongs to.

HZ_CUST_ACCT_SITES_ALLvia PARTY_SITE_ID

The account-specific use of this site once it's assigned to a customer account.

Used In

Customers

Related

Customer / Trading Community data model

Oracle Fusion models customers through Trading Community Architecture (TCA): a HZ_PARTIES record is the underlying person or organization, which becomes a transactable customer once a HZ_CUST_ACCOUNTS row exists against it. Addresses live on HZ_PARTY_SITES at the party level, and are assigned to a specific account (HZ_CUST_ACCT_SITES_ALL) with a business purpose like Bill-To or Ship-To (HZ_CUST_SITE_USES_ALL) — those site-use records are what AR and Order Management actually default onto a transaction.

Ask Oracle AI about HZ_PARTY_SITES