Search Results fv_cmerge




Overview
Explore in AI Chat

Overview

FV_CMERGE is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM repository as an "OTHER" API. Its name and dependency profile identify it as the customer merge utility for the Federal Financials (FV) product family. Federal Financials extends standard Oracle Receivables and Payables functionality for U.S. government agencies, and its transaction tables carry party, customer, and vendor references that must remain consistent when two customer records are combined through the standard Oracle Receivables customer merge process.

The package therefore serves the business function of propagating a customer merge across Federal Financials–specific data. When a duplicate customer is merged into a surviving customer, the interim cash receipts, IPAC transactions, interagency fund records, customer finance charges, and customer–vendor cross-references held in FV tables still point at the obsolete customer identifier. FV_CMERGE reconciles those records so that historical and open federal transactions report against the correct party after the merge completes.

Key Procedures and Functions

The ETRM metadata for release 12.2.2 documents a single subprogram:

  • MERGE — The sole documented procedure in the package. It performs the merge-driven update of Federal Financials records, reassigning the affected rows from the source (duplicate) customer to the target (surviving) customer. Parameter lists are not published in the metadata and should be verified against the installed package specification in the target environment.

Tables Accessed

All tables are accessed through APPS synonyms. The following are documented:

The "_ALL" variants indicate that the package respects the multi-org (Operating Unit) architecture, updating both the base table and its organization-specific counterpart.

Usage Notes

FV_CMERGE is an internal utility and is not referenced by any other package in the documented dependency set, nor is it exposed as a public API. It is invoked indirectly through the Oracle Receivables customer merge facility whenever the Federal Financials application is installed, forming part of the row-handler logic that the merge process calls to cleanse product-specific tables. It should not be called directly from custom code; the supported entry point remains the standard customer merge program in Receivables. Sites performing a merge should ensure no open FV transactions are in flight, verify that the merge log tables are accessible, and review Federal Financials records afterward to confirm that all party references were successfully transferred.