Search Results currency_exchange_date




Overview
Explore in AI Chat

Overview

APPS.ARFV_RECEIPT_HISTORIES is a Business Intelligence System (BIS) view in the Oracle E-Business Suite Receivables (AR) module. It exposes receipt history activity in a denormalized, business-friendly form intended for reporting, analysis, and integration rather than transactional maintenance. The view combines receipt-level attributes with the historical status changes recorded for each receipt, providing a longitudinal record of what happened to a receipt after it was created and applied.

The object resides in the APPS schema, is designated VALID, and carries an FND Design Data reference of AR.ARFV_RECEIPT_HISTORIES. The "ARFV" prefix identifies it as a Receivables Business Intelligence System view, consistent with the family of ARFV_* objects used by Oracle Receivables reporting and analytics. Because it is a view and not a table, it is read-only; no direct DML is possible against it, and it is suitable for extraction into reporting schemas or data warehouse loads.

Given the search context of "currency_exchange_rate," this view is notable because it exposes both CURRENCY_EXCHANGE_DATE and CURRENCY_EXCHANGE_RATE at the receipt history level, allowing analysts to reconcile receipt amounts across currencies without joining back to the base receipt tables.

Underlying Base Objects

Per the ETRM dependency documentation, APPS.ARFV_RECEIPT_HISTORIES is defined over four base objects, each referenced through an APPS synonym:

The view is not referenced by any other database object, meaning it sits at the top of its dependency chain and serves purely as a consumption endpoint. This isolation is typical of BIS views, which are designed to be queried directly rather than nested inside other database logic.

Key Columns

Common Use Cases and Queries

Typical uses include receipt status auditing, multi-currency receipt analysis, factoring exposure reporting, and feeding Receivables data into a reporting or warehouse layer.

Retrieve receipt history with exchange rate detail:

  • SELECT receipt_number, cash_receipt_history_id, currency_exchange_rate, currency_exchange_rate_type, currency_exchange_date FROM apps.arfv_receipt_histories WHERE currency_exchange_rate IS NOT NULL;

Summarize activity by operating unit:

  • SELECT operating_unit, COUNT(*) history_rows, SUM(amount) total_amount FROM apps.arfv_receipt_histories GROUP BY operating_unit;

Because the view is read-only and pre-joined, it removes the need to navigate AR_CASH_RECEIPT_HISTORY, AR_CASH_RECEIPTS, and AR_BATCHES manually, making it an efficient source for currency-related receipt reporting.