Search Results fv_interagency_funds_u2

Overview

The FV.FV_INTERAGENCY_FUNDS_ALL table is an Oracle E-Business Suite Federal Financials (FV) object that stores interagency transaction information used to support the FMS Form 224 Statement of Transactions report and the SF 1081 Voucher and Schedule of Withdrawals and Credit process. In Oracle EBS 12.1.1 and 12.2.2, this table acts as the persistence layer for interagency activity flowing between agencies, capturing both invoice-driven and receipt-driven transactions that must be reported to Treasury. The table resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10, and its three unique indexes reside in APPS_TS_TX_IDX.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign-key structure is a link table. This suggestion reflects that the row's identity is largely defined by the business relationships it connects: a vendor/invoice pairing and a cash-receipt/customer pairing, tied back to a set of books. It serves as an intersection-style record joining procurement, receivables, and accounting dimensions rather than acting as an independent hub of descriptive attributes.

Key Information Stored

The surrogate primary key is INTERAGENCY_FUND_ID (NUMBER(15)), enforced by the unique index FV_INTERAGENCY_FUNDS_U1. Two documented business-key candidates exist beyond the surrogate key. FV_INTERAGENCY_FUNDS_U2 enforces uniqueness on (VENDOR_ID, INVOICE_ID), while FV_INTERAGENCY_FUNDS_U3 enforces uniqueness on (CASH_RECEIPT_ID, CUSTOMER_ID). These two composite keys correspond directly to the "fv_interagency_funds_u2" search term, making U2 the invoice-side business key.

• SET_OF_BOOKS_ID — Set of Books identifier, scoping each row to a ledger.
• PROCESSED_FLAG — Indicates whether the record was reported on FMS Form 224.
• CHARGEBACK_FLAG — Check-box flag indicating the record is a chargeback.
• VENDOR_ID / VENDOR_NAME — Agency identifier corresponding to the invoice, with descriptive name.
• INVOICE_ID / INVOICE_NUMBER — Supplier invoice reference.
• CASH_RECEIPT_ID / RECEIPT_NUMBER — Cash receipt reference.
• CUSTOMER_ID / CUSTOMER_NAME — Customer (agency) identifier and name.
• BILLING_AGENCY_FUND — Fund designation of the billing agency.
• PERIOD_REPORTED — Reporting period associated with the transaction.
• ORG_ID — Operating unit identifier supporting multi-org access.
• Standard Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN — plus fifteen ATTRIBUTE columns and ATTRIBUTE_CATEGORY for extensibility.

Common Use Cases and Queries

The primary use case is FMS Form 224 Statement of Transactions reporting and SF 1081 voucher processing. Typical queries filter unreported rows using PROCESSED_FLAG, then aggregate by reporting period and set of books. The composite index FV_INTERAGENCY_FUNDS_U2 supports lookups by vendor and invoice, which is the natural access path when reconciling interagency invoices against AP.

A representative reporting query groups transactions by ledger and period:

• SELECT SET_OF_BOOKS_ID, PERIOD_REPORTED, COUNT(*) FROM FV_INTERAGENCY_FUNDS_ALL WHERE PROCESSED_FLAG = 'N' GROUP BY SET_OF_BOOKS_ID, PERIOD_REPORTED;
• SELECT INTERAGENCY_FUND_ID, VENDOR_NAME, INVOICE_NUMBER, BILLING_AGENCY_FUND FROM FV_INTERAGENCY_FUNDS_ALL WHERE VENDOR_ID = :vendor_id AND INVOICE_ID = :invoice_id;
• SELECT a.INVOICE_NUMBER, r.RECEIPT_NUMBER, f.CHARGEBACK_FLAG FROM FV_INTERAGENCY_FUNDS_ALL f, AP_INVOICES_ALL a, AR_CASH_RECEIPTS_ALL r WHERE f.INVOICE_ID = a.INVOICE_ID AND f.CASH_RECEIPT_ID = r.CASH_RECEIPT_ID;

Related Objects

The documented foreign keys define the principal joins from this link table:

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

These four references connect the object to payables, receivables, general ledger, and supplier master data, confirming its role as a cross-functional interagency reporting link within the Federal Financials application.