Search Results hz_party_sites_ext_b_n1




Overview
Explore in AI Chat

Overview

HZ_PARTY_SITES_EXT_B is a descriptive-flexfield table in the Oracle E-Business Suite 12.1.1 and 12.2.2 data model, owned by the AR schema and registered in FND Design Data as AR.HZ_PARTY_SITES_EXT_B. It stores the extensible attribute values that customers define through the Oracle Trading Community Architecture (TCA) descriptive flexfield mechanism for party sites. Party sites represent the physical locations associated with a party record — for example, a customer's billing address, a supplier's remittance location, or a contact's postal address — and this table persists the organization-specific "additional information" captured for each of those sites.

The object is a virtual column (B) table: the base row carries the identifier and attribute-group references, while the attribute values themselves are distributed across numbered character, number, and date columns. The documented physical schema records 58 columns in ETRM 12.2.2. In Data Vault terms, the mined relationship structure classifies this object as satellite-leaning — a modeling suggestion only, reflecting that its rows are dependent attribute payloads keyed to a parent rather than standalone master data or a pure association link.

Key Information Stored

The table's unique system-generated identifier is EXTENSION_ID, which is also the primary key (HZ_PARTY_SITES_EXT_B_PK) and the column behind the unique index HZ_PARTY_SITES_EXT_B_U1. This makes EXTENSION_ID the documented business-key candidate for the unique constraint; it is a surrogate, not a natural key.

Common Use Cases and Queries

Typical usage centers on retrieving or reporting the flexfield values captured against a specific site, or joining them back to the party site master to produce an enriched address report.

  • Fetch all extension rows for a site: SELECT * FROM HZ_PARTY_SITES_EXT_B WHERE PARTY_SITE_ID = :p_site_id;
  • Resolve a specific flexfield value: SELECT C_EXT_ATTR1, N_EXT_ATTR1, D_EXT_ATTR1 FROM HZ_PARTY_SITES_EXT_B WHERE EXTENSION_ID = :p_ext_id;
  • Reporting join across the FK: SELECT s.PARTY_SITE_ID, s.PARTY_SITE_NAME, e.C_EXT_ATTR1 FROM HZ_PARTY_SITES_EXT_B e JOIN HZ_PARTY_SITES s ON s.PARTY_SITE_ID = e.PARTY_SITE_ID WHERE e.ATTR_GROUP_ID = :p_group;
  • Audit/refresh checks keyed on the Who columns (LAST_UPDATE_DATE) to detect sites whose descriptive data changed since a given date.

Because the table is the EBS "B" extension table, functional maintenance is normally performed through the TCA party-site maintenance forms and the public TCA APIs rather than direct DML. Custom reports and integrations may query it directly, but should treat the C/N/D_EXT_ATTR columns as flexfield-mapped and resolve their meaning through the flexfield definition for the applicable ATTR_GROUP_ID.

Related Objects

The most significant relationship is the foreign key from HZ_PARTY_SITES_EXT_B.PARTY_SITE_ID to the party site master, which is the primary parent in all queries. Business-key resolution relies on HZ_PARTY_SITES_EXT_B_U1 (EXTENSION_ID) and site-driven access uses HZ_PARTY_SITES_EXT_B_N1 (PARTY_SITE_ID). Beyond that documented FK, related objects include:

  • HZ_PARTY_SITES — parent master table; join on PARTY_SITE_ID.
  • HZ_PARTIES — the party owning each site, reached transitively via HZ_PARTY_SITES.PARTY_ID.
  • HZ_LOCATIONS — the normalized address associated with the party site, reached through HZ_PARTY_SITES.
  • HZ_PARTY_SITE_USES — site-purpose rows that qualify how a site is used, joinable through PARTY_SITE_ID.
  • FND_DESCR_FLEX_COLUMN_USAGES / FND_DESCR_FLEX_CONTEXTS — flexfield metadata that maps each C/N/D_EXT_ATTR column and ATTR_GROUP_ID to a user-visible prompt and context.
  • HZ_PARTY_SITES_EXT_TL — the translated companion table holding language-specific descriptive text for the extension attributes.
  • TCA public APIs (e.g. HZ_PARTY_SITE_V2PUB / HZ_PARTY_SITE_V2PUB.update_party_site) — the supported programmatic entry points that write the rows this table stores.