Results for “amount_due”

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

Overview

ICX_PANEL_TOTALS_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, defined as part of the ICX product family (Oracle iProcurement). Its documented description is "Total Summary View for All Customers," indicating that it consolidates aggregated procurement, order, shipment, payment, and service metrics across all customers into a single summarized result set. Rather than storing data itself, the view projects and rolls up numeric measures that are typically displayed on iProcurement dashboard panels and summary regions, allowing end users and reporting tools to retrieve period-based totals without issuing multiple queries against the underlying transactional tables.

Because the view applies SUM aggregations together with MAX functions over date and identifier columns, it is oriented toward analytical reporting rather than transactional processing. Its output represents a rolled-up snapshot keyed by a data-as-of date and currency formatting context, making it suitable for embedding in dashboard "panels" that present week-over-week, month-over-month, and multi-month trend figures to procurement and purchasing users. The view is reported with VALID status and applies to both EBS 12.1.1 and 12.2.2 in the APPS schema.

Underlying Base Objects

According to the ETRM metadata, ICX_PANEL_TOTALS_V is defined over two documented referenced base objects:

• FND_CURRENCY (PACKAGE) — the Oracle Application Object Library currency utility package. The view calls FND_CURRENCY.SAFE_GET_FORMAT_MASK(CURRENCY_CODE, 30) to derive a currency-aware format mask for the amount columns, ensuring monetary values are presented consistently with the session or customer currency profile.
• ICX_PANEL_SUMMARY (SYNONYM) — a synonym pointing to the underlying summary table or object that supplies the granular measure columns (orders, cancellations, RMAs, shipments, payments, and service calls) which this view aggregates.

The view's SELECT text shows that it takes the CURRENCY_CODE and DATA_AS_OF_DATE context and applies SUM or MAX to the measures exposed through ICX_PANEL_SUMMARY, joined implicitly with currency formatting rules. This layered design separates the storage of period metrics from their presentation format.

Key Columns

The view exposes a wide set of aggregated measures paired with formatted amount strings:

• DATA_AS_OF_DATE — the reference date for all period calculations.
• Orders (counts and amounts) — ORDERS_LAST_WEEK, ORDERS_LAST_MONTH, ORDERS_LAST_3_MONTHS, ORDERS_LAST_6_MONTHS, ORDERS_LAST_12_MONTHS, each with a corresponding ORDERS_AMOUNT_* column formatted via SAFE_GET_FORMAT_MASK.
• Cancellations — CANCELLED_ORDERS_3_MONTHS/6_MONTHS and their amount counterparts.
• Returns/RMA — RMA_3_MONTHS, RMA_6_MONTHS and associated RMA_AMOUNT_* measures.
• Order reference — MAX(LAST_ORDER_DATE) and MAX(LAST_ORDER_NUMBER), giving the most recent order context.
• Shipments and payments — SHIPMENTS_OPEN, SHIPMENTS_LATE, LATE_PAYMENTS_3_MONTHS, LATE_PAYMENTS_6_MONTHS, and AMOUNT_DUE.
• Service metrics — SERVICE_CALLS_3_MONTHS, MAX(DATE_OF_LAST_SERVICE_CALL), SERVICE_AMOUNT_6_MONTHS/12_MONTHS, and SERVICE_ORDERS_6_MONTHS.

Common Use Cases and Queries

The view is commonly used to populate supplier or customer scorecard panels in iProcurement, to power dashboard totals, and as a reporting source for procurement KPIs. A representative query:

• SELECT DATA_AS_OF_DATE, ORDERS_LAST_MONTH, ORDERS_AMOUNT_LAST_MONTH FROM APPS.ICX_PANEL_TOTALS_V;
• Retrieve rolling twelve-month order totals and the latest order reference for trend analysis.
• Feed a custom BI Publisher or OBIEE report summarizing cancellations, RMAs, late payments, and open shipments.

Because monetary columns are pre-formatted through FND_CURRENCY, consumers should treat amount fields as display strings rather than raw numerics when building downstream calculations.