Search Results unapp_receipt_g




Overview
Explore in AI Chat

Overview

The view APPS.FII_AR_UNAPP_REC_PMV is an internal database object delivered with the Oracle Financial Intelligence (FII) product family in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It is not an end-user reporting object in the conventional sense, but rather a supporting data structure used to feed the Risk Indicator Portlets that form part of the Financial Intelligence dashboards. In the context of a user search for "unapp_receipt_g", this view is directly relevant because it exposes a column of that exact name, UNAPP_RECEIPT_G, which carries the unapplied receipt amount expressed in the functional currency.

The view filters and reshapes data from a larger installment-level fact object to isolate a specific risk condition: receipts that remain unapplied. By restricting rows to those where UNAPP_RECEIPT_G is non-zero and where the record TYPE equals 'P', the view presents only receipts with an outstanding unapplied balance. This makes it suitable for populating aging, exposure, and risk indicator metrics within the Financial Intelligence risk framework.

Underlying Base Objects

According to the documented view text, FII_AR_UNAPP_REC_PMV is defined over a single underlying object, the Financial Intelligence fact structure FII_AR_OPEN_INSTALLMENT_F. The view is a straightforward projection and filter against that fact:

  • It selects a fixed set of columns from FII_AR_OPEN_INSTALLMENT_F (aliased as F).
  • It applies the predicate F.UNAPP_RECEIPT_G <> 0 to exclude receipts with no unapplied amount.
  • It further restricts rows to F.TYPE = 'P', isolating a receipt-related record type.

The ETRM metadata lists no additional referenced base objects beyond this fact, and no other joins are present in the documented SQL. No base tables were separately documented, so the view's lineage is expressed entirely through FII_AR_OPEN_INSTALLMENT_F. In a normal Financial Intelligence implementation, that fact is populated by ETL processes that extract open installment and receipt data from Oracle Receivables and related subledger sources.

Key Columns

  • SOB_ID — Set of Books identifier (SET_OF_BOOKS_FK_KEY), the accounting ledger context for the record.
  • ORG_ID — Operating unit identifier (OPERATING_UNIT_FK_KEY), used for multi-org security and filtering.
  • CUSTOMER_ID — Customer identifier (CUSTOMER_FK_KEY).
  • CUSTOMER_NAME — Name of the customer associated with the receipt.
  • RECEIPT_NUMBER — The receipt document number.
  • DEPOSIT_DATE — Date the receipt was deposited, useful for aging unapplied receipts.
  • FUNCTIONAL_CURRENCY — Ledger functional currency of the amount.
  • INVOICE_CURRENCY — Currency in which the related transaction was denominated.
  • UNAPP_RECEIPT_G — Unapplied receipt amount in the functional currency; the principal measure exposed by this view and the object of the user's search term.

Common Use Cases and Queries

The primary use case is risk monitoring of unapplied cash. Portlets query this view to surface customers or operating units with significant unapplied receipts, supporting cash-management and credit-risk analysis. Typical queries include:

  • Listing all unapplied receipt rows for an operating unit: SELECT customer_name, receipt_number, deposit_date, unapp_receipt_g FROM fii_ar_unapp_rec_pmv WHERE org_id = :p_org_id.
  • Aggregating unapplied amounts by customer: SELECT customer_id, customer_name, SUM(unapp_receipt_g) FROM fii_ar_unapp_rec_pmv GROUP BY customer_id, customer_name.
  • Aging unapplied receipts by deposit date for a given ledger: SELECT receipt_number, deposit_date, unapp_receipt_g FROM fii_ar_unapp_rec_pmv WHERE sob_id = :p_sob_id AND deposit_date < :p_as_of_date.

Because the view is internal and reserved for Risk Indicator Portlets, customers should treat it as read-only and avoid modifying or building critical customizations directly upon it, since its definition may change between patch levels.