OracleOps AI
← All tables
Oracle Fusion/Financials/Customers

HZ_CUST_SITE_USES_ALL

The business-purpose assignment of an account site (Bill-To, Ship-To, etc.) — what AR and Order Management actually reference when defaulting an address onto a transaction.

Key Columns

SITE_USE_IDCUST_ACCT_SITE_IDSITE_USE_CODE

Parent Table

HZ_CUST_ACCT_SITES_ALL

Links a customer account to one of its party's sites, making that address usable for that specific account.

Common Joins

HZ_CUST_ACCT_SITES_ALLvia CUST_ACCT_SITE_ID

The account site this business-purpose use is defined for.

Used In

AROrder Management

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_CUST_SITE_USES_ALL