Search Results distribution_line_amount




Overview
Explore in AI Chat

Overview

FV_INVOICE_DTL_V is a denormalized reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents a consolidated picture of Payables invoice header, line, and distribution-level detail in a single row per distribution line, joining invoice attributes to their corresponding accounting distributions. For functional and technical consultants, the view provides a convenient read-only access path into the Payables transaction model without requiring them to reconstruct the multi-table joins spanning AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, and AP_INVOICE_DISTRIBUTIONS_ALL manually.

The view is registered in FND Design Data under the product short name FV (which relates to the Payables/Public Sector invoice functionality family) and carries a status of VALID. It is documented as Oracle Internal Use Only: Oracle Corporation does not support access to this object except from standard Oracle Applications programs. Consequently, custom code, reports, or integrations that query FV_INVOICE_DTL_V directly do so at their own risk with respect to upgrade safety and support. Where possible, standard published APIs and interface tables should be preferred for write operations; read-only queries for reporting are the typical usage pattern.

Underlying Base Objects

According to the documented dependency list, FV_INVOICE_DTL_V references the following base objects:

  • AP_INVOICES_ALL – the core Payables invoice header table, providing invoice number, date, type, amount, status, and vendor references.
  • AP_INVOICE_LINES_ALL – invoice line detail, supplying line number, line amount, description, and PO line/location linkage.
  • AP_INVOICE_DISTRIBUTIONS_ALL – distribution lines that carry the accounting and amount splits, including distribution line number and distribution line amount.
  • AP_INVOICES_PKG – the Payables invoice package, referenced here for derived logic (for example, status or amount computations).
  • AP_INVOICES_UTILITY_PKG – utility package referenced for supporting calculations used in the view definition.

The view is not referenced by any other database object, confirming it is a terminal reporting object rather than a building block in a larger dependency chain. The dependency architecture means that any change to the underlying AP tables or packages can affect the view's output, so consumers should treat it as version-coupled to the Payables data model.

Key Columns

The view exposes the following documented columns:

The user's search term, distribution_line_amount, maps directly to the DISTRIBUTION_LINE_AMOUNT column, which is the amount allocated to each accounting distribution derived from AP_INVOICE_DISTRIBUTIONS_ALL.

Common Use Cases and Queries

A frequent use case is reconciling invoiced amounts against distributed amounts to detect mismatches or unposted distributions. The following sample query returns distribution detail for a given invoice:

  • SELECT INVOICE_NUM, INVOICE_LINE, DISTRIBUTION_LINE_NUMBER, DISTRIBUTION_LINE_AMOUNT, INVOICE_LINE_AMOUNT, VENDOR_ID FROM APPS.FV_INVOICE_DTL_V WHERE INVOICE_ID = :p_invoice_id ORDER BY INVOICE_LINE, DISTRIBUTION_LINE_NUMBER;
  • SELECT INVOICE_ID, INVOICE_NUM, SUM(DISTRIBUTION_LINE_AMOUNT) FROM APPS.FV_INVOICE_DTL_V GROUP BY INVOICE_ID, INVOICE_NUM ORDER BY INVOICE_ID;

These patterns are useful for audit reports, ETL extracts into custom data warehouses, and investigative troubleshooting where a consultant needs a quick flat view of invoice distribution amount detail without writing multi-table joins. Because the object is unsupported for direct external access, any production use should be reviewed against upgrade strategy and documented as a risk.