Search Results fv_treasury_payments_pkg




Overview
Explore in AI Chat

Overview

The APPS.FV_TREASURY_PAYMENTS_PKG package is a treasury payment processing component within the Oracle E-Business Suite Federal Financials (FV) module. It supports the U.S. federal treasury payment lifecycle by managing the confirmation of payments scheduled against treasury confirmations and by processing the voiding of treasury checks. In the Oracle EBS 12.1.1 and 12.2.2 environments, this package serves as the procedural backbone behind the Treasury Confirmation and Treasury Void workflows used by federal agencies to reconcile disbursements with the Department of the Treasury.

The package is owned by the APPS schema and is classified as an "OTHER" API in the ETRM metadata (last modified in the 2006 header revision 120.1). Unlike a formal public API, it is primarily an internal engine invoked through concurrent programs and Oracle Forms rather than through external integration hooks; it is referenced by zero other packages per the ETRM metadata.

Key Procedures and Functions

The package exposes two documented procedures, both following the standard EBS concurrent program signature of X_errbuf OUT NOCOPY and X_retcode OUT NOCOPY:

  • MAIN — The primary driver of the package. It accepts a treasury confirmation identifier and a button name parameter, indicating it is invoked contextually (typically from an Oracle Form or concurrent request) to process treasury payment confirmations. It orchestrates validation of the confirmation, selection of eligible payments, and the recording of confirmation results.
  • VOID — Handles the voiding of treasury payments and checks. It processes the reversal of previously issued payments and records the voided check details in the appropriate treasury void tables. The standard error buffer and return code parameters allow it to be launched as a concurrent program or called programmatically.

No function-level parameter lists beyond these are documented; the metadata confirms only the signatures above.

Tables Accessed

The package reads and writes an extensive set of AP and FV tables through APPS synonyms:

Usage Notes

In Oracle EBS 12.1.1 and 12.2.2, this package is typically invoked from the Federal Treasury Confirmation form and the Treasury Void form, and it can also be registered as a concurrent program because of its standard X_errbuf/X_retcode signature. The MAIN procedure's P_button_name parameter indicates it responds to specific form button actions. Because the ETRM classification is "OTHER" and no other packages reference it, it should be treated as an internal, non-public API; customization should avoid direct calls unless the invoking form logic and selection criteria are fully replicated. Its writes to GL_INTERFACE and the FV_TREASURY_CONFIRMATIONS tables mean it participates directly in the financial close cycle.