Search Results total_unapplied_amount_prim

Overview

FII_AR_RCT_AGING_BASE_MV_P_V is an Oracle E-Business Suite view owned by the APPS schema and classified under the FII (Financial Intelligence) product family. Within the ETRM 12.2.2 repository the object is documented with the explicit description "No Longer Used," and its status is recorded as VALID. This combination indicates that the view remains compiled and queryable in the database dictionary, but Oracle no longer publishes it as a supported or recommended interface for new development.

The view exposes a granular snapshot of Accounts Receivable receipt and aging data, organized along time, party, customer account, collector, operating unit, and classification dimensions, together with aggregated aging bucket amounts and counts. Because the view name carries the "_MV" and "_P_V" tokens, it originally functioned as a reporting projection layered over the FII_AR_RCT_AGING_BASE_MV materialized view, the staging structure populated by Financial Intelligence extraction programs from the Oracle Receivables transactional tables. In its active lifetime, the view served as a convenient public interface through which Oracle Business Intelligence and other downstream reporting tools read pre-aggregated receipts aging figures without directly coupling to the materialized view.

Underlying Base Objects

The documented definition is a straightforward projection: the view selects a defined column list from FII_AR_RCT_AGING_BASE_MV and applies no joins, filters, or aggregation of its own. The ETRM metadata records no additional referenced base objects, confirming that the materialized view is the sole dependency. Physically, that materialized view is refreshed on the Financial Intelligence collection schedule and is sourced from Receivables receipt, customer, and collector data. Because the view performs no transformation, every row and column in the view mirrors the materialized view exactly; any refresh lag or data quality characteristic of the underlying materialized view is inherited without modification. Consumers that continue to query this view therefore retain an implicit dependency on the refresh cadence and existence of FII_AR_RCT_AGING_BASE_MV, which is a consideration during patching or upgrade activities.

Key Columns

• TIME_ID / PERIOD_TYPE_ID — Identify the reporting period and period type granularity of each snapshot row.
• PARENT_PARTY_ID / PARTY_ID / CUST_ACCOUNT_ID — Party hierarchy and customer account context, enabling rollups from account to parent party.
• COLLECTOR_ID / ORG_ID — Collector responsible for the account and the operating unit under which the balances were recorded.
• CLASS_CODE / CLASS_CATEGORY — Classification dimensions used to segment receipts and outstanding balances across reporting categories.
• AGING_BUCKET_1_AMOUNT_PRIM through AGING_BUCKET_3_AMOUNT_PRIM and matching counts — Amount and transaction counts distributed across the three published aging buckets, expressed in primary ledger currency.
• UNID_AMOUNT_PRIM / UNAPP_AMOUNT_PRIM — Unidentified and unapplied receipt amounts, which drive the bulk of AR aging exposure.
• TOTAL_UNAPPLIED_AMOUNT_PRIM / TOTAL_UNAPPLIED_COUNT — Aggregate unapplied receipt value and volume for the dimensional combination.
• GID — Global identifier used internally by Financial Intelligence to key records across its warehouse surface.

Common Use Cases and Queries

Because the object is deprecated, its practical uses are limited to maintaining legacy dashboards, validating historical report output, and troubleshooting inconsistencies discovered in existing Financial Intelligence extracts. A representative query returns unapplied receipt exposure by collector and period:

SELECT time_id, org_id, collector_id, SUM(total_unapplied_amount_prim) unapplied_amt, SUM(total_unapplied_count) unapplied_cnt FROM apps.fii_ar_rct_aging_base_mv_p_v WHERE org_id = :p_org_id GROUP BY time_id, org_id, collector_id ORDER BY time_id;

A second pattern reconciles aged bucket detail against the unapplied totals for a customer account: SELECT cust_account_id, aging_bucket_1_amount_prim, aging_bucket_2_amount_prim, aging_bucket_3_amount_prim, unapp_amount_prim, total_unapplied_amount_prim FROM apps.fii_ar_rct_aging_base_mv_p_v WHERE period_type_id = :p_period_type_id AND cust_account_id = :p_cust_account_id; New development should target the currently supported Financial Intelligence aging objects or the Oracle Receivables standard aging reports, treating this view as read-only and subject to removal.