Search Results ar_mc_batches




Overview
Explore in AI Chat

Overview

The AR_MC_BATCHES table is a Receivables (AR) module table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores currency-related (multiple currency, or "MC") information about receipt batches for each reporting set of books. In an Oracle EBS multi-organization environment, a single receipt batch may be associated with more than one set of books, and each of those reporting contexts requires its own currency conversion attributes. AR_MC_BATCHES serves as the intersection that captures those attributes per batch per book.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure is a link table. It does not hold a standalone business entity of its own; instead it resolves the association between a receipt batch (AR_BATCHES_ALL) and a set of books (GL_SETS_OF_BOOKS), qualifying that association with exchange rate metadata. This classification should be treated as a modeling suggestion rather than a documented Oracle design intent.

Key Information Stored

The documented physical schema (ETRM 12.2.2) comprises five columns. The most important are described below.

  • BATCH_ID — Identifies the receipt batch. This is a foreign key to AR_BATCHES_ALL and forms part of the composite business-key candidate.
  • SET_OF_BOOKS_ID — Identifies the reporting set of books for which the currency information applies. It is a foreign key to GL_SETS_OF_BOOKS and the other part of the composite business-key candidate.
  • EXCHANGE_RATE — The conversion rate applied to translate batch amounts into the reporting currency of the associated set of books.
  • EXCHANGE_DATE — The date on which the exchange rate is effective, determining which rate is used for the conversion.
  • EXCHANGE_RATE_TYPE — The rate type (for example, a user-defined or standard rate type) that identifies which exchange rate definition in Oracle General Ledger applies.

There is no documented single-column surrogate primary key. Instead, the unique index AR_MC_BATCHES_U1 on the column pair (BATCH_ID, SET_OF_BOOKS_ID) functions as the business-key candidate, enforcing that any given batch has at most one currency record per set of books. Because the table has exactly five columns and the two key columns are already accounted for, the remaining three (EXCHANGE_RATE, EXCHANGE_DATE, EXCHANGE_RATE_TYPE) are the descriptive attributes.

Common Use Cases and Queries

Typical usage centers on reconciling receipt batches across reporting currencies and validating that the correct exchange rate and rate type were applied.

  • Reporting batch-level currency conversion details for a given set of books.
  • Auditing exchange rate discrepancies between batches.
  • Joining to AR_BATCHES_ALL to obtain batch names, statuses, and dates alongside their currency attributes.

A representative query joining the batch and book masters:

SELECT b.batch_id, b.name, m.set_of_books_id, m.exchange_rate, m.exchange_date, m.exchange_rate_type
FROM ar_mc_batches m
JOIN ar_batches_all b ON b.batch_id = m.batch_id
WHERE m.set_of_books_id = :set_of_books_id;

A rate audit pattern filters on rate type and effective date:

SELECT batch_id, set_of_books_id, exchange_rate
FROM ar_mc_batches
WHERE exchange_rate_type = :rate_type
AND exchange_date BETWEEN :start_date AND :end_date;

Related Objects

The following objects are most significant in relation to AR_MC_BATCHES, based on the documented foreign key relationships.

  • AR_BATCHES_ALL — The receipt batch master. Joined via AR_MC_BATCHES.BATCH_ID = AR_BATCHES_ALL.BATCH_ID.
  • GL_SETS_OF_BOOKS — The set of books master. Joined via AR_MC_BATCHES.SET_OF_BOOKS_ID = GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID.
  • GL_DAILY_RATES — Provides the exchange rate values referenced by EXCHANGE_RATE_TYPE and EXCHANGE_DATE.
  • AR_RECEIPT_METHODS — Defines receipt methods associated with the parent batch for reporting context.
  • AR_CASH_RECEIPTS_ALL — The receipt transactions belonging to the batches whose currency details are held here.
  • FND_CURRENCIES — Supplies currency definitions used to interpret converted amounts.

Together these objects allow currency-converted receipt batch reporting across the sets of books configured in the E-Business Suite instance.