Search Results fii_ar_receipts_f




Overview
Explore in AI Chat

Overview

FII_AR_RECEIPTS_F is a fact table within the Oracle Financial Intelligence (FII) product, a legacy Business Intelligence offering that has since been classified as obsolete. In Oracle EBS 12.1.1 and 12.2.2, the table resides in the FII schema and stores transactional facts related to customer receipts and credit memos drawn from Oracle Receivables. Its documented purpose is to consolidate receipt, application, and credit memo activity into a denormalized fact structure for analytical reporting.

The ETRM metadata records the table as "Not implemented in this database" in the current environment, indicating that it is a historical artifact from earlier FII releases rather than an actively maintained object. Commercial customers on 12.1.1 and 12.2.2 should treat this table as read-only reference material for legacy ETL logic or archival reporting.

Based on the mined foreign key structure, the table classifies heuristically as a standalone data vault object. It is a fact or transaction-level table rather than a hub, link, or satellite in the strict Data Vault sense, because its primary key is a transactional surrogate and it carries a mixture of dimensional references and numeric measures.

Key Information Stored

The table contains 52 columns in the documented 12.1.1 schema. The primary key is FII_AR_RECEIPTS_F_PK, defined on the single column RECEIVABLE_APPLICATION_ID, which is a surrogate identifier sourced from the receivables application records. No separate business-key unique index is documented, so RECEIVABLE_APPLICATION_ID serves as the sole documented key candidate.

Common Use Cases and Queries

Analysts typically use this table for receipt application analysis, credit memo reconciliation, and multi-currency collections reporting. A representative query joins the fact to the customer dimension and summarizes applied amounts by period:

SELECT c.customer_name, SUM(f.amount_applied_trx_func)
FROM fii.fii_ar_receipts_f f, ar.hz_cust_accounts c
WHERE f.bill_to_customer_id = c.cust_account_id
AND f.apply_date BETWEEN :p_start AND :p_end
GROUP BY c.customer_name;

Other common patterns include aging of applied versus unapplied receipts, drill-through to CASH_RECEIPT_ID in AR_CASH_RECEIPTS, and reconciliation of earned versus unearned discounts by transaction. Because the object is obsolete, reports built on it should be migrated to the corresponding Oracle BI Applications or Financials data model whenever possible.

Related Objects

The documented foreign key links FII_AR_RECEIPTS_F.RECEIPT_METHOD_ID to AR_RECEIPT_METHODS, providing the primary master-detail relationship for receipt method lookup. Beyond this documented relationship, the columns reference the core Oracle Receivables tables: AR_CASH_RECEIPTS via CASH_RECEIPT_ID, AR_RECEIVABLE_APPLICATIONS via RECEIVABLE_APPLICATION_ID, and RA_CUSTOMER_TRX_ALL via CUSTOMER_TRX_ID and APPLIED_CUSTOMER_TRX_ID. Customer records are referenced through BILL_TO_CUSTOMER_ID and COLLECTOR_BILL_TO_CUSTOMER_ID against HZ_CUST_ACCOUNTS. The TIME_ID column maps to the FII time dimension, and ORG_ID maps to the operating unit dimension. These relationships make the table a bridge between FII reporting structures and the operational Receivables tables.