Search Results fv_interagency_funds_all




Overview
Explore in AI Chat

Overview

The FV_INTERAGENCY_FUNDS_ALL table resides in the FV (Federal Financials) schema of Oracle E-Business Suite and serves as the central repository for interagency transaction information in federal accounting environments. Interagency transactions occur when one federal agency acquires goods or services from another federal agency, requiring specific tracking and reconciliation to comply with U.S. Treasury and OMB reporting requirements. In the context of Oracle EBS 12.1.1 and 12.2.2, this table captures the linkage between payable-side records (invoices from vendors acting as servicing agencies) and receivable-side records (cash receipts), enabling agencies to reconcile intra-governmental transactions and eliminate them during government-wide financial consolidation.

The heuristic Data Vault classification mined from the foreign key structure is link. This modeling suggestion reflects the table's role as an associative entity that connects independent business hubs — invoices, cash receipts, vendors, and sets of books — through foreign key references rather than storing descriptive master data itself. The table is owned by the FV schema, holds 36 documented columns, and is identified by primary key constraint FV_INTERAGENCY_FUNDS_PK on the INTERAGENCY_FUND_ID column.

Key Information Stored

The surrogate primary key is INTERAGENCY_FUND_ID, a system-generated identifier that uniquely distinguishes each interagency record. Beyond the surrogate key, three unique indexes identify business-key candidates: FV_INTERAGENCY_FUNDS_U1 on INTERAGENCY_FUND_ID, FV_INTERAGENCY_FUNDS_U2 on the VENDOR_ID and INVOICE_ID combination, and FV_INTERAGENCY_FUNDS_U3 on the CASH_RECEIPT_ID and CUSTOMER_ID combination. These composite keys reinforce the table's role in pairing payable and receivable interagency activity.

The most significant columns include:

  • SET_OF_BOOKS_ID — identifies the ledger in which the interagency activity is recorded.
  • INVOICE_ID and INVOICE_NUMBER — reference the AP invoice representing the payable side.
  • CASH_RECEIPT_ID and RECEIPT_NUMBER — reference the AR cash receipt representing the receivable side.
  • VENDOR_ID and VENDOR_NAME — identify the servicing agency acting as vendor.
  • CUSTOMER_ID and CUSTOMER_NAME — identify the trading partner on the receivable side.
  • BILLING_AGENCY_FUND — the Treasury fund symbol associated with the billing agency.
  • PERIOD_REPORTED — the reporting period for which the interagency activity is disclosed.
  • PROCESSED_FLAG and CHARGEBACK_FLAG — status indicators for reconciliation processing and chargeback handling.
  • ORG_ID — operating unit identifier supporting multi-org access control.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield storage for agency-specific extensions.

Standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) track record lifecycle.

Common Use Cases and Queries

Federal agencies rely on this table to produce the Treasury Report on Receivables, reconcile intra-governmental transactions for the Financial Report of the United States Government, and support chargeback processing between trading partners. A representative query retrieves unreconciled interagency pairs for a given ledger:

  • SELECT i.INTERAGENCY_FUND_ID, i.INVOICE_NUMBER, i.RECEIPT_NUMBER, i.VENDOR_NAME, i.CUSTOMER_NAME, i.BILLING_AGENCY_FUND, i.PERIOD_REPORTED FROM FV.FV_INTERAGENCY_FUNDS_ALL i WHERE i.SET_OF_BOOKS_ID = :ledger_id AND i.PROCESSED_FLAG = 'N';
  • Joining to AP_INVOICES_ALL on INVOICE_ID surfaces invoice detail for payable-side reporting.
  • Joining to AR_CASH_RECEIPTS_ALL on CASH_RECEIPT_ID yields receivable detail for trading-partner reconciliation.
  • Filtering by PERIOD_REPORTED supports quarterly and annual intra-governmental disclosure extracts.

Related Objects

The foreign key structure defines the table's principal dependencies:

  • AP_INVOICES_ALL — joined on FV_INTERAGENCY_FUNDS_ALL.INVOICE_ID.
  • AR_CASH_RECEIPTS_ALL — joined on FV_INTERAGENCY_FUNDS_ALL.CASH_RECEIPT_ID.
  • GL_SETS_OF_BOOKS_11I — joined on FV_INTERAGENCY_FUNDS_ALL.SET_OF_BOOKS_ID.
  • PO_VENDORS — joined on FV_INTERAGENCY_FUNDS_ALL.VENDOR_ID.

These relationships confirm the table's function as a reconciliation link spanning Oracle Payables, Oracle Receivables, Oracle General Ledger, and Oracle Purchasing within the Federal Financials product suite. Reporting extracts typically traverse all four parent objects to construct complete interagency trading partner statements.