Search Results hz_merge_batch_pkg




Overview
Explore in AI Chat

Overview

HZ_MERGE_BATCH_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It functions as the low-level database access layer for the Oracle Trading Community Architecture (TCA) party merge process, which consolidates duplicate party records and their related entities within the HZ (Trading Community) data model. The package encapsulates the DML operations required to maintain merge batch records — the control structures that group merge operations for processing — and is classified in the ETRM repository under the API classification "OTHER," denoting an internal component rather than a published public API. The package is a VALID object and is documented with four procedures. It is referenced by two other packages, reflecting its role as a dependent building block for higher-level merge logic rather than as an entry point invoked directly by end users or external interfaces.

Key Procedures and Functions

The documented interface consists of four procedures, each performing a single row-level data manipulation operation against the merge batch schema:

  • INSERT_ROW — Creates a new merge batch record, populating the columns required to define a batch of party merge operations.
  • UPDATE_ROW — Modifies an existing merge batch record, allowing attributes such as status and descriptive information to be maintained throughout the merge lifecycle.
  • LOCK_ROW — Obtains a row-level lock on a specific merge batch record. This is typically used to serialize concurrent processing and prevent two sessions from acting on the same batch simultaneously.
  • DELETE_ROW — Removes a merge batch record, used when a batch is no longer required or is superseded.

The package supplies no documented functions and exposes no public API, consistent with its classification as an internal support package. Parameter lists are not published in the ETRM metadata and should not be assumed; callers should reference the actual package specification for signatures.

Tables Accessed

According to the ETRM documentation, the package references two tables through APPS synonyms:

  • HZ_MERGE_BATCH — The primary merge batch table, storing batch header-level information that controls how sets of party merges are grouped and processed.
  • HZ_MERGE_BATCH_S — The corresponding translated (TL) table, holding language-specific or attribute-segment records associated with the base merge batch row.

The procedures perform direct inserts, updates, deletes, and locking against these objects, making the package a thin DML wrapper around the merge batch entity.

Usage Notes

HZ_MERGE_BATCH_PKG is invoked indirectly through TCA party merge processing rather than from a standard EBS form. The ETRM metadata records that it is referenced by two other packages — HZ_MERGE_BATCH_PUB and HZ_MERGE_DUP_PVT — indicating that the public and private merge logic layers call this package to persist and manage batch state. It may also be called from concurrent programs that execute party merge batches, and from custom code that must create, update, or clean up merge batch definitions programmatically. Because the package performs direct DML and locking, custom callers should invoke it only within the same transaction boundaries expected by the TCA merge architecture and must ensure that prerequisites such as the merge batch identifiers and the HZ_MERGE_BATCH / HZ_MERGE_BATCH_S structures are correctly established. Developers migrating or supporting EBS 12.1.1 and 12.2.2 should confirm current parameter signatures against the deployed package specification, as the ETRM documentation lists only object names and does not publish the call interface.