Results for “unapp_amount”

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

Overview

The view FII_AR_RCT_AGING_AGRT_MV_P_V belongs to the Oracle E-Business Suite Financial Intelligence (FII) product family, which is documented as obsolete in Release 12.1.1 and 12.2.2. It exposes pre-aggregated receivables aging data organized by collector, customer account, party, and time period. Its naming convention indicates it is a presentation-level ("_P_V") view layered over a materialized view (FII_AR_RCT_AGING_AGRT_MV), where "AGRT" denotes aggregation and "RCT" denotes the Receivables (AR) collection/aging subject area.

The object supplied receivables aging metrics — most notably AGING_BUCKET_1_AMOUNT_PRIM, the column referenced in the user's search — to downstream Oracle Business Intelligence and Daily Business Intelligence (DBI) style dashboards. These dashboards reported outstanding balances distributed across aging buckets per collector. Because FII has been superseded by later BI Applications releases and Oracle Fusion analytics, the view is retained only for historical or upgrade reference.

Underlying Base Objects

The ETRM metadata records that this view is not implemented in the current database and that no base objects are separately documented. The view text, however, unambiguously defines a single-source projection from the materialized view FII_AR_RCT_AGING_AGRT_MV:

• FII_AR_RCT_AGING_AGRT_MV — the sole documented source object, providing pre-computed aging aggregate rows.

No joins, unions, or additional tables appear in the definition. All transformation is column projection plus an alias substitution of the *_AMOUNT columns into *_AMOUNT_PRIM names. The materialized view itself would have been refreshed on a scheduled basis (typically nightly) from AR transaction and receipt detail, but that lineage is not documented in the ETRM record and should be confirmed against the FII data model if required.

Key Columns

• TIME_ID, PERIOD_TYPE_ID — the time dimension key and the period grain (day, week, month, quarter) for the aggregate.
• PARENT_PARTY_ID, PARTY_ID — trading partner identifiers supporting party hierarchy roll-ups.
• CUST_ACCOUNT_ID — the Receivables customer account the balance belongs to.
• COLLECTOR_ID — the collections agent responsible for the account; the primary grouping for collector productivity reporting.
• ORG_ID — operating unit, enforcing multi-org data segregation.
• AGING_BUCKET_1_AMOUNT_PRIM, AGING_BUCKET_2_AMOUNT_PRIM, AGING_BUCKET_3_AMOUNT_PRIM — primary-currency balances in the first, second, and third aging intervals respectively. AGING_BUCKET_1_AMOUNT_PRIM represents the current (least delinquent) bucket.
• AGING_BUCKET_1_COUNT and siblings — transaction or invoice counts falling into each bucket.
• UNID_AMOUNT_PRIM, UNAPP_AMOUNT_PRIM — unidentifed and unapplied receipt amounts in primary currency.
• TOTAL_UNAPPLIED_AMOUNT_PRIM, TOTAL_UNAPPLIED_COUNT — aggregate unapplied cash position and its record count.
• GID — the global identifier used by the FII/DBI ETL framework for incremental refresh.

Common Use Cases and Queries

The view supported aging analyses such as "top delinquent customers by bucket," "collector workload distribution," and "unapplied cash by operating unit." A representative query returning the largest first-bucket exposures for a given period is:

• SELECT cust_account_id, collector_id, org_id, AGING_BUCKET_1_AMOUNT_PRIM, AGING_BUCKET_1_COUNT
• FROM FII_AR_RCT_AGING_AGRT_MV_P_V
• WHERE time_id = :p_time_id AND period_type_id = :p_period_type
• ORDER BY AGING_BUCKET_1_AMOUNT_PRIM DESC;

A collector roll-up follows the same pattern, aggregating SUM(AGING_BUCKET_1_AMOUNT_PRIM) grouped by collector_id and org_id. Because the object is obsolete and not implemented, the view cannot be queried in a current 12.2.2 instance; equivalent reporting should be sourced from the standard AR aging reports or the successor BI subject areas.