Search Results invoice_canceled_amount




Overview
Explore in AI Chat

Overview

APFV_AP_INVOICES is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its FND Design Data identifier is SQLAP.APFV_AP_INVOICES, and its status is VALID. The view is part of the Oracle Payables family of "APFV" reporting views, which are designed to present invoice data in a form suited to dimensional reporting, extraction, and integration rather than to support the transactional forms directly. As documented in the ETRM metadata, the view "shows information about invoices, which are documents containing details of charges to be remitted or deducted in a payment to a supplier." It flattens the header-level attributes of an invoice—amounts, dates, currency information, payment attributes, approval and cancellation state, and descriptive lookups—into a single wide row per invoice, making it convenient for ad hoc queries, data warehouse staging, and downstream reporting tools.

Because APFV_AP_INVOICES is a BI System view, it is intended for read-only consumption. The presence of pseudo-columns such as _LA:SOURCE_DESCRIPTON, _LA:INVOICE_TYPE_DESCRIPTION, _LA:PMT_STATUS_DESCRIPTION, and _DF reflects the Business Intelligence System's mechanism for resolving lookup descriptions and descriptive flexfield segments dynamically at query time.

Underlying Base Objects

The documented referenced base object for APFV_AP_INVOICES is AP_INVOICES, exposed through a synonym in the APPS schema. The view is effectively a projection and enrichment of the AP_INVOICES header table, adding translated lookup descriptions and flexfield-related columns. In practice, BIS views of this type may also join to lookup tables and flexfield views to populate the _LA: and _DF: columns, but the ETRM metadata lists AP_INVOICES as the primary base object. Consumers should treat the view as a logical superset of the invoice header, retaining the INVOICE_ID primary key that links back to AP_INVOICES and to related tables such as AP_INVOICE_LINES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, and AP_PAYMENT_SCHEDULES_ALL.

Key Columns

The view exposes a comprehensive set of invoice header attributes. Notable columns include:

Common Use Cases and Queries

APFV_AP_INVOICES is commonly used for supplier invoice reporting, approval and payment status tracking, and analysis of canceled or approved amounts. A representative query retrieving canceled invoice amounts is:

SELECT invoice_number,
       invoice_date,
       invoice_currency_code,
       invoice_approved_amount,
       invoice_canceled_amount,
       invoice_canceled_date,
       _LA:PMT_STATUS_DESCRIPTION
FROM   apps.apfv_ap_invoices
WHERE  invoice_canceled_amount IS NOT NULL
ORDER BY invoice_canceled_date DESC;

Aggregate reporting by supplier and period is also straightforward, for example summing INVOICE_FUNCTIONAL_AMOUNT and INVOICE_CANCELED_AMOUNT grouped by vendor and invoice date. Because the view is read-only and pre-joined to lookup descriptions, it is well suited to BI Publisher reports, OBIEE extracts, and custom data feeds that must avoid the complexity of joining many Payables lookup tables manually.