Search Results total_open_amount_prim




Overview
Explore in AI Chat

Overview

APPS.FII_AR_NET_REC_AGRT_MV_P_V is a reporting view in Oracle E-Business Suite that exposes the primary-currency contents of the materialized view FII_AR_NET_REC_AGRT_MV. It forms part of the Oracle Financials Intelligence / Enterprise Trade and Receivables Management (ETRM) reporting layer, providing net receivables and receipts activity metrics for Accounts Receivable (AR) at a specified level of aggregation. The view is a thin, read-only projection: its defining query selects every column of the underlying materialized view without joins, filters, or transformations, so the row grain and data freshness are entirely governed by that materialized view.

The view is designed for consumption by BI Publisher reports, Oracle Business Intelligence (OBIEE) repositories, and custom SQL used in AR aging, collections, and cash application analysis. Its naming conventions — the _MV_ and _P_V suffixes together with the _AMOUNT_PRIM and _NUM_PRIM column suffixes — indicate that values are stored in the ledger's primary currency and that the physical aggregation has already been performed, making the view suitable for high-volume reporting where on-the-fly aggregation would be prohibitively expensive.

Underlying Base Objects

According to the documented metadata, the view is defined over a single object: FII_AR_NET_REC_AGRT_MV, a materialized view. No additional base tables are documented as directly referenced by the view definition. In practice, the materialized view itself is refreshed from AR transaction, receipt, customer account, collector, and calendar/time dimension sources, but those lineage relationships sit beneath the materialized view and are not exposed by the view text. Because the view adds no logic, any query tuning, refresh strategy, or indexing performed on FII_AR_NET_REC_AGRT_MV applies equally to this view.

Key Columns

Common Use Cases and Queries

The view is typically queried to obtain pre-aggregated invoiced, collected, and open balances by customer, collector, or period. A representative query summing invoiced value and receipts for a given period and operating unit:

SELECT cust_account_id,
       SUM(inv_amount_prim)          AS invoiced_amount,
       SUM(total_receipt_amount_prim) AS receipts,
       SUM(total_open_amount_prim)    AS open_balance
FROM   apps.fii_ar_net_rec_agrt_mv_p_v
WHERE  org_id = :p_org_id
AND    time_id BETWEEN :p_from_time AND :p_to_time
GROUP  BY cust_account_id;

Additional scenarios include aging analysis by bucket for collections prioritisation (selecting the PAST_DUE_BUCKET_n_AMOUNT_PRIM and matching _COUNT columns), DSO reporting using WTD_DDSO_DUE_NUM_PRIM and WTD_DAYS_PAID_NUM_PRIM, and incremental data extraction driven by GID or UMARKER. Because all amounts are primary-currency values, any reporting requirement involving converted or dual currency must be handled upstream, typically by joining to the relevant currency conversion logic rather than expecting it from this view.