Search Results unapp_receipt

Overview

FII_AR_AGING_WH_V is an Oracle E-Business Suite view owned by the APPS schema and registered under the FND Design Data entity FII.FII_AR_AGING_WH_V. It exposes pre-aggregated Accounts Receivable aging information for a warehouse-style reporting model, presenting receivables balances segmented into aging buckets alongside the total past due amount, unapplied receipts, and overall customer balance at a specific point in time. The view's status is VALID and its view type is designated Internal. Oracle's documentation carries a warning that the object is for Oracle Internal Use Only and that Oracle Corporation does not support access to applications data using this object except from standard Oracle Applications programs. In practice this means the view is a supporting component of the FII (Financial Intelligence) schema, consumed by Oracle's own Business Intelligence Applications and packaged reports rather than a supported extension point for custom development. Even so, it is frequently examined by technical consultants when troubleshooting aging figures — for example, when reconciling the value returned for TOTAL_PASTDUE against the standard AR Aging Report.

Underlying Base Objects

The documented dependency metadata for FII_AR_AGING_WH_V references a single base object: APPS.FII_AR_OPEN_INSTALLMENT_F, a discrete function (or function-based object) within the FII schema. This is significant because it indicates the aging values are not sourced directly from the transactional AR tables such as RA_CUSTOMER_TRX_ALL, AR_PAYMENT_SCHEDULES_ALL, or HZ_CUST_ACCOUNTS in a simple join; rather they are derived through a function that encapsulates the FII-specific calculation logic, including bucket definitions and snapshot handling. The view itself is not referenced by any other database object, placing it at the top of its dependency chain and confirming it acts as a terminal presentation layer. Because the exact SQL body is not documented in the metadata beyond the outer SELECT, the internal derivation of each bucket is opaque and should be treated as Oracle-controlled. Any change to FII_AR_OPEN_INSTALLMENT_F will propagate directly into every figure returned by this view.

Key Columns

• SOB_ID — The Set of Books identifier, defining the accounting context in which the aging figures were calculated.
• ORG_ID — The operating unit (organization) identifier to which the customer balances belong.
• CUSTOMER_ID — The customer account identifier, joining conceptually to the AR customer tables.
• DATE_OF_SNAPSHOT — The effective date of the aging snapshot, distinguishing this data from live transactional balances.
• BUCKET1 through BUCKET5 — The five standard aging columns, each representing balances falling within a defined days-past-due interval.
• TOTAL_PASTDUE — The aggregate of the past-due buckets, representing amounts due beyond current. This is the column most often queried by users searching for "total_pastdue".
• UNAPP_RECEIPT — Unapplied receipts held against the customer, which may offset the gross past-due exposure.
• BALANCE — The customer's total outstanding balance as captured in the snapshot.

Common Use Cases and Queries

The principal use case is aging analysis and drill-down reporting within BI dashboards that require a single row per customer per snapshot date. A representative query is:

SELECT org_id, customer_id, date_of_snapshot, total_pastdue, balance FROM apps.fii_ar_aging_wh_v WHERE total_pastdue > 0 ORDER BY org_id, customer_id;

A second common pattern aggregates the buckets to compare gross past-due with unapplied receipts, useful for net exposure reporting:

SELECT sob_id, org_id, SUM(bucket1 + bucket2 + bucket3 + bucket4 + bucket5) gross_pastdue, SUM(total_pastdue) total_pastdue, SUM(unapp_receipt) unapplied FROM apps.fii_ar_aging_wh_v GROUP BY sob_id, org_id;

Because the object is marked Oracle Internal Use Only, production queries should generally be limited to diagnostic and reconciliation activity, with any permanent solution built against supported AR interfaces or the standard AR Aging Report.