Search Results inv_amount_func




Overview
Explore in AI Chat

Overview

APPS.FII_AR_NET_REC_BASE_MV_F_V is a reporting view in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that exposes the functional-currency ("_FUNC") measures maintained by the Oracle Receivables net receivables and receipts materialized view. It is part of the Oracle Financial Intelligence (FII) / Enterprise Trade and Risk Management (ETRM) reporting layer used for receivables aging, collections, and cash-application analytics. The view's suffix convention distinguishes it from its underlying materialized view: the "_V" indicates a view, and "_FUNC" columns carry amounts converted to the ledger functional currency, making the data suitable for cross-currency aggregation in BI Publisher reports, Discoverer workbooks, and Oracle Business Intelligence (OBIEE/OBIA) dashboards.

The search term "earned_discount_amount_func" maps directly to the EARNED_DISCOUNT_AMOUNT_FUNC column, confirming that this view is the correct target for queries concerning discount taken at the time of receipt application.

Underlying Base Objects

The view is defined as a straightforward projection over the materialized view FII_AR_NET_REC_BASE_MV. Its text selects a fixed column list—time, party, customer account, collector, operating unit, classification, bucket amounts and counts, receipt and adjustment measures, and functional-currency discount metrics—directly from that materialized view without joins, filters, or aggregation. Because the source is a materialized view, the data reflects a snapshot refreshed on a schedule; query results are therefore as fresh as the most recent refresh of FII_AR_NET_REC_BASE_MV. The documented metadata lists no additional referenced base objects, so the relationship is one-to-one between the view and its backing materialized view.

Key Columns

Common Use Cases and Queries

The view supports collections dashboards, DSO analysis, and discount-taken audits. To isolate earned discount by customer and collector for a period:

  • SELECT cust_account_id, collector_id, SUM(earned_discount_amount_func) FROM apps.fii_ar_net_rec_base_mv_f_v WHERE time_id = :time_id GROUP BY cust_account_id, collector_id;
  • SELECT org_id, SUM(total_open_amount_func), SUM(past_due_open_amount_func) FROM apps.fii_ar_net_rec_base_mv_f_v GROUP BY org_id;
  • SELECT time_id, AVG(avg_dd_num_func) FROM apps.fii_ar_net_rec_base_mv_f_v GROUP BY time_id;

Because refresh timing governs currency, users should confirm the last refresh of FII_AR_NET_REC_BASE_MV before relying on the figures for period-close reporting.