Search Results load_set

Overview

HZ_ACCT_MERGE_UTIL is a utility package owned by APPS within the Oracle E-Business Suite Trading Community Architecture (TCA) and Receivables module. Its documented purpose is to support the customer and account merge process by resolving the surviving entity identifiers when duplicate or merged records exist. In an account merge operation, a source (duplicate) customer account, site, or site use is merged into a target (surviving) account. Downstream processing frequently needs to translate an obsolete identifier from the source record into the corresponding identifier that now belongs to the surviving record. This package provides those translation services in a compact, reusable form.

The package is declared with AUTHID CURRENT_USER, meaning it executes under the privileges of the calling schema rather than the defining schema. The header comment reflects a source version dated 2005, and the package carries no shipping flag, indicating it is an internal utility rather than a formally supported public API. The ETRM metadata classifies it as a UTIL-type API and records that it is referenced by 41 other packages, confirming its role as shared infrastructure within the TCA merge and Receivables codebase.

Key Procedures and Functions

• GETDUP_SITE_USE — A function that accepts a site use identifier and returns a numeric value. It resolves the surviving site use for a site use that has been merged or identified as a duplicate.
• GETDUP_SITE — A function that accepts a site identifier and returns a numeric value. It resolves the surviving site for a site that has been merged or identified as a duplicate.
• GETDUP_ACCOUNT — A function that accepts an account identifier and returns a numeric value. It resolves the surviving account for an account that has been merged or identified as a duplicate.
• LOAD_SET — A procedure accepting a set number and a request identifier. It loads or populates merge-related data for the specified set within the context of a concurrent request, enabling the request identifier to be tracked for diagnostics and concurrency management.

Each of the three GETDUP functions follows the same resolution pattern at different levels of the TCA entity hierarchy: site use, site, and account. Together they allow a caller to obtain the current surviving identifier for any level of a merged customer record.

Tables Accessed

The package references two tables through APPS synonyms:

• RA_CUSTOMER_MERGES — The Receivables table that stores the merge audit trail, mapping the original duplicate identifiers to the surviving identifiers for accounts, sites, and site uses. The GETDUP functions and LOAD_SET rely on this table as the authoritative source of merge mappings.
• PLITBLM — An internal PL/SQL index-by table (associative array) helper type used for in-memory set processing. It supports the bulk handling performed by LOAD_SET.

Usage Notes

HZ_ACCT_MERGE_UTIL is normally invoked indirectly rather than called directly by end users. Its principal consumers are the TCA and Receivables packages and concurrent programs that execute customer merge operations, including the merge validation and post-merge update routines. LOAD_SET is typically driven from a concurrent program context, as evidenced by its p_request_id parameter, which ties the processing to a specific concurrent request. The GETDUP functions are called from custom or seeded code that must translate a source identifier into the surviving identifier after a merge has been performed.

Because the package is not designated as a public shipping API and carries no formal compatibility guarantee, customizations that call it should verify behavior against the specific patch level in use. In EBS 12.1.1 and 12.2.2 the signature is unchanged; the 12.2.x online patching model does not alter the package's runtime behavior. The metadata entry for "load_set" typically appears when developers search the data dictionary or ETRM repository after encountering a call to this procedure, and it confirms that LOAD_SET is the only documented procedure that accepts a concurrent request identifier within this package.