Search Results hz_party_usg_assignment_pub




Overview
Explore in AI Chat

Overview

HZ_PARTY_USG_ASSIGNMENT_PUB is a public PL/SQL API package in the Oracle E-Business Suite Trading Community Architecture (TCA) module, owned by the APPS schema and shipped with Oracle EBS 12.1.1 and 12.2.2. It provides the supported, externally callable interface for managing party usage assignments — the mechanism by which a party record (person, organization, or group) is associated with one or more usage codes such as Customer, Supplier, Employee, or Internal. Party usages drive downstream behavior across the EBS suite, determining which applications and business flows a given party record is eligible for.

The package follows the standard TCA public/private pattern: HZ_PARTY_USG_ASSIGNMENT_PUB exposes the API surface, while the corresponding HZ_PARTY_USG_ASSIGNMENT_PVT package contains the private implementation logic. This separation allows Oracle to maintain internal processing without altering the published interface contract.

Key Procedures and Functions

The package exposes three documented procedures:

  • ASSIGN_PARTY_USAGE — Creates a new usage assignment linking a party to a specified usage code. This is the primary entry point for granting a party record a new business role.
  • UPDATE_USG_ASSIGNMENT — Modifies an existing party usage assignment, allowing attributes of the assignment (such as status or effective dates) to be changed without deleting and recreating the record.
  • INACTIVATE_USG_ASSIGNMENT — Logically deactivates a party usage assignment rather than physically removing it, preserving the historical relationship while preventing further use of the assignment in transactional processing.

Parameter lists are not reproduced here; callers must reference the Oracle TCA API documentation or the package specification for exact signatures and return statuses.

Tables Accessed

The package operates on the TCA party usage assignment tables, primarily HZ_PARTY_USAGE_ASSIGNMENTS and its related reference tables. These tables store the association between a party identifier and a usage code, along with status and audit columns. The procedures in this package read existing assignment data to validate requests and write or update rows to persist assignment changes. Because the underlying implementation resides in HZ_PARTY_USG_ASSIGNMENT_PVT, the exact DML is performed there, but the public package serves as the authorized access path.

Usage Notes

HZ_PARTY_USG_ASSIGNMENT_PUB is typically invoked from three contexts:

  • Forms and UI flows — TCA-based forms such as the Party/Account maintenance screens call this API when users add or change a party's usage.
  • Concurrent programs and batch processes — Data conversion, bulk customer loading, and supplier registration programs call the API to assign usages programmatically.
  • Custom code and integrations — Oracle recommends this package over direct table DML for any custom extension assigning or inactivating party usages.

The package is referenced by several other TCA and supply-chain packages, including FUN_TCA_PKG, HZ_PARTY_BO_PVT, POS_VENDOR_PUB_PKG, and its own wrapper HZ_PARTY_USG_ASSIGNMENT_PUB_JW, confirming its role as a foundational TCA service. Dependent code references the public package rather than the private one, reinforcing the supported-API contract. Modification through this API ensures that TCA business rules, validation, and derived data are applied consistently.