Search Results cs_sr_party_merge_pkg




Overview
Explore in AI Chat

Overview

APPS.CS_SR_PARTY_MERGE_PKG is a PL/SQL package in the Oracle E-Business Suite (EBS) Applications schema that supports the customer and party merge process within the Service (CSI/CS) product family. In EBS Release 12.1.1 and 12.2.2, party merge functionality is executed through the Oracle Trading Community Architecture (TCA) and Oracle Customer Data Management (CDM) "Party Merge" concurrent programs, which consolidate duplicate parties, accounts, and contacts into a single surviving record. Because the Service modules store references to parties, contacts, sites, and site uses across their own transactional tables, these references must be remapped or archived during a merge. CS_SR_PARTY_MERGE_PKG provides the Service-side implementation of that remapping logic.

The package is classified in the ETRM metadata as an "OTHER" API (not a formal public API), meaning it is intended to be called internally by the merge orchestration layer rather than directly by customer code. It is referenced by and references the sibling package CS_PARTYMERGE_PKG, which acts as the controlling gateway for Service-related merge processing. The package status is VALID, confirming it is compiled and available in the APPS schema.

Key Procedures and Functions

The documented package exposes seventeen procedures and functions, organized into three functional groups:

Tables Accessed

Per the ETRM metadata, the package reads and writes the following tables through APPS synonyms:

  • CS_HZ_SR_CONTACT_POINTS: Stores service-request contact point associations; remapped by the contact point merge routines.
  • CS_INCIDENTS_ALL_B: The base table for service incidents (service requests); party, contact, and site references are updated during merge.
  • CS_INCIDENTS_AUDIT_B: The audit shadow of the incidents base table; used to record pre-merge values.
  • HZ_MERGE_BATCH: The TCA merge batch table that identifies the parties and merge set being processed.
  • PLITBLM: The standard Oracle PL/SQL table-of-rows mechanism used to pass batches of identifiers between the caller and the incremental merge routines.

Usage Notes

CS_SR_PARTY_MERGE_PKG is not invoked directly from a user interface. It is called by the Party Merge concurrent program through the TCA merge framework, which delegates Service-owned entities to CS_PARTYMERGE_PKG; that package in turn invokes the incremental and audit routines here. Customizations should not call this package directly, as its procedures assume the caller has already established the merge context (registry entries in HZ_MERGE_BATCH, active batch identifier, and commit scope). Because the incremental routines operate on all affected rows in a single pass, execution is typically performed during the merge validation and execution phases, with the audit routines ensuring that an undo record exists before the surviving party identifier is committed to the Service tables.