Search Results media_reference




Overview
Explore in AI Chat

Overview

AR_BATCHES_MRC_V is an Oracle E-Business Suite Receivables (AR) view owned by the APPS schema and registered as VALID. Its name follows the standard EBS convention for a Multiple Reporting Currencies (MRC) view: it presents batch data for the reporting set of books associated with the current user's session, rather than for the primary set of books. In Release 12, MRC data is stored in parallel columns within the _MC tables, and views such as AR_BATCHES_MRC_V expose that reporting-currency view of the data to forms, reports, and integration interfaces without requiring them to reference the MRC tables directly.

The view is particularly relevant to users searching on LOCKBOX_ID. That column, together with LOCKBOX_BATCH_NAME, identifies the automatic lockbox batch from which receipts were imported, allowing reporting and reconciliation of lockbox transmissions against the resulting receipt batches in the reporting set of books.

Underlying Base Objects

The view is defined over two documented base objects, both exposed through synonyms:

The join condition is MC.BATCH_ID = B.BATCH_ID, combined with a session-level filter on SET_OF_BOOKS_ID derived from USERENV('CLIENT_INFO') and an ORG_ID predicate that resolves the current operating unit using the same client information. Effectively, the view returns the MRC batch rows for the reporting set of books and operating unit that the user's session has established. Because the view text applies these NVL/DECODE constructions with a default of -99, queries executed outside a properly initialized session (for example, from SQL*Plus without client info) may return no rows or unexpected results.

Key Columns

Common Use Cases and Queries

The view is typically used to report lockbox and receipt batch activity in a reporting set of books, to reconcile lockbox transmission totals against batch control amounts, and to feed downstream extracts that must be expressed in a reporting currency. A representative query locating lockbox batches for the current session is:

  • SELECT batch_id, name, lockbox_id, lockbox_batch_name, status, control_count, control_amount, currency_code FROM ar_batches_mrc_v WHERE lockbox_id IS NOT NULL ORDER BY batch_date DESC;
  • SELECT b.name, b.control_amount, mc.exchange_rate, mc.exchange_rate_type FROM ar_batches_mrc_v mc, ar_batches_all b WHERE mc.batch_id = b.batch_id AND mc.lockbox_id IS NOT NULL;
  • SELECT set_of_books_id, COUNT(*) FROM ar_batches_mrc_v GROUP BY set_of_books_id;

Because the view filters on session client info, it should be queried from within an EBS session (forms, concurrent programs) or after initializing the client info environment in a reporting tool. For multi-org or cross-set-of-books extracts, querying the underlying AR_MC_BATCHES and AR_BATCHES_ALL tables directly, with explicit filters, is preferable to relying on the view's implicit session predicates.