Search Results crh_current




Overview
Explore in AI Chat

Overview

FII_AR_CASH_FCV is an internal Oracle E-Business Suite view that belongs to the Financial Intelligence (FII) product family. Within the ETRM metadata it is classified as obsolete and is explicitly described as an internal view used to support the Operations Indicators Portlet. The view is therefore not part of the supported Oracle Receivables transactional schema, nor is it documented as a general-purpose reporting object. Its purpose is narrow: it reshapes cash receipt data into the flattened, denormalized form expected by the Financial Intelligence dashboard layer, with surrogate keys, concatenated instance codes, and precomputed base-currency cash amounts suitable for slicing by portlet dimensions.

The view is not implemented in the reference database documented by ETRM, and no base objects are formally documented against it. As an FII object, it would typically be deployed only where the Financial Intelligence application has been installed and configured. The 12.1.1 and 12.2.2 releases share the same FII architecture, so the view's behavior does not materially differ between the two releases; both are subject to the same obsolescence caveat. The searched term ar_cash_receipt_history_all is directly relevant because that table supplies the posted-date and current-record logic that drives the view's grain.

Underlying Base Objects

Although ETRM documents no referenced base objects, the published view text defines a fixed join across six sources:

Receipts with a status of NSF, REV, or STOP are excluded, as are receipts whose confirmed flag is not 'Y' (nulls default to confirmed).

Key Columns

  • CASH_RECEIPT_ID — the receipt identifier and primary grain of the view.
  • SET_OF_BOOKS_ID / SET_OF_BOOKS_FK — the ledger identifier, with the foreign key form combining the ledger and instance code.
  • CUSTOMER_FK — a concatenated key of pay-from customer, instance code, and the literal 'CUST_ACCT-TPRT', or 'NA_EDW' when no customer is present.
  • ORG_FK — org identifier concatenated with the instance code.
  • GL_DATE — the GL date of the first posted history record, truncated to day.
  • GL_DATE_FILTER — the untruncated first-posted GL date, retained for range filtering.
  • RECEIPT_DATE — the receipt date from the receipt header.
  • BASE_CURRENCY — the set of books currency code.
  • CASH_B — net accounted cash, computed as ACCTD_AMOUNT_DR minus ACCTD_AMOUNT_CR with nulls treated as zero.

Common Use Cases and Queries

The view is intended for the Operations Indicators Portlet rather than ad hoc reporting. Direct querying is possible but unsupported, and it will raise ORA-00942 wherever FII is not installed. A representative query mirrors the portlet's typical aggregation:

  • Cash receipts by ledger and currency: SELECT set_of_books_fk, base_currency, SUM(cash_b) FROM fii_ar_cash_fcv GROUP BY set_of_books_fk, base_currency;
  • Receipts posted within a period: SELECT cash_receipt_id, gl_date, cash_b FROM fii_ar_cash_fcv WHERE gl_date_filter BETWEEN :start_date AND :end_date;
  • Customer-level cash activity: SELECT customer_fk, COUNT(*), SUM(cash_b) FROM fii_ar_cash_fcv GROUP BY customer_fk;

Because the view joins AR and GL base tables and filters on current and first-posted history flags, it is read-only and reflects posted, confirmed receipts only. For production reporting, Oracle Receivables standard views and the AR_CASH_RECEIPT_HISTORY_ALL table should be used directly instead of this obsolete FII artifact.