Search Results hz_merge_batch_pub




Overview
Explore in AI Chat

Overview

HZ_MERGE_BATCH_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Trading Community Architecture (TCA) party and customer data model, and its role is to support the creation and management of merge batches used during the party duplication resolution process. Within TCA, a merge batch groups a set of duplicate parties or party sites so that they can be submitted together for survivorship and merge processing. The package exposes a published (PUB) interface, meaning its procedures are intended to be callable from outside the TCA application code, and it is documented and metadata-driven under ETRM. The documented status is VALID, and the package depends on the standard Oracle Application Object Library API package FND_API, which provides the common API error-handling and return-status conventions used throughout EBS public APIs.

Key Procedures and Functions

The ETRM metadata records a single documented procedure for this package:

  • CREATE_MERGE_BATCH — Creates a merge batch record for subsequent duplicate resolution processing. This procedure encapsulates the logic required to register a new batch in the TCA merge infrastructure, typically assigning or accepting a batch identifier and establishing the batch context. Because the package follows the FND_API convention (evidenced by its dependency on APPS.FND_API), the procedure is expected to return standard API status codes and to communicate errors through the standard API error stack rather than raising unhandled exceptions. Parameter-level detail is not enumerated in the ETRM excerpt; callers should consult the package specification in the database for the authoritative argument list.

Tables Accessed

The ETRM excerpt for this package does not individually enumerate the base tables it reads or writes, and it notes that table references are exposed through APPS synonyms. Functionally, CREATE_MERGE_BATCH operates against the TCA merge batch storage structures that hold batch header and batch membership information. These are the tables that record which duplicate party or site records have been grouped for a given merge run, together with batch-level status and processing attributes. Because the metadata documents no directly named tables, the dependency and synonym listings in ETRM should be reviewed against the current instance before any custom integration is built.

Usage Notes

HZ_MERGE_BATCH_PUB is typically invoked programmatically rather than from a standard Oracle form. In practice it is called by TCA merge-processing components, by concurrent programs that automate duplicate resolution, and by custom PL/SQL or Java code that needs to create merge batches outside the standard user interface. The package is referenced by no other documented packages in the ETRM listing, indicating that its primary consumers are external callers and internal TCA modules not captured in this dependency view.

Because it is a public API, custom code should call CREATE_MERGE_BATCH rather than inserting directly into the underlying merge batch tables, so that validation and audit behavior remain consistent. Callers must handle the FND_API return status and inspect the API error message stack on failure. When migrating or upgrading between 12.1.1 and 12.2.2, the package specification in the target instance should be verified, since the ETRM metadata here reflects the 12.2.2 documentation set and lists only one documented procedure. Direct DML against TCA merge tables is unsupported and risks bypassing the integrity checks that this package is designed to enforce.