Search Results fii_ap_disc_lost_top_summary_v

Overview

FII_AP_DISC_LOST_TOP_SUMMARY_V is a reporting view belonging to the Oracle Financial Intelligence (FII) product family, which is documented as obsolete in Oracle EBS 12.1.1 and 12.2.2. The view was created to support the Payables Discount Lost Summary Drill Downs Portlet, a dashboard component that surfaces aggregated information about discounts missed on supplier invoices at the trading partner level. In the ETRM metadata the object is explicitly marked "Not implemented in this database," indicating that while the definition is retained for reference, the physical view is not present in the delivered schema.

The view aggregates data from the underlying discounts summary object and presents one row per operating unit and trading partner combination. Because it is a summary-level view, it does not expose individual invoice lines or payment details; instead it rolls up counts and monetary amounts for downstream portlet rendering and drill-down navigation. This makes it useful for high-level visibility into lost discount exposure by supplier, rather than transactional reconciliation.

Underlying Base Objects

The documented metadata lists no referenced base objects; however, the view text reveals the definition is built directly over FII_AP_DISCOUNTS_SUMMARY. The view selects from that source and filters on RECORD_TYPE = 'L', where 'L' denotes lost discount records. Rows are grouped by OPERATING_UNIT_PK_KEY, OPERATING_UNIT_NAME, TRADING_PARTNER_PK_KEY, and TRADING_PARTNER_NAME. The aggregation uses COUNT(DISTINCT INVOICE_UNIQUE_IDENTIFIER) for invoice counts and SUM() for the INVOICE_AMOUNT and DISCOUNT_LOST measures. No joins, unions, or additional base tables appear within the view text. Because the object is documented as obsolete, the base table FII_AP_DISCOUNTS_SUMMARY may also be absent or unsupported in current environments, and any custom implementation relying on it should be validated against the target instance.

Key Columns

• OPERATING_UNIT_PK_KEY — Surrogate primary key of the operating unit associated with the lost discount records.
• OPERATING_UNIT_NAME — Descriptive name of the operating unit, used for grouping and display labels in the portlet.
• TRADING_PARTNER_PK_KEY — Surrogate primary key of the trading partner (supplier) against which discounts were lost.
• TRADING_PARTNER_NAME — The trading partner name referenced in the user's search; this is the supplier-facing label displayed for drill-down selection.
• INVOICE_COUNT — Count of distinct invoice unique identifiers contributing to the lost discount total for the operating unit and trading partner combination.
• INVOICE_AMOUNT — Sum of invoice amounts for the lost discount records in the grouping.
• DISCOUNT_LOST — Sum of the discount amounts that were forgone, the principal measure the portlet reports.

The trading partner columns are central to the object's purpose: TRADING_PARTNER_NAME provides the human-readable identifier, while TRADING_PARTNER_PK_KEY supports programmatic linkage to supplier records. Loss of discount figures should be interpreted as missed early-payment opportunities, not as posted accounting entries.

Common Use Cases and Queries

Typical scenarios include portlet data sourcing, supplier-level lost discount analysis, and operating unit comparisons. Because the view is obsolete and not implemented in the database, queries are presented for reference and should be adapted to a supported replacement if one exists.

Retrieve top trading partners by lost discount for an operating unit:

SELECT trading_partner_name, invoice_count, invoice_amount, discount_lost
FROM   fii_ap_disc_lost_top_summary_v
WHERE  operating_unit_name = :p_operating_unit
ORDER BY discount_lost DESC;

Search by trading partner name, as suggested by the user's query term:

SELECT operating_unit_name, trading_partner_name, discount_lost
FROM   fii_ap_disc_lost_top_summary_v
WHERE  UPPER(trading_partner_name) LIKE UPPER('%' || :p_trading_partner || '%');

Compare lost discounts across operating units for a single supplier:

SELECT operating_unit_name, SUM(discount_lost) total_lost
FROM   fii_ap_disc_lost_top_summary_v
WHERE  trading_partner_name = :p_supplier
GROUP BY operating_unit_name;

For replacement reporting in supported EBS versions, equivalent results are generally obtained from Payables discount and payment tables such as AP_INVOICES_ALL, AP_INVOICE_PAYMENTS_ALL, and AP_PAYMENT_SCHEDULES_ALL, joined to supplier and operating unit views.