Search Results csp_cmerge_bb1




Overview
Explore in AI Chat

Overview

APPS.CSP_CMERGE_BB1 is a customer merge processing package within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments. It operates under the CSP module, which historically relates to the customer relationship management and field service data model, and is registered with an API classification of OTHER rather than as a public or private API. The package declares AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking schema rather than the definer, a common characteristic of internal merge engine components that are invocable from concurrent processing contexts.

The business purpose of this package is to serve as the designated merge block for the CS_ACCESS_CONTROL_TEMPLATES table. In EBS, the customer merge process (the same framework that governs the merge of duplicate customer, contact, and address records) allows an administrator to consolidate a source party into a destination party. When a customer or party is merged, data held in dependent tables must be re-pointed, de-duplicated, or removed. CSP_CMERGE_BB1 encapsulates the table-specific logic for access control templates, ensuring that template ownership records remain consistent afterward.

Key Procedures and Functions

The package exposes a single documented procedure: MERGE. The header comment identifies it as the main block for merging the CS_ACCESS_CONTROL_TEMPLATES table. Its role is orchestration rather than direct row manipulation; it invokes an internal merge procedure that in turn dispatches a defined call sequence of subordinate merge and validation procedures. The documented call order is as follows:

This sequence indicates that the merge block handles installation site and ship-use identifiers for both system and counterparty (CP) contexts before resolving the primary customer identifier, and finishes with a data validation step. The final check confirms that no orphaned or conflicting records remain before the merge transaction completes. No parameter lists are documented in the available metadata beyond the procedure signature, and none are inferred here.

Tables Accessed

The primary table processed by this package is CS_ACCESS_CONTROL_TEMPLATES, referenced explicitly in the package header as the merge target. The ETRM metadata further lists RA_CUSTOMER_MERGES as a table accessed through APPS synonyms. RA_CUSTOMER_MERGES is the central audit table of the Oracle Receivables customer merge facility; it records the relationship between a source customer and a destination customer for each merge run. Read access to this table supplies the merge context — the run identifier and party identifiers — that the block needs in order to locate and update the corresponding access control template rows.

Usage Notes

CSP_CMERGE_BB1 is not intended for direct invocation by end users. It is a subordinate block invoked by the EBS customer merge engine when a merge request that includes access control templates is processed. The typical entry point is the Customer Merge concurrent program or the merge submission form, which collates all registered merge blocks — one per affected table — and calls each in sequence within a single logical transaction. The metadata records that this package is referenced by one other package, consistent with its role as a called component rather than an entry point.

Because the package is classified as OTHER and audited under the same $Header revision lineage since release 11.5, customizations should not modify it directly. Extensions affecting access control template data during merges are better implemented through supported table handlers or by registering additional merge blocks, preserving upgrade safety across 12.1.1 and 12.2.2.