Search Results discount_available




Overview
Explore in AI Chat

Overview

The view APPS.FII_AP_DISC_AVAL_TOP_SUMMARY_V is a reporting object within the Oracle E-Business Suite Financial Intelligence (FII) / Enterprise Tax and Reporting Management (ETRM) data model. It presents an aggregated, top-level summary of accounts payable discount information, organized by operating unit and trading partner. Its purpose is to support reporting and analytical queries that need consolidated visibility into the discounts available on supplier invoices, without requiring the report consumer to perform grouping and aggregation at runtime.

The view is primarily oriented toward reporting and integration scenarios, such as dashboard inquiries, ETRM reporting extracts, and downstream analytical processes where a summarized discount position per operating unit and trading partner is required. By surfacing pre-aggregated amounts, the view simplifies the construction of summary-level queries and reduces the burden on report developers to understand the detailed granularity of the underlying discounts summary data.

Underlying Base Objects

The view is defined over a single base object, FII_AP_DISCOUNTS_SUMMARY. According to the documented view definition, the query selects from this table with a filter of RECORD_TYPE = 'R' and aggregates the results. The ETRM metadata provided does not document any additional referenced base objects, so the relationship is a straightforward one-to-one dependency on FII_AP_DISCOUNTS_SUMMARY.

The FII_AP_DISCOUNTS_SUMMARY table stores discount-related summary records for accounts payable invoices. The restriction to RECORD_TYPE = 'R' indicates that the view exposes only a specific record category from that table, presumably the reporting or "regular" discount records, while excluding other record types that may exist for different processing purposes. The view performs a GROUP BY over operating unit and trading partner attributes, collapsing multiple detail rows into a single summarized row per combination.

Key Columns

The view exposes the following columns:

  • OPERATING_UNIT_PK_KEY — The primary key identifier of the operating unit, used for grouping and joining to operating unit dimensions.
  • OPERATING_UNIT_NAME — The descriptive name of the operating unit, provided for reporting readability.
  • TRADING_PARTNER_PK_KEY — The primary key identifier of the trading partner (supplier), used for grouping and dimensional joins.
  • TRADING_PARTNER_NAME — The descriptive name of the trading partner.
  • INVOICE_AMOUNT — The sum of invoice amounts for the grouped operating unit and trading partner combination.
  • INVOICE_COUNT — The count of distinct invoice unique identifiers, providing a distinct invoice count within the group.
  • DISCOUNT_AVAILABLE — The sum of discount available amounts, which is the central measure for users searching on the term discount_available.

The grouping keys are the operating unit and trading partner PK keys and names, so each row represents one distinct combination of those four attributes.

Common Use Cases and Queries

Typical usage centers on reporting the total discount available per operating unit and supplier. A representative query follows:

  • SELECT operating_unit_name, trading_partner_name, invoice_amount, invoice_count, discount_available FROM apps.fii_ap_disc_aval_top_summary_v ORDER BY discount_available DESC;
  • SELECT operating_unit_name, SUM(discount_available) FROM apps.fii_ap_disc_aval_top_summary_v GROUP BY operating_unit_name;
  • SELECT trading_partner_name, discount_available FROM apps.fii_ap_disc_aval_top_summary_v WHERE operating_unit_name = :p_operating_unit;

These queries support dashboard displays, supplier discount analysis, and ETRM reporting extracts. Because the view already aggregates the underlying summary data, report authors can filter and sort on DISCOUNT_AVAILABLE directly, making the view well suited to ad hoc analysis of available discounts across the payables organization.