Search Results hz_party_sites




Overview
Explore in AI Chat

Overview

HZ_PARTY_SITES is the central TCA (Trading Community Architecture) table that links a party record in HZ_PARTIES to a physical address record in HZ_LOCATIONS. It resides in the AR schema and is classified as VALID in Oracle EBS 12.1.1 and 12.2.2. The table acts as the association layer between a person or organization and the place at which that party conducts business, receives goods, or is invoiced. A single party may be associated with many party sites, and a single location may be referenced by multiple party sites, making this one of the most heavily joined tables in the E-Business Suite.

From a Data Vault modeling perspective, the metadata heuristic classifies HZ_PARTY_SITES as a hub. In practice it behaves as a durable association entity: it owns its own surrogate key (PARTY_SITE_ID), carries EDW-style audit and WHO columns, and serves as the parent for numerous descriptive child tables such as HZ_PARTY_SITES_EXT_B and HZ_PARTY_SITE_USES.

Key Information Stored

The table exposes 75 documented columns. The most consequential are summarized below.

Common Use Cases and Queries

HZ_PARTY_SITES is queried whenever an application must resolve a party to a usable address. Typical reporting scenarios include customer address listings, supplier site directories, ship-to and bill-to assignments, and tax jurisdiction lookups.

A basic join returns the party name alongside its address details:

  • SELECT ps.party_site_id, ps.party_site_number, hp.party_name, hl.address1, hl.city, hl.state, hl.postal_code FROM hz_party_sites ps, hz_parties hp, hz_locations hl WHERE ps.party_id = hp.party_id AND ps.location_id = hl.location_id AND ps.status = 'A';

To identify the identifying address for a party, add the predicate IDENTIFYING_ADDRESS_FLAG = 'Y'. To find sites active on a given date, filter on START_DATE_ACTIVE and END_DATE_ACTIVE. To locate a customer account site, join through HZ_CUST_ACCT_SITES_ALL on PARTY_SITE_ID, and then through HZ_CUST_SITE_USES_ALL to determine whether the site is used as a bill-to, ship-to, or statement site.

Related Objects

The FK metadata shows HZ_PARTY_SITES is referenced by well over one hundred tables across modules. The most significant relationships include:

Because of this breadth, HZ_PARTY_SITES should be treated as a foundational reference object in any EBS data model, and joins to it should use the indexed PARTY_SITE_ID column wherever possible.