Search Results invoice_unique_identifier

Overview

FII_AP_DISC_LOST_DTL_SUMMARY_V is a reporting view that belongs to the FII (Financial Intelligence) product family within Oracle E-Business Suite. Its documented purpose is to support the Payables Discount Lost Detail Drill Downs Portlet, a component of the Financial Intelligence dashboards used to surface Payables payment performance metrics. The view presents discount-lost amounts at the level of the individual supplier invoice, aggregated across the qualifying lines that contributed to each loss, and enriches that detail with descriptive attributes for the operating unit and the trading partner (supplier). In the 12.1.1 and 12.2.2 documentation sets, FII is classified as obsolete, meaning that the product has been superseded by later Oracle financial reporting and analytics offerings. Nevertheless, the view remains documented in the ETRM reference material, and its structure is useful for understanding how the discount-lost drill-down was constructed and for interpreting historical reporting definitions.

Underlying Base Objects

The view is defined over a single documented source object, FII_AP_DISCOUNTS_SUMMARY, which serves as the consolidated summary source for Payables discount analysis. No additional base tables or views are documented as referenced objects, and the view itself is recorded as not implemented in the database from which the metadata was extracted, so it exists strictly as documented structure rather than as a live deployed object in that environment. The join logic is implicit rather than a conventional multi-table join: the view applies a filter on FII_AP_DISCOUNTS_SUMMARY restricting RECORD_TYPE to the literal value 'L', which distinguishes discount-lost records from other record categories carried in the same summary. The view's columns therefore map closely to the columns of FII_AP_DISCOUNTS_SUMMARY, with two of those columns — INVOICE_AMOUNT and DISCOUNT_LOST — passed through aggregation functions rather than exposed at their stored grain.

Key Columns

• OPERATING_UNIT_PK_KEY / OPERATING_UNIT_NAME — The operating unit identifier and its display name, providing the organizational partition for the discount-lost amounts.
• TRADING_PARTNER_PK_KEY / TRADING_PARTNER_NAME — The supplier identifier and name associated with the invoice, enabling supplier-level drill-down analysis.
• INVOICE_PK_KEY — Derived from INVOICE_UNIQUE_IDENTIFIER; the surrogate invoice key that uniquely identifies the drill-down target invoice.
• INVOICE_NUMBER — Derived from INVOICE_NUM; the human-readable invoice number presented to the user in the portlet detail region.
• INVOICE_DATE — The invoice date, carried through directly and used both as a descriptive attribute and, in typical usage, as a date filter or reporting period qualifier for the portlet.
• INVOICE_AMOUNT — The sum of invoice amounts for the grouped rows, providing the base against which the lost discount is evaluated.
• DISCOUNT_LOST — The summed discount-lost value, the principal measure the portlet reports.

Common Use Cases and Queries

The view is intended for drill-down navigation from a summarized discount-lost dashboard into invoice-level detail. A typical query retrieves the discount-lost positions for a single combination of operating unit and supplier, optionally constrained by invoice date, which is frequently the entry point when a user searches on invoice_date to locate a specific period's losses:

• Listing all invoices for a supplier within an operating unit: SELECT INVOICE_NUMBER, INVOICE_DATE, INVOICE_AMOUNT, DISCOUNT_LOST FROM FII_AP_DISC_LOST_DTL_SUMMARY_V WHERE OPERATING_UNIT_NAME = :p_ou AND TRADING_PARTNER_NAME = :p_supplier
• Filtering a date range: SELECT * FROM FII_AP_DISC_LOST_DTL_SUMMARY_V WHERE INVOICE_DATE BETWEEN :p_from AND :p_to
• Ranking invoices by loss: SELECT INVOICE_NUMBER, INVOICE_DATE, DISCOUNT_LOST FROM FII_AP_DISC_LOST_DTL_SUMMARY_V ORDER BY DISCOUNT_LOST DESC

Because FII is documented as obsolete, these queries should be regarded as reference patterns for legacy Financial Intelligence implementations rather than as current recommendations; equivalent data is available through supported Payables discount analysis subject areas in later releases.