Search Results hz_extract_bo_util_pvt




Overview
Explore in AI Chat

Overview

APPS.HZ_EXTRACT_BO_UTIL_PVT is a private (PVT) PL/SQL package body that supplies internal utility logic for the extraction of Trading Community Architecture (TCA) business object data. It belongs to the Oracle Trading Community foundation (AR/HZ) module, and its name reflects its role: a helper layer supporting the HZ "extract business object" framework used to move party, customer, and contact data between Oracle E-Business Suite environments or into downstream integrations. It is classified as a private API, meaning it is not part of the published, supported integration surface and is not intended for direct invocation by customer code.

The package contains no top-level DDL of its own; it is a container of reusable subprograms that validate identifiers, resolve parent-child object relationships, and retrieve user context needed while assembling business object extraction payloads. It bridges the standard TCA base tables and the extraction/tracking metadata maintained in HZ_BUS_OBJ_TRACKING.

Key Procedures and Functions

The documented package exposes five subprograms:

  • VALIDATE_EVENT_ID — confirms that a supplied extraction event identifier is valid and recognized within the business object tracking framework before extraction proceeds.
  • GET_PARENT_OBJECT_TYPE — returns the parent object type for a given business object entity, used to reconstruct hierarchical relationships during extraction.
  • GET_USER_NAME — resolves the user name associated with an operating session or record; useful for audit and attribution during extraction runs.
  • GET_BO_ROOT_IDS — retrieves the root business object identifiers that anchor an extraction; these roots drive the traversal of child records.
  • VALIDATE_SSM_ID — validates a source-system mapping or SSM identifier used to trace records back to their originating system.

Together these subprograms provide the validation and lookup scaffolding consumed by the higher-level extraction logic.

Tables Accessed

Through APPS synonyms, the package reads TCA master and site-related tables to resolve the entities being extracted:

It also depends on FND_API, FND_LOG, FND_MESSAGE, FND_MSG_PUB, FND_PROFILE, HZ_MOSR_VALIDATE_PKG, HZ_ORIG_SYSTEM_REF_PUB, and HZ_UTILITY_V2PUB.

Usage Notes

Because HZ_EXTRACT_BO_UTIL_PVT is a private package, it is not called directly from forms, concurrent program parameters, or customer-authored code. It is instead invoked internally by the TCA business object extraction and tracking programs (the metadata notes it is referenced by 30 other packages, but it does not reference any of them back). Practitioners encountering this object in a stack trace or dependency report should treat it as part of the internal extraction plumbing, valid in both Oracle EBS 12.1.1 and 12.2.2, and should not customize or call it. Any functional change to extraction behavior should be pursued through the supported public APIs in the HZ_*_V2PUB family.