Search Results aging_bucket_2_amount_func




Overview
Explore in AI Chat

Overview

The view APPS.FII_AR_RCT_AGING_AGRT_MV_F_V is a reporting layer object within the Oracle E-Business Suite Receivables and Financial Intelligence (FII) product family. It is a relatively thin projection: the view text selects every column listed from the underlying materialized view FII_AR_RCT_AGING_AGRT_MV without joins, filters, or transformations. Its function is to expose the aged receivables aggregation — computed by the materialized view — through a stable, "_V" view interface so that Oracle Business Intelligence (OBIEE), Financial Intelligence reporting, or XML Publisher templates can query it without binding directly to the materialized view name.

The object is a critical part of the Receivables aging and collections reporting model. The "AGRT" component indicates that the underlying aggregation is also filtered by resource or collector assignment ("agent resource"), meaning the aged amounts are summarized by collector, customer, party, and time period. The trailing "_F_V" convention denotes a Financial Intelligence functional view. The object is relevant in both 12.1.1 and 12.2.2, where the underlying view text is identical.

Underlying Base Objects

The documented source is a single underlying object:

  • FII_AR_RCT_AGING_AGRT_MV — an object prefixed "MV", indicating a materialized view created by the Financial Intelligence Receivables data model. It is the aggregation container that physically stores the pre-computed aging buckets and unapplied (unapplied cash) totals.

Because the projection is direct, column names and data types are inherited one-for-one from the materialized view. The documented ETRM metadata does not list any referenced base objects (base tables such as AR_PAYMENT_SCHEDULES_ALL, HZ_CUST_ACCOUNTS, or RA_CUSTOMER_TRX_ALL). While those tables are conventionally the origin of aged receivable transactions, the metadata as provided does not formally document them, so any dependency on them should be treated as inferred rather than certified.

Key Columns

The columns exposed by the view are:

Note that AGING_BUCKET_1_AMOUNT_FUNC is the singular form of the user's search string aging_bucket_1_amount_func; the plural/suffix variants belong to sibling views. The amount columns are expressed in the ledger functional currency, distinguished by the _FUNC suffix.

Common Use Cases and Queries

The view is typically consumed for aging summaries by collector or customer:

  • Receivables aging dashboards in OBIEE.
  • Collector performance and portfolio-at-risk reports.
  • Reconciliation of bucket totals to the general ledger.

A representative query:

SELECT party_id,
       cust_account_id,
       collector_id,
       org_id,
       time_id,
       aging_bucket_1_amount_func,
       aging_bucket_2_amount_func,
       aging_bucket_3_amount_func,
       total_unapplied_amount_func
  FROM apps.fii_ar_rct_aging_agrt_mv_f_v
 WHERE org_id = :p_org_id
   AND time_id = :p_time_id
   AND collector_id = :p_collector_id;

Because this is a materialized view-backed projection, the data is refreshed on the Financial Intelligence collection schedule; queries return the last refreshed snapshot rather than real-time transactional balances.