Search Results overapplication_indicator




Overview
Explore in AI Chat

Overview

AR_INTERIM_CASH_RECEIPTS_V is a Receivables (AR) reporting view owned by the APPS schema. It exposes the interim cash receipt records held in AR_INTERIM_CASH_RECEIPTS, presenting a single denormalized row for each receipt line together with the descriptive attributes of its associated batch, customer, bank, and transaction context. The name of the object reflects its role as the read-only presentation layer over the interim receipt table, which stores receipts before and during the posting cycle.

The ETRM metadata records the object as VALID with a description of "Release 115 Only," indicating that the view originated in Release 11.5 and remains documented as a legacy interface, although it is still resolvable in 12.1.1 and 12.2.2 environments. Its primary value in reporting is that it joins the base receipt record to the surrounding Receivables and Cash Management reference data, so a report or interface can retrieve a fully described receipt without reproducing the joins itself. It is frequently referenced by custom reports, conversion routines, and downstream integration extracts that need receipt-level detail at the batch and customer level.

Underlying Base Objects

The documented base objects span several schemas and modules. The central table is AR_INTERIM_CASH_RECEIPTS, accessed through its synonym, which supplies the receipt amount, currency, date, receipt number, status, and accounting attributes. It is joined to AR_BATCHES for batch name, AR_RECEIPT_METHODS for the receipt method name, AR_RECEIPT_CLASSES, and AR_PAYMENT_SCHEDULES, the latter linking the receipt to the transaction it settles.

Customer and site context is supplied by HZ_CUST_ACCOUNTS, HZ_CUST_SITE_USES, and HZ_PARTIES, while RA_CUSTOMER_TRX and AR_CONS_INV provide transaction and consolidated billing references. Bank data is drawn from CE_BANK_ACCOUNTS, CE_BANK_ACCT_USES, CE_BANK_BRANCHES_V, and IBY_EXT_BANK_ACCOUNTS_V. Lookup decoding uses AR_LOOKUPS and GL_DAILY_CONVERSION_TYPES. Supporting packages documented in the dependency list include ARPT_SQL_FUNC_UTIL and ARP_DEDUCTION, and security or multi-org filtering is handled through FND_ACCESS_CONTROL_UTIL, FND_GLOBAL, FND_PROFILE, MO_GLOBAL, and XTR_USER_ACCESS.

Key Columns

The view exposes the receipt primary key CASH_RECEIPT_ID and the surrogate ROW_ID, and the AMOUNT column is computed as ICR.AMOUNT plus NVL(FACTOR_DISCOUNT_AMOUNT, 0), with NET_AMOUNT carrying the undiscounted value. Descriptive receipt attributes include RECEIPT_NUMBER, RECEIPT_DATE, CURRENCY_CODE, RECEIPT_METHOD_ID, and RECEIPT_METHOD_NAME, together with STATUS for the posting state.

Batch context is provided by BATCH_ID and BATCH_NAME. Transaction linkage is exposed through CUSTOMER_TRX_ID, PAYMENT_SCHEDULE_ID, TRX_NUMBER, and BILLING_NUMBER. Customer detail includes CUSTOMER_NAME (truncated to 50 bytes), CUSTOMER_NUMBER, PAT_FROM_CUSTOMER, SITE_USE_ID, and BILLING_LOCATION. Accounting and currency-conversion attributes include EXCHANGE_DATE, EXCHANGE_RATE, EXCHANGE_RATE_TYPE, EXCHANGE_RATE_TYPE, EXCHANGE_RATE_TYPE_DSP, GL_DATE, GL_POSTED_DATE, ANTICIPATED_CLEARING_DATE, and USSGL_TRANSACTION_CODE. The columns SPECIAL_TYPE, DOC_SEQUENCE_ID, and DOC_SEQUENCE_VALUE support document numbering. Note that overapplication_indicator is not among the columns projected by this view despite being a common search term; users seeking that flag should consult the underlying AR_RECEIVABLE_APPLICATIONS or AR_PAYMENT_SCHEDULES structures.

Common Use Cases and Queries

Typical uses include receipt register reporting, cash application reconciliations, batch-level receipt totals, and data extraction for interfaces requiring customer and bank detail in a single pass.

  • Receipt register by date range: SELECT receipt_number, receipt_date, amount, currency_code, status FROM ar_interim_cash_receipts_v WHERE receipt_date BETWEEN :p_from AND :p_to ORDER BY receipt_date.
  • Batch summary: SELECT batch_name, COUNT(*) receipt_count, SUM(amount) total_amount FROM ar_interim_cash_receipts_v GROUP BY batch_name.
  • Customer receipt detail: SELECT customer_number, customer_name, receipt_number, trx_number, amount, net_amount FROM ar_interim_cash_receipts_v WHERE customer_number = :p_customer.
  • Unposted receipts: SELECT cash_receipt_id, receipt_number, gl_date, status FROM ar_interim_cash_receipts_v WHERE status != 'APP' AND gl_posted_date IS NULL.

Because the view sits over interim data, results reflect receipts at their current stage of the posting lifecycle and should be reconciled against AR_CASH_RECEIPTS for finalized accounting balances.