Search Results hz_utility_v2pub




Overview
Explore in AI Chat

Overview

HZ_UTILITY_V2PUB is a public PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified as a PUB (public) API component within the Trading Community Architecture (TCA) module. It serves as a foundational utility layer for the Oracle Receivables and TCA customer/party model, providing reusable validation, lookup translation, and diagnostic routines that other public APIs call during entity creation and update processing. Rather than managing a single business entity, HZ_UTILITY_V2PUB centralizes cross-cutting concerns: mandatory field enforcement, non-updateable column protection, date-range validation, lookup verification, and debug logging. In EBS 12.1.1 and 12.2.2 this package is catalogued as VALID, confirming that it compiles successfully against the current database objects in the environment. Its dependency footprint, which spans FND_API, FND_MSG_PUB, FND_GLOBAL, and the FND_LOG framework, confirms it is intended to be consumed by other APIs rather than executed directly by end users.

Key Procedures and Functions

The ETRM metadata documents 54 procedures and functions, dominated by validation and audit utilities:

Tables Accessed

The package reads and validates against a broad set of TCA and shared reference tables via APPS synonyms, including HZ_PARTY_SITES, HZ_PARTY_SITE_USES, HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES, HZ_CONTACT_POINTS, HZ_CONTACT_PREFERENCES, HZ_ORG_CONTACT_ROLES, HZ_ORGANIZATION_PROFILES, HZ_RELATIONSHIP_TYPES, HZ_CODE_ASSIGNMENTS, HZ_ORIG_SYSTEMS_B, and HZ_DNB_REQUEST_LOG. On the reference side it consults FND_LANGUAGES, FND_LOOKUP_VALUES, and SO_LOOKUPS for multilingual and lookup-value resolution. These accesses support validation of party-site, customer-site, contact, and organization-profile data before the calling API commits changes.

Usage Notes

HZ_UTILITY_V2PUB is not invoked directly from a form or concurrent program; it is a subordinate utility referenced by 280 other database objects. Custom code extending TCA should call the corresponding public entity APIs (for example party, customer, or site APIs), which in turn invoke these validation and Who-column helpers. Developers diagnosing problems in downstream APIs frequently enable debug through this package to capture FND_LOG output and returned message text. Because it reads V$SESSION and V$PROCESS, execution requires the standard APPS privileges granted through AD_APPS_PRIVATE.