Search Results operating_unit_pk_key




Overview
Explore in AI Chat

Overview

FII_AP_DISC_TOP_SUMMARY_V is an Oracle E-Business Suite APPS schema view owned by the Financial Intelligence (FII) product. It exists to support the Payment Discount Opportunities Portlet, a dashboard component that surfaces supplier payment discount exposure to payables and treasury users. In Oracle EBS 12.1.1 and 12.2.2 the view is registered with a VALID status and is deployed as part of the Financial Intelligence application, which provides the analytic and summary layer consumed by Oracle Payments-centric dashboards and the Daily Business Intelligence style reporting framework.

The central analytical measure exposed by this view is DISCOUNT_AT_RISK. This column is the aggregation of DISCOUNT_AVAILABLE from the underlying summary object and represents the total discount amount that is still available but may be forfeited if invoices are not paid before the discount date. Because the view is designed for a top-level portlet, it aggregates discount exposure by operating unit rather than returning invoice-level detail, making it suitable for at-a-glance monitoring rather than transactional inquiry.

Underlying Base Objects

The view text is defined as a single aggregation over one source object, FII_AP_DISCOUNTS_SUMMARY:

No further base tables are documented as direct dependencies of the view itself; the join and grouping logic is entirely contained within the aggregation over FII_AP_DISCOUNTS_SUMMARY. In practice, FII_AP_DISCOUNTS_SUMMARY is itself derived from payables invoice and payment schedule data (AP_INVOICES_ALL, AP_PAYMENT_SCHEDULES_ALL, and related discount columns), but those underlying tables are not referenced by FII_AP_DISC_TOP_SUMMARY_V directly.

The grouping keys are OPERATING_UNIT_PK_KEY and OPERATING_UNIT_NAME, so the view returns one row per operating unit represented in the summary object.

Key Columns

  • OPERATING_UNIT_PK_KEY — the surrogate primary key of the operating unit used for grouping and for drill-down linkage back to the operating unit dimension.
  • OPERATING_UNIT_NAME — the display name of the operating unit, used as the row label in the portlet.
  • DISCOUNT_AT_RISK — the sum of DISCOUNT_AVAILABLE across the operating unit; the headline measure of discount still capturable but at risk of being lost.
  • DISCOUNT_LOST — the sum of DISCOUNT_LOST across the operating unit; the value of discounts already forfeited.

Common Use Cases and Queries

The primary use case is the Payment Discount Opportunities Portlet, which ranks operating units by at-risk discount value so that payables staff can prioritise early payment runs. Because the view already aggregates, it is inexpensive to query and can be refreshed frequently.

SELECT operating_unit_name,
       discount_at_risk,
       discount_lost
FROM   apps.fii_ap_disc_top_summary_v
ORDER BY discount_at_risk DESC;

A second scenario isolates the operating units with the greatest exposure, for example to drive a notification or exception report:

SELECT operating_unit_name,
       discount_at_risk
FROM   apps.fii_ap_disc_top_summary_v
WHERE  discount_at_risk > 0
ORDER BY discount_at_risk DESC
FETCH FIRST 10 ROWS ONLY;

A third pattern compares available versus lost discount per operating unit to assess payables performance:

SELECT operating_unit_name,
       discount_at_risk,
       discount_lost,
       discount_at_risk + discount_lost AS total_discount_potential
FROM   apps.fii_ap_disc_top_summary_v;

Queries should always be issued against the APPS schema with the appropriate MO: Operating Unit security context applied so that only authorised operating units are returned. In 12.2.2 the view remains compatible with multi-org access control, and its aggregation by operating unit aligns naturally with the MOAC security model.