Results for “fv_invoice_master_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FV_INVOICE_MASTER_V is a seeded, read-only database view in the APPS schema belonging to the Federal Financials (FV) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It is defined to retrieve invoice header details for display in the Document Cross-Reference form, which is used by federal agencies to associate accounts payable documents with the corresponding budgetary and accounting records. Rather than storing data itself, the view exposes a curated projection of Payables invoice header information, presented in a form suitable for lookup, reporting, and integration consumption.

The view is widely referenced in reporting because it resolves several raw code columns into human-readable values. Notably, the PAYMENT_STATUS_FLAG column is decoded into descriptive text, and the columns expose approval, hold, and payment state in a single row per invoice. This makes it particularly convenient for federal financial reporting, reconciliation extracts, and downstream interfaces that need a consolidated invoice-status snapshot without joining multiple reference tables.

Underlying Base Objects

According to ETRM metadata, the view is defined over three documented base objects:

• AP_INVOICES (accessed via a synonym) — the primary source table supplying invoice header attributes such as invoice number, date, amount, type, and status flags.
• AP_INVOICES_PKG (package) — invoked through GET_APPROVAL_STATUS to derive the approval status of the invoice at query time.
• AP_INVOICES_UTILITY_PKG (package) — invoked through GET_HOLDS_COUNT to return the number of active holds on the invoice.

The view filters the base table to exclude certain invoice types. The WHERE clause restricts rows to invoices whose INVOICE_TYPE_LOOKUP_CODE is not QUICKDEFAULT or QUICKMATCH, eliminating quick-invoice variants that are irrelevant to the Document Cross-Reference context.

Key Columns

• INVOICE_ID — Primary key of the invoice; used to join to distributions, lines, and accounting entries.
• VENDOR_ID / VENDOR_SITE_ID — Supplier and supplier site identifiers.
• INVOICE_NUM — Supplier-assigned invoice number.
• INVOICE_DATE — Invoice date used for period and aging analysis.
• INVOICE_TYPE_LOOKUP_CODE — Standard, credit, prepayment, or other invoice classification.
• INVOICE_AMOUNT — Gross invoice header amount.
• PAYMENT_STATUS_FLAG — Decoded into 'NOT PAID' (N), 'PARTIALLY PAID' (P), or 'FULLY PAID' (Y), providing immediate payment visibility.
• HOLD_STATUS — Derived from the holds count returned by AP_INVOICES_UTILITY_PKG.
• WFAPPROVAL_STATUS — Workflow-based approval state of the invoice.
• PAY_GROUP_LOOKUP_CODE — Pay group associated with payment scheduling.
• STATUS — Approval status derived by AP_INVOICES_PKG.GET_APPROVAL_STATUS.

Common Use Cases and Queries

A frequent requirement is to identify unpaid or partially paid invoices for a vendor. Because the view already decodes the payment status flag, queries are simplified:

• List all invoices that are not fully paid:

SELECT INVOICE_NUM, VENDOR_ID, INVOICE_AMOUNT, PAYMENT_STATUS_FLAG, HOLD_STATUS, STATUS FROM APPS.FV_INVOICE_MASTER_V WHERE PAYMENT_STATUS_FLAG IN ('NOT PAID','PARTIALLY PAID');

• Reconcile invoices against accounting entries by joining on INVOICE_ID to AP_INVOICE_DISTRIBUTIONS_ALL or AP_INVOICE_LINES_ALL.
• Produce a federal payment-status extract by filtering on PAY_GROUP_LOOKUP_CODE and invoice date range.
• Flag invoices with outstanding holds for exception reporting using HOLD_STATUS.

Because package functions are invoked per row, large-volume queries can incur performance overhead; filtering by invoice date, vendor, or ID is advisable. The view is read-only and should be consumed for inquiry and reporting rather than as a target for DML.