Search Results fv_invoice_returns_all




Overview
Explore in AI Chat

Overview

FV_INVOICE_RETURNS_ALL is a Federal Financials (FV) module table within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments. It stores information about invoices that have been returned, and this data is consumed as part of the Payables due date calculation process. The table resides in the FV schema and is classified as VALID in the ETRM repository. Functionally, it captures the subset of supplier invoices whose return status influences how payment due dates are derived, making it a supporting reference table rather than a transactional driver. When a returned invoice is recorded, its identifying attributes, vendor context, and financial amounts are persisted here so that downstream due date logic, federal payment terms enforcement, and reporting can evaluate the return event against the original invoice.

From a dimensional modeling perspective, the metadata's heuristic Data Vault classification is link. This suggests the table behaves as an associative structure connecting multiple business entities—invoices, vendors, vendor sites, and accounting sets-of-books—rather than acting as an independent hub or a descriptive satellite. Analysts designing warehouse or integration models should treat FV_INVOICE_RETURNS_ALL as a relationship-bearing object that resolves references across the Payables and Federal Financials domains.

Key Information Stored

The documented physical schema contains 27 columns, with INVOICE_ID serving as the primary key through FV_INVOICE_RETURNS_ALL_PK and also as the unique index candidate (FV_INVOICE_RETURNS_ALL_U1). The most significant columns are:

Common Use Cases and Queries

Typical scenarios include reconstructing why a given invoice received a particular due date, reconciling returned invoices against their Payables records, and reporting on returns by vendor or ledger. A representative query joins the table to AP_INVOICES_ALL:

  • SELECT r.INVOICE_ID, r.INVOICE_NUM, r.INVOICE_AMOUNT, r.VENDOR_ID, r.SET_OF_BOOKS_ID FROM FV.FV_INVOICE_RETURNS_ALL r WHERE r.ORG_ID = :p_org_id;
  • Vendor-level analysis: join to PO_VENDORS on VENDOR_ID to aggregate returned invoice amounts by supplier.
  • Ledger reconciliation: join to GL_SETS_OF_BOOKS_11I on SET_OF_BOOKS_ID to group returns by accounting book.
  • Site-level reporting: join to PO_VENDOR_SITES_ALL on VENDOR_SITE_ID to isolate returns by remit-to location.
  • Flexfield extraction: query ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 for client-specific return reasons or federal classification codes.

Related Objects

The FK metadata identifies four referenced parent tables, and these form the primary integration surface:

  • AP_INVOICES_ALL — Joined on INVOICE_ID; the master invoice record.
  • PO_VENDORS — Joined on VENDOR_ID; supplier master.
  • PO_VENDOR_SITES_ALL — Joined on VENDOR_SITE_ID; supplier site master.
  • GL_SETS_OF_BOOKS_11I — Joined on SET_OF_BOOKS_ID; ledger definition.

Because due date calculation is the stated purpose, related Payables objects such as AP payment terms and AP invoice payment schedules are functionally dependent on this data, although no direct FK is documented for them. Federal Financials reporting views and concurrent programs that evaluate return-driven due dates also consume this table indirectly.