Search Results fv_invoice_finance_chrgs

Overview

FV_CMERGE is a PL/SQL package body owned by the APPS schema that supports customer merge processing within the Oracle E-Business Suite Financials for Government (Federal) product family. Its central purpose is to consolidate and reassign Federal financial data—specifically customer finance charges, interagency funds, interim cash receipts, invoice finance charges, and Intra-Governmental Payment and Collection (IPAC) transactions—from a source customer to a target customer when two customer records are merged using Oracle Receivables' customer merge facility. The package acts as the Federal extension of the standard Receivables merge framework, ensuring that EBS Federal sub-ledger tables remain referentially consistent after a customer merge. The package is classified as VALID in the documented environments (12.1.1 and 12.2.2) and carries an API classification of OTHER, meaning it is an internal utility rather than a public, supported extension API.

Key Procedures and Functions

The documented package metadata identifies a single program unit: the procedure MERGE. Consistent with the standard Receivables customer merge architecture, MERGE is the entry point invoked to migrate Federal customer-related records from the merge source to the merge target. It coordinates the financial charge, interagency fund, interim cash receipt, invoice finance charge, and IPAC transaction reassignments required to complete the merge cleanly. The package additionally relies on internal helper objects and utilities—notably FV_UTILITY for Federal-specific processing logic, HZ_ACCT_MERGE_UTIL and HZ_UTILITY_PUB for Trading Community Architecture merge operations, and ARP_STANDARD and ARP_MESSAGE for Receivables messaging and error handling conventions. Because only the MERGE signature is documented at the package level, no parameter lists are published here; callers should not assume a public API contract, as the procedure is designed for internal orchestration.

Tables Accessed

The package references a well-defined set of Federal and Receivables tables through APPS synonyms. Customer finance charge data is handled in FV_CUST_FINANCE_CHRGS and its _ALL variant, while invoice-level finance charges are handled in FV_INVOICE_FINANCE_CHRGS and FV_INVOICE_FINANCE_CHRGS_ALL. Interagency fund records are managed in FV_INTERAGENCY_FUNDS and FV_INTERAGENCY_FUNDS_ALL, interim cash receipts in FV_INTERIM_CASH_RECEIPTS and FV_INTERIM_CASH_RECEIPTS_ALL, and IPAC transactions in FV_IPAC_TRX and FV_IPAC_TRX_ALL. Cross-reference data resides in FV_CUST_VEND_XREFS. Merge auditing and control information is read from and written to RA_CUSTOMER_MERGES, RA_CUSTOMER_MERGE_HEADERS, HZ_CUSTOMER_MERGE_LOG, and HZ_CUSTOMER_MERGE_LOG_S. Collectively these tables represent the Federal financial footprint that must be re-pointed from the source customer to the target customer during a merge, preserving transactional history and reporting integrity.

Usage Notes

FV_CMERGE is not referenced by any other database object and is not intended for direct invocation by custom code. It is exercised transparently when a customer merge is performed through the Receivables customer merge forms or the associated customer merge concurrent program, which orchestrates the various product-specific merge handlers. During such processing, FV_CMERGE performs the Federal-side updates after the standard TCA/Receivables merge steps, using FND_PROFILE and FND_LOG for profile option lookups and debug logging. Because the package is classified as OTHER and its procedures are internal, developers should avoid calling MERGE directly; instead, they should drive merges through the supported Oracle customer merge interfaces. Any troubleshooting of merge-related Federal data discrepancies should focus on the documented dependency tables—especially the _ALL finance charge, interagency fund, interim cash receipt, and IPAC tables—and on the HZ and RA customer merge log tables that record merge activity.