Search Results discount_lost




Overview
Explore in AI Chat

Overview

The view APPS.FII_AP_DISC_TOP_SUMMARY_V is a reporting object within the Oracle E-Business Suite Financials Intelligence (FII) schema, specifically associated with the Oracle Payables (AP) discount analysis subject area. Its purpose is to present a summarized, operating-unit-level rollup of supplier payment discount performance. The view answers a direct business question: how much early-payment discount value is at risk of being forfeited, and how much discount value has actually been lost within each operating unit. This makes it a natural landing point for Payables discount dashboards, "Discount Lost" alert reports, and period-close analyses used by treasury and accounts payable management.

The view name carries the _V suffix common to FII reporting views, which are typically declared in the application as views (often with a corresponding _VL or synonym treatment) so that BI Publisher, Oracle Business Intelligence Applications (OBIA), and custom concurrent programs can query them directly. Because it aggregates before presentation, it is intended for summary-level reporting rather than transaction-level drill-down.

Underlying Base Objects

The documented view definition selects exclusively from FII_AP_DISCOUNTS_SUMMARY, applying a GROUP BY on two dimensions:

  • operating_unit_pk_key
  • operating_unit_name

No other base objects are documented in the ETRM metadata for this view; the only referenced source is FII_AP_DISCOUNTS_SUMMARY. That underlying summary table supplies the transactional aggregates discount_available and discount_lost, which the view re-aggregates using SUM() to produce operating-unit totals.

In the 12.1.1 and 12.2.2 architecture, the FII_AP_DISCOUNTS_SUMMARY table is a pre-aggregated FII summary object rather than an OLTP Payables table such as AP_INVOICES_ALL or AP_PAYMENT_SCHEDULES_ALL. Consequently, the view inherits whatever refresh cadence, currency, and organizational security characteristics are applied to that summary table. It does not perform joins to the general ledger, suppliers, or invoice detail; it is a pure rollup.

Key Columns

  • OPERATING_UNIT_PK_KEY — the internal primary key of the operating unit, used for organizational partitioning and joins to operating unit dimension views.
  • OPERATING_UNIT_NAME — the human-readable operating unit name, suitable for report headings and grouping.
  • DISCOUNT_AT_RISK — aliases SUM(discount_available). This represents the total early-payment discount available at the operating-unit level, i.e., the discount value that could still be captured or forfeited.
  • DISCOUNT_LOST — aliases SUM(discount_lost). This represents the total discount value that was not taken, matching the user's search term discount_lost. It is the core metric for forfeited-discount reporting.

Note that each output column above is derived solely from aggregate expressions; there is no transaction-level identifier, invoice number, or supplier attribute exposed by this view.

Common Use Cases and Queries

The primary use case is identifying operating units with high discount leakage. A typical query retrieves the at-risk and lost totals per operating unit, optionally filtering on a particular unit:

  • Discount lost by operating unit — SELECT operating_unit_name, discount_at_risk, discount_lost FROM apps.fii_ap_disc_top_summary_v ORDER BY discount_lost DESC;
  • Single operating unit detail — SELECT * FROM apps.fii_ap_disc_top_summary_v WHERE operating_unit_pk_key = :org_id;
  • Leakage ratio — SELECT operating_unit_name, discount_lost, discount_at_risk, ROUND(discount_lost / NULLIF(discount_at_risk,0),4) lost_ratio FROM apps.fii_ap_disc_top_summary_v;
  • Totals across organizations — SELECT SUM(discount_at_risk), SUM(discount_lost) FROM apps.fii_ap_disc_top_summary_v;

These results are commonly piped into BI Publisher layouts for cash-management reviews, or compared period over period to trend discount capture performance. Because the view is aggregated, any drill-down to invoice or supplier must be performed against the underlying FII_AP_DISCOUNTS_SUMMARY table or the standard Payables tables, not this view.