Search Results party_usage_code




Overview
Explore in AI Chat

Overview

HZ_PARTY_USAGES_B is the base definition table for party usages within Oracle E-Business Suite Receivables (AR). It stores the master list of usage classifications that can be assigned to parties (persons, organizations, and groups) in the trading community architecture. Party usages drive how a party may be treated across applications — for example, whether a party is used as a customer, a supplier contact, a prospect, or an employee. The table resides in the AR schema and is flagged VALID in the ETRM 12.1.1 and 12.2.2 data models.

From a Data Vault modeling perspective, the heuristic classification of HZ_PARTY_USAGES_B is hub-leaning. Its structure — a single, stable business key with descriptive attributes held in dependent tables — makes it a natural candidate for a hub. The translation table HZ_PARTY_USAGES_TL, the rule table HZ_PARTY_USAGE_RULES, and the assignment table HZ_PARTY_USG_ASSIGNMENTS act as satellites, links, and dependent reference structures around this hub.

Key Information Stored

The table contains 13 documented columns in the ETRM 12.2.2 physical schema. The primary key is defined by the HZ_PARTY_USAGES_B_PK constraint, which is enforced on the PARTY_USAGE_CODE column. A separate unique index, HZ_PARTY_USAGES_B_U1, covers PARTY_USAGE_CODE together with ZD_EDITION_NAME, making it the documented business-key candidate and supporting edition-based redefinition. The most significant columns include:

Common Use Cases and Queries

Typical scenarios include validating which usages are active before assignment, joining to translations for multilingual reporting, and auditing the rules governing usage relationships. A common query lists active usage definitions:

  • SELECT party_usage_code, party_usage_type, status_flag FROM hz_party_usages_b WHERE status_flag = 'Y';
  • SELECT b.party_usage_code, t.party_usage_name FROM hz_party_usages_b b, hz_party_usages_tl t WHERE b.party_usage_code = t.party_usage_code AND t.language = USERENV('LANG');
  • SELECT r.party_usage_code, r.related_party_usage_code FROM hz_party_usage_rules r WHERE r.party_usage_code = :usage_code;

Reporting use cases include auditing usage-to-usage rules, reviewing assignment restrictions, and reconciling parties without active usages against HZ_PARTY_USG_ASSIGNMENTS.

Related Objects

The following objects reference or depend on HZ_PARTY_USAGES_B through documented foreign keys:

  • HZ_PARTY_USAGES_TL — translation table joined on PARTY_USAGE_CODE, supplying language-specific names and descriptions.
  • HZ_PARTY_USAGE_RULES — joined on PARTY_USAGE_CODE and RELATED_PARTY_USAGE_CODE, defining allowed relationships between usages.
  • HZ_PARTY_USG_ASSIGNMENTS — joined on PARTY_USAGE_CODE, recording which usages are assigned to which parties.

These three tables constitute the primary dependency surface, with HZ_PARTY_USG_ASSIGNMENTS being the highest-volume transactional consumer of the base definition.