Results for “invoice_count”

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

Overview

FII_AP_DISC_AVAL_TOP_SUMMARY_V is a view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the FII (Financial Intelligence) product family. It is a reporting and analytics object whose stated purpose is to support the Payables Discount Available Summary Drill Downs Portlet. The view presents an aggregated snapshot of discount opportunities available on Payables invoices, summarized by operating unit and trading partner. It is intended to feed a top-level summary region within the Financial Intelligence dashboards, from which users can drill down into the underlying detail records of the discount analysis.

Because the view aggregates its source data at query time rather than storing pre-computed balances, it is read-only and can be safely queried by custom reports and integrations without risking data corruption. The view status is VALID in the documented environment, confirming that the definition compiles cleanly against its dependencies. As an FII object, it is designed for consumption by the Financial Intelligence application and its portlets rather than by operational subledger processes such as Payables invoice entry. It is available in both Oracle EBS 12.1.1 and 12.2.2, where the Financial Intelligence product is deployed; the object metadata is consistent across those releases.

Underlying Base Objects

The documented definition of the view references a single underlying object: FII_AP_DISCOUNTS_SUMMARY. The view is defined as a projection and aggregation over that object, subject to the filter predicate RECORD_TYPE = 'R'. No other base tables are documented, and the view text does not join to additional entities. In effect, FII_AP_DISCOUNTS_SUMMARY acts as the detail table, while FII_AP_DISC_AVAL_TOP_SUMMARY_V acts as the rolled-up summary layer presented to the portlet.

The filter RECORD_TYPE = 'R' restricts output to a specific class of record within the summary table, corresponding to the rows intended for reporting rather than to alternate record classifications stored in the same structure. The GROUP BY clause collapses the detail rows to one row per combination of operating unit and trading partner, summing the monetary measures and counting distinct invoices. Knowledge of this dependency is important for maintenance and performance analysis: any change to FII_AP_DISCOUNTS_SUMMARY, or to the volume of rows carrying RECORD_TYPE = 'R', directly affects the response time and content of this view.

Key Columns

• OPERATING_UNIT_PK_KEY — The primary key identifier of the operating unit, used as the grouping key and drill-down linkage.
• OPERATING_UNIT_NAME — The descriptive name of the operating unit, displayed on the summary portlet.
• TRADING_PARTNER_PK_KEY — The primary key identifier of the trading partner (supplier), used as the second grouping key.
• TRADING_PARTNER_NAME — The descriptive name of the trading partner shown to the user.
• INVOICE_AMOUNT — The sum of invoice amounts for the summarized invoices in the group.
• INVOICE_COUNT — The count of distinct invoices, computed as COUNT(DISTINCT INVOICE_UNIQUE_IDENTIFIER), giving the number of invoices contributing to the group.
• DISCOUNT_AVAILABLE — The sum of discount amounts still available, representing the core metric of the discount analysis.

The measure columns are additive within the shown grouping but should not be summed across a different grouping without repeating the aggregation logic. The two key columns provide the join paths needed for drill-down navigation to detail-level data.

Common Use Cases and Queries

The primary use case is the Financial Intelligence Payables Discount Available Summary portlet, which renders one row per operating unit and trading partner and allows the user to navigate to more detailed discount information. The view is also suitable for ad hoc reporting where a quick, aggregated view of unrealized discount opportunities is required.

A representative query lists the largest discount opportunities for a given operating unit:

• SELECT operating_unit_name, trading_partner_name, invoice_count, invoice_amount, discount_available FROM apps.fii_ap_disc_aval_top_summary_v WHERE operating_unit_name = :p_ou ORDER BY discount_available DESC;

A second pattern ranks trading partners by total discount available across all operating units by aggregating the view itself. A third pattern correlates the discount value with invoice volume using the ratio of DISCOUNT_AVAILABLE to INVOICE_AMOUNT to identify suppliers with the highest relative discount exposure. Because no base tables are documented for direct query, all access should be made through this view or its parent summary object, subject to the standard FII security and operating unit access controls applied by the Financial Intelligence application.