Search Results currency_exchange_rate_date




Overview
Explore in AI Chat

Overview

ARBV_CASH_RECEIPTS is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite, registered under FND Design Data AR.ARBV_CASH_RECEIPTS. Its status is VALID across Oracle EBS 12.1.1 and 12.2.2. The view presents information about receipts remitted by customers as payment for goods or services, exposing receipt header attributes in a denormalized, report-friendly form. Because it is a BIS view rather than a transactional table, it is intended primarily for operational reporting, ad hoc enquiry, and downstream integration where a stable, human-readable projection of the Accounts Receivable receipt header is required without joining the full normalized model. The leading "B" in the object prefix identifies it as a business intelligence view in the EBS naming convention, distinguishing it from the underlying transactional entity.

Underlying Base Objects

The documented view metadata for 12.2.2 records a single referenced base object: the synonym AR_CASH_RECEIPTS, which resolves to the AR.AR_CASH_RECEIPTS transactional table in the Accounts Receivable schema. AR_CASH_RECEIPTS is the master receipt header table in Oracle Receivables; it stores one row per cash receipt, including receipt number, amount, date, currency, exchange rate information, deposit details, remittance bank account, and reversal attributes. ARBV_CASH_RECEIPTS is therefore a direct projection over that header table, with no documented dependency on receipt application, distribution, or accounting line tables. This structure means the view returns header-level receipt information only; applied amounts, unapplied balances, and accounting entries must be obtained from their respective detail objects such as AR_RECEIVABLE_APPLICATIONS_ALL and AR_CASH_RECEIPT_HISTORY. The synonym inheritance ensures the view remains consistent with the base table's column definitions, including length and mandatory constraints as published in the ETRM metadata.

Key Columns

The view exposes core receipt identifiers and financial attributes:

Common Use Cases and Queries

Typical applications include cash position reporting, note receivable maturity tracking, reversal analysis, and reconciliation feeds into general ledger or treasury systems. A standard enquiry retrieves note receivable receipts with their issue dates:

SELECT CASH_RECEIPT_ID, RECEIPT_NUMBER, RECEIPT_AMOUNT, RECEIPT_DATE, CURRENCY_CODE, NOTE_RECEIVABLE_ISSUER_NAME, NOTE_RECEIVABLE_ISSUE_DATE FROM APPS.ARBV_CASH_RECEIPTS WHERE NOTE_RECEIVABLE_ISSUE_DATE IS NOT NULL AND RECEIPT_STATUS_CODE = 'APP' ORDER BY NOTE_RECEIVABLE_ISSUE_DATE;

The view can also be used for reversal monitoring (filtering on REVERSAL_DATE) and for period cash summaries grouped by org_id, currency_code, and receipt_date. When more granular application, distribution, or accounting detail is needed, ARBV_CASH_RECEIPTS should be joined to the corresponding detail objects on CASH_RECEIPT_ID, since the view itself provides header-level information only.