Search Results note_status




Overview
Explore in AI Chat

Overview

The AR_CASH_RECEIPT_HIST_ALL_MRC_V view in the APPS schema is a Multi-Reporting Currency (MRC) view within the Oracle Receivables (AR) module. It presents cash receipt history records across multiple sets of books, exposing both the primary ledger accounting attributes and their corresponding MRC-denominated equivalents. In Oracle EBS 12.1.1 and 12.2.2, MRC views such as this one are used to report on a single transaction from the perspective of multiple reporting currencies, which is essential for organizations operating under a primary functional currency while requiring translated or entered amounts in secondary ledgers.

The view is a critical integration and reporting object. It is commonly used by subledger accounting extracts, cash management reporting, reconciliation reports, and custom concurrent programs that must report receipts in a reporting currency different from the primary functional currency. Because it filters by the reporting set of books derived from the session's client info, the view is ordinarily queried within a context where the MRC set of books is set for the session.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over two base synonyms:

  • AR_CASH_RECEIPT_HISTORY_ALL — the primary (base) cash receipt history table holding the accounting entries and status information for each receipt in the primary ledger.
  • AR_MC_CASH_RECEIPT_HIST — the MRC table storing the reporting-currency (translated or entered) amounts corresponding to each cash receipt history record.

The join is performed on CASH_RECEIPT_HISTORY_ID, with the MRC side restricted by MC.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),45,10)), -99). This means the view returns the reporting set of books currently indicated in the session's client info, falling back to -99 (no match) when none is set. Primary table columns are prefixed with PRIMARY., while MRC columns are aliased with the MRC_ prefix.

Key Columns

The view exposes a broad set of identification, accounting, and MRC columns:

The ACCOUNT_CODE_COMBINATION_ID column is the identifier linking a receipt's accounting entry to a code combination in the primary ledger, allowing reporting joins to GL_CODE_COMBINATIONS for account derivation.

Common Use Cases and Queries

Typical usages include reconciliation of receipt accounting entries across reporting currencies and reporting of posted cash receipts by account. A representative query retrieving primary and MRC accounting amounts for a given receipt is:

SELECT cash_receipt_id,
       set_of_books_id,
       acctd_amount,
       mrc_acctd_amount,
       exchange_rate,
       gl_date,
       mrc_gl_posted_date,
       account_code_combination_id
  FROM ar_cash_receipt_hist_all_mrc_v
 WHERE cash_receipt_id = :p_cash_receipt_id;

A second common pattern joins the view to GL_CODE_COMBINATIONS to obtain the account string for receipt postings in the reporting currency:

SELECT h.cash_receipt_id,
       gcc.segment1||'.'||gcc.segment2||'.'||gcc.segment3 account
  FROM ar_cash_receipt_hist_all_mrc_v h,
       gl_code_combinations gcc
 WHERE h.account_code_combination_id = gcc.code_combination_id
   AND h.mrc_acctd_amount <> 0;

Because the MRC set of books is derived from the client info, callers must ensure that the correct reporting ledger context is initialized before executing queries. The view is therefore most effective inside EBS forms, concurrent programs, and MRC-aware reports that set the MRC context at runtime.