Search Results fv_interagency_funds




Overview
Explore in AI Chat

Overview

The concurrent program FVIAUPDB, presented to users under the name Update Interagency Transfers, is a component of the FV – Federal Financials product family within Oracle E-Business Suite. Its documented purpose is to update the FV_INTERAGENCY_FUNDS table, the Federal Financials repository that stores interagency fund, transfer, and trading partner information used in intra-governmental transactions and IPAC processing. In practice, this program is the batch maintenance driver behind the interagency funds data set, reconciling or refreshing records so that agency-to-agency activity reflects current transfer detail. It is enabled in the documented 12.2.2 metadata set and is equally applicable in the 12.1.1 environment, where Federal Financials interagency functionality follows the same architectural pattern.

Execution Details

The ETRM metadata records the following execution characteristics for FVIAUPDB:

  • Execution Method: PL/SQL Stored Procedure
  • Argument Method: Standard
  • Executable: FVIAUPDB
  • Execution Filename: FV_IPAC_DISBURSEMENT_PKG.UPD_IA_MAIN
  • Subroutine Name: (not defined)
  • Enabled: Yes

The entry point is the package procedure UPD_IA_MAIN within FV_IPAC_DISBURSEMENT_PKG, the same package that supports Interagency Payment and Collection (IPAC) disbursement processing. Because the program calls a stored procedure rather than a report or SQL*Plus script, submission runs on the concurrent manager in the usual manner, with logging and completion status captured through the standard concurrent request mechanism. The Standard argument method indicates that the program accepts its parameters directly as concurrent program arguments rather than mapping them through a report parameter or token list.

How to Run

Users submit FVIAUPDB from the Submit Requests (SRS) window, typically via the Federal Financials responsibility. The program is selected by its user-facing name, Update Interagency Transfers, under the appropriate request group. Because the metadata documents a Standard argument method, the request form may display a small set of predefined parameters; these normally identify the processing scope for the update, such as the relevant set of books or ledger, a date or period range, and possibly a trading partner or agency identifier. Consult the program’s parameter list in the concurrent program definition for the exact names and validation, as the ETRM excerpt does not enumerate them.

Recommended operating practice is to run the program during a low-activity window, since it writes to the FV_INTERAGENCY_FUNDS table and can be affected by concurrent IPAC or interagency activity. Review the concurrent request log and output after completion, and verify table updates before downstream reconciliation or reporting processes execute.

Related Objects

The program operates within the interagency and IPAC processing chain in Federal Financials. Commonly associated objects include:

  • FV_INTERAGENCY_FUNDS — the target table updated by this program.
  • FV_IPAC_DISBURSEMENT_PKG — the package containing the UPD_IA_MAIN entry point, shared with IPAC disbursement processing.
  • IPAC-related concurrent programs and requests that create or consume interagency transfer records, such as IPAC collection and disbursement update processes.
  • Federal Financials interagency reports and reconciliation queries that read FV_INTERAGENCY_FUNDS after the update runs.

Because FVIAUPDB modifies a core interagency table through a shared IPAC package, change control and testing should account for both the table and the package when patches are applied.