Search Results fv_apply_cash_receipt




Overview
Explore in AI Chat

Overview

The APPS.FV_APPLY_CASH_RECEIPT package is a public PL/SQL API within the Oracle E-Business Suite Financials family, owned by the APPS schema and declared with AUTHID CURRENT_USER. Its principal business function is to apply cash receipts to open receivables within the federal financials (FV) processing model. Unlike the standard Oracle Receivables AR_RECEIPT_API_PUB, which serves commercial receipt application, this package operates against the FV_AR_BATCHES and FV_INTERIM_CASH_RECEIPTS staging structures that support federal collections and appropriation accounting. The package header, sourced from FVXDCCRS.pls (version 120.3, dated 2003/05/16), exposes a single documented entry point, MAIN, and carries the module identifier g_PackageName set to 'fv_apply_cash_receipt'. The API classification in the ETRM is OTHER, indicating it is not a standard open-interface or business-object API but rather a functional driver, most likely invoked as a concurrent program to apply batches of interim cash receipts to customer accounts and payment schedules.

Key Procedures and Functions

The documented package interface contains one public procedure:

  • MAIN — The primary driver routine. Based on the standard concurrent-program parameter signature, MAIN accepts the EBS concurrent manager's error buffer and return code as OUT parameters, together with an IN parameter that identifies the batch to be processed (documented as p_batch_name). It orchestrates the application of cash receipts held in the interim and batch tables, drives the receipt application against open payment schedules, records the resulting receivable applications, and writes the outcome back through p_errbuf and p_retcode. No additional public procedures or functions are documented in the ETRM metadata.

Tables Accessed

The ETRM records sixteen tables referenced through APPS synonyms, which together describe the end-to-end receipt application flow:

Usage Notes

FV_APPLY_CASH_RECEIPT is typically invoked as an Oracle EBS concurrent program submitted through the Federal Financials responsibility, where the batch name is passed as a program parameter. The standard p_errbuf/p_retcode signature permits error reporting through the concurrent manager log and completion status. The ETRM records that the package is referenced by zero other packages, confirming it is a top-level entry point rather than a reusable library called by sibling APIs. Custom code should invoke MAIN only within an initialized EBS session (APPS context, FND_GLOBAL user and responsibility set) and should not rely on undocumented internal logic. Because the source header dates from release 11i-era code and the package operates directly on interim and batch tables, deployments on 12.1.1 and 12.2.2 should validate behavior against the installed file version, and any extension of the package should be performed through a supported wrapper rather than modification of the seeded body. Given its OTHER API classification, the interface is not guaranteed backward compatible across patches.