Search Results fii_ar_aging_wh_v

Overview

FII_AR_AGING_WH_V is an internal Oracle E-Business Suite database view owned by the APPS schema and classified under the FII (Financial Intelligence) product family. It is a VALID object in both Oracle EBS 12.1.1 and 12.2.2 environments where Financial Intelligence is licensed and configured. The view is documented as an internal helper object used specifically to support Risk Indicator Portlets, which are the UI components that surface aggregated financial risk metrics to collections and credit management users. It is not intended for direct customer-facing reporting or as a supported integration interface.

Functionally, the view transforms a set-of-books and age-bucket denormalized snapshot structure into a wide, fixed-column layout suitable for portlet grid rendering. It is a "WH" (warehouse-style) view that pivots open receivable installments into discrete aging buckets.

Underlying Base Objects

The documented definition derives exclusively from a single base object: FII_AR_OPEN_INSTALLMENT_F, an FII fact table holding open installment receivables keyed by the FII surrogate/key columns. The view text performs a column-level projection and a DECODE-based pivot rather than a join, so there are no additional documented base tables. The keys referenced (SET_OF_BOOKS_FK_KEY, OPERATING_UNIT_FK_KEY, CUSTOMER_FK_KEY, DATE_OF_SNAPSHOT) are foreign-key-style surrogate keys that resolve to the FII warehouse dimensions rather than to native AR tables such as RA_CUSTOMER_TRX_ALL or AR_PAYMENT_SCHEDULES_ALL. The source column AGE_BUCKET drives the pivoting logic, while RECEIVABLE_G and UNAPP_RECEIPT_G supply the monetary measures.

Key Columns

• SOB_ID — Set of Books identifier, the ledger context for the aggregated balances.
• ORG_ID — Operating unit identifier, enabling multi-org security filtering in the portlet.
• CUSTOMER_ID — Customer surrogate key identifying the party whose receivables are aged.
• DATE_OF_SNAPSHOT — The as-of date of the aging calculation; the snapshot grain for the fact.
• BUCKET1 … BUCKET5 — Five mutually exclusive aging buckets. Each holds NVL(RECEIVABLE_G,0) only when AGE_BUCKET equals the matching bucket number; otherwise it returns 0.
• TOTAL_PASTDUE — Sum of all rows where AGE_BUCKET is not 1, i.e. everything beyond the first (current) bucket.
• UNAPP_RECEIPT — Unapplied receipt amount, passed through from UNAPP_RECEIPT_G.
• BALANCE — Net exposure computed as RECEIVABLE_G - UNAPP_RECEIPT_G, both defaulted to zero.

Common Use Cases and Queries

The view is consumed primarily by the Risk Indicator Portlet engine to render aging summaries per customer and operating unit. A typical investigative query joins it to FII dimension views to resolve descriptive names:

• Retrieve total exposure per customer for a given snapshot date.
• Compare past-due versus unapplied receipts to assess net credit risk.
• Feed a portlet aggregation by operating unit for a dashboard tile.

Sample:

SELECT customer_id, date_of_snapshot, bucket1, bucket2, bucket3, bucket4, bucket5, total_pastdue, unapp_receipt, balance FROM apps.fii_ar_aging_wh_v WHERE sob_id = :sob AND org_id = :org AND date_of_snapshot = :snap;

Because it is an internal, unsupported view intended for portlet use, direct dependencies in custom code are discouraged; Oracle may alter its definition between patch levels without notice.