Search Results csi_systems_b_merge

Overview

The APPS.CSI_ACCT_MERGE_PKG package is a PL/SQL account merge utility within the Oracle E-Business Suite Install Base (CSI) module. Its principal business function is to support Oracle Trading Community Architecture (TCA) party and customer account merge operations by propagating merged party and account identifiers into the CSI (Install Base) transactional and instance-level data model. When two parties or customer accounts are combined through the TCA customer merge process, downstream Install Base records that still reference the surviving or obsolete account identifiers must be reconciled. This package performs that reconciliation by processing CSI-owned entities such as item instances, systems, IP accounts, party accounts, and transaction systems against the surviving merged account.

Because the package is declared AUTHID CURRENT_USER, it executes with the privileges of the calling schema, and it is owned by the APPS schema. The ETRM classification for this object is OTHER, indicating a utility or helper package rather than a formal public API.

Key Procedures and Functions

The documented interface exposes six procedures, each of which accepts a request identifier, a set number, and a process mode. These parameters collectively define the scope of a merge run and the operating mode under which it executes.

• MERGE — The principal driver procedure. It likely orchestrates the overall account merge activity for a given request and set, coordinating the entity-specific procedures.
• CSI_ITEM_INSTANCES_MERGE — Handles merge processing for Install Base item instance records, updating account references to reflect the surviving party or account.
• CSI_SYSTEMS_B_MERGE — Performs merge reconciliation for the base systems entity, addressing system records that reference merged account identifiers.
• CSI_IP_ACCOUNTS_MERGE — Reconciles Install Base IP account records affected by the account merge.
• CSI_T_PARTY_ACCOUNTS_MERGE — Processes the CSI party accounts relationship records that link Install Base entities to TCA party accounts.
• CSI_T_TXN_SYSTEMS_MERGE — Handles merge updates for the transaction systems association records.

The package also declares a global variable, g_debug_on, initialized from the profile option CSIDEBUGLEVEL. This is the object relevant to the user's search term "csidebuglevel" — the variable is set at package load time using fnd_profile.value('CSIDEBUGLEVEL'), converting the value to a number and defaulting to zero when no value is present. This enables diagnostic tracing behavior within the package when the profile option is configured above zero.

Tables Accessed

The package reads and writes a defined set of Install Base and TCA tables, accessed through APPS synonyms.

• CSI_IP_ACCOUNTS, CSI_ITEM_INSTANCES — Core Install Base entities updated during the merge.
• CSI_I_PARTIES, CSI_T_PARTY_ACCOUNTS — Party relationship records reconciled to the surviving party account.
• CSI_SYSTEMS_B, CSI_SYSTEMS_H, CSI_SYSTEMS_H_S — Systems base and history records affected by account changes.
• CSI_TRANSACTIONS, CSI_TRANSACTIONS_S, CSI_TXN_TYPES, CSI_T_TXN_SYSTEMS — Transaction and transaction-type associations updated to reflect the merge.
• HZ_CUSTOMER_MERGE_LOG, HZ_CUSTOMER_MERGE_LOG_S — TCA merge log tables that record and drive the merge request context.
• HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL — TCA customer account and site references used to resolve the merged account identity.

Usage Notes

The package is typically invoked as part of the Oracle TCA customer merge concurrent process, where the customer merge framework invokes CSI merge handlers to update Install Base data. It may also be called from custom PL/SQL code that performs account consolidation. The request identifier, set number, and process mode parameters govern batching and the scope of updates. Because the package is referenced by zero other packages per the ETRM metadata, it functions as a dependent handler rather than a shared utility. Administrators should verify the CSIDEBUGLEVEL profile setting when diagnosing merge behavior, since the package's debug flag derives directly from that profile.