Search Results current_open_count

Overview

FII_AR_NET_REC_BASE_MV_S_V is a reporting view shipped with the Oracle Financial Intelligence (FII) product family, an analytical layer historically bundled with Oracle E-Business Suite releases 12.1.1 and 12.2.2. The view exposes the contents of a materialized view, FII_AR_NET_REC_BASE_MV, which consolidates Accounts Receivable net receivables data into a single, query-friendly structure. Its purpose is to present aggregated receivables balances, aging buckets, receipts activity, and collections metrics across time, customer, collector, and operating unit dimensions, supporting the AR Net Receivables and related FII dashboards.

It is important to note that FII is flagged as obsolete in the ETRM documentation, and the object is documented as "Not implemented in this database." In practice, this means the view may exist only where the Financial Intelligence patch set was applied, and it should be treated as a legacy artifact rather than an active integration point in current customizations.

Underlying Base Objects

The view is defined over a single documented base object: the materialized view FII_AR_NET_REC_BASE_MV. No further underlying base tables are exposed in the ETRM metadata, so the lineage below the materialized view (typically AR transactions, receipts, and customer tables) is hidden behind the MV refresh mechanism. The view's column list mirrors the MV structure almost exactly, with a consistent naming convention: many measure columns carry a "_SEC" suffix in the view text, indicating a secured variant of the base column (for example, CURRENT_BUCKET_1_AMOUNT_SEC versus CURRENT_BUCKET_1_AMOUNT in the MV column list). The view also exposes a GID and UMARKER, which are characteristic of FII secured views and are used to enforce row-level security and object lineage.

Key Columns

• TIME_ID, PERIOD_TYPE_ID, HEADER_FILTER_DATE — Time dimension keys used to slice data by reporting period.
• PARTY_ID, PARENT_PARTY_ID, CUST_ACCOUNT_ID, COLLECTOR_ID, ORG_ID — Customer, collector, and operating unit dimensions.
• CURRENT_BUCKET_1_AMOUNT_SEC ... CURRENT_BUCKET_3_COUNT — Current aging bucket amounts and counts.
• PAST_DUE_BUCKET_1_AMOUNT_SEC ... PAST_DUE_BUCKET_7_COUNT — Past-due aging buckets one through seven, each with amount and count pairs.
• CURRENT_OPEN_COUNT / CURRENT_OPEN_AMOUNT_SEC — The count and secured amount of currently open receivables. This is the column directly relevant to the user's search for "current_open_count."
• PAST_DUE_COUNT / PAST_DUE_OPEN_AMOUNT_SEC, TOTAL_OPEN_COUNT / TOTAL_OPEN_AMOUNT_SEC — Past-due and combined open item counts and amounts.
• Receipt and activity measures — INV_AMOUNT_SEC, DM_AMOUNT_SEC, CB_AMOUNT_SEC, BR_AMOUNT_SEC, DEP_AMOUNT_SEC, APP_COUNT, REV_COUNT, TOTAL_RECEIPT_COUNT, EARNED_DISCOUNT_AMOUNT_SEC, and others support cash application and discount analysis.
• WTD_DAYS_PAID_NUM_SEC, WTD_TERMS_PAID_NUM_SEC, AVG_DD_NUM_SEC — Weighted average days-to-pay and terms metrics.

Common Use Cases and Queries

The view is primarily queried by FII dashboards and by custom AR aging or collections reporting that needs pre-aggregated bucket data. A typical use is counting open receivables for a collector within an operating unit:

• SELECT collector_id, SUM(current_open_count) AS open_items FROM fii_ar_net_rec_base_mv_s_v WHERE org_id = :org_id GROUP BY collector_id;
• SELECT time_id, SUM(total_open_amount_sec) FROM fii_ar_net_rec_base_mv_s_v WHERE cust_account_id = :acct GROUP BY time_id;
• SELECT class_category, SUM(past_due_bucket_1_amount_sec), SUM(past_due_bucket_1_count) FROM fii_ar_net_rec_base_mv_s_v GROUP BY class_category;

Because the object is documented as obsolete and not implemented in the reference database, administrators should verify its existence via ALL_VIEWS before relying on it, and should prefer supported AR reporting views (such as those in the AR module) for new development.