Search Results fv_refunds_voids_all

Overview

The FV_REFUNDS_VOIDS_ALL table is a core data repository within the Oracle E-Business Suite Federal Financials (FV) module, specifically for releases 12.1.1 and 12.2.2. Its primary function is to store and manage transactional information related to refunds, voids, and chargebacks on invoices. This data is essential for generating the U.S. federal government's FMS Form 224 report, a critical financial statement used for reporting undisbursed appropriations. The table operates at the multi-organization level, as indicated by the "_ALL" suffix, meaning it stores data across all operating units within an installation. It serves as a central junction, integrating key transactional identifiers from Payables (AP), Receivables (AR), and Purchasing modules to provide a consolidated view of these specific financial adjustments.

Key Information Stored

The table's structure is defined by its foreign key relationships, which highlight the critical data points it stores. Each record links a specific financial adjustment to its source documents. The key columns include INVOICE_ID, which references the original AP_INVOICES_ALL record being refunded or voided. The CASH_RECEIPT_ID links to the AR_CASH_RECEIPTS_ALL table for any associated receipt activity, while CHECK_ID connects to the AP_CHECKS_ALL table to identify the specific payment instrument involved. The VENDOR_ID column references PO_VENDORS, identifying the supplier party to the transaction. Furthermore, the SET_OF_BOOKS_ID links to GL_SETS_OF_BOOKS_11I, anchoring the transaction to the correct ledger for financial reporting and accounting integrity. These relationships collectively store the metadata necessary to trace the lifecycle of a refund, void, or chargeback.

Common Use Cases and Queries

The predominant use case is the generation and reconciliation of data for the FMS Form 224 report. Financial analysts and federal reporters run queries against this table to aggregate adjustment amounts by appropriation, vendor, or fiscal period. A typical query pattern involves joining this table to its referenced source tables to pull a complete dataset. For example, to analyze all refunds for a specific vendor in a given ledger, one might use a SQL pattern such as:

• SELECT rv.*, a.invoice_num, v.vendor_name
• FROM fv.fv_refunds_voids_all rv,
• ap.ap_invoices_all a,
• po.po_vendors v
• WHERE rv.invoice_id = a.invoice_id
• AND rv.vendor_id = v.vendor_id
• AND rv.set_of_books_id = :ledger_id
• AND v.vendor_id = :supplier_id;

Technical consultants may also query this table to troubleshoot missing data in the Form 224 output or to validate the integrity of transactional links during month-end close processes.

Related Objects

The FV_REFUNDS_VOIDS_ALL table is a central hub with defined dependencies on several key transactional tables, as documented in its foreign keys. Primary related objects include AP_INVOICES_ALL (source invoice), AR_CASH_RECEIPTS_ALL (associated receipt), and AP_CHECKS_ALL (payment check). It also relies on master data from PO_VENDORS (supplier) and GL_SETS_OF_BOOKS_11I (accounting ledger). While not explicitly listed in the provided metadata, this table is directly consumed by the application logic and database views that underpin the FMS Form 224 reporting functionality within the Federal Financials module. Any custom interfaces or extensions that process refund or void data for federal reporting would also likely reference this table.