Results for “exchange_rate_type”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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.
-
Exchange Rate Types
-
Exchange Rate Types
-
Currency-related information about receipt batches for each reporting set of books
-
Currency-related information about invoice, debit memo, commitment, and credit memo header information
-
Currency-related information about invoice, debit memo, commitment, and credit memo header information
-
Currency-related information about receipts for each reporting set of books
-
Currency-related information about invoice batches for each reporting set of books
-
Detailed invoice records in MRC defined reporting currency
-
Currency-related information about invoice batches for each reporting set of books
-
Currency-related information about receipt batches for each reporting set of books
-
Currency-related information about receipts for each reporting set of books
-
Currency-related information about all transactions except adjustments and miscellaneous cash receipts
-
Invoice payment records in MRC defined reporting currency
-
Currency-related information about all transactions except adjustments and miscellaneous cash receipts
-
This table stores exchange rate tolerances for policy compliance validation.
-
Table: FUN_BAL_LINES_GT 12.2.2
FUN_BAL_LINES_GT is a global temporary table used by the Intercompany Balancing API. Calling modules like SLA and GL populate this table with the details of the journals that needs to be balanced and then invoke the Intercompany Balancing A
-
Detailed invoice records in MRC defined reporting currency
-
This table stores exchange rate tolerances for policy compliance validation.
-
Supplier payment data in MRC defined reporting currency
-
Table: FUN_BAL_LINES_T 12.2.2
FUN_BAL_LINES_T is a temporary table used internally by the Intercompany Balancing API.
-
Invoice header information for interest invoices
-
View: CE_222_TXN_FOR_BATCH_V 12.1.1
Available Remittance Batches for Reconciliation or Clearing.
APPS.CE_222_TXN_FOR_BATCH_V·↳ AR_BATCHES_ALL·↳ AR_CASH_RECEIPTS_ALL·↳ AR_CASH_RECEIPT_HISTORY_ALL·Explore CE module →
-
Invoice payment records in MRC defined reporting currency
-
View: CEFV_ECT 12.2.2
Business View
APPS.CEFV_ECT·↳ CE_999_INTERFACE_V·↳ CE_BANK_ACCOUNTS·↳ GL_DAILY_CONVERSION_TYPES·Explore CE module →
-
Currency-related information about each step in the life cycle of a receipt for each reporting set of books
-
Currency-related information about each step in the life cycle of a receipt for each reporting set of books
-
View: CEBV_ECT 12.1.1
Business View
APPS.CEBV_ECT·↳ CE_999_INTERFACE_V·↳ CE_BANK_ACCOUNTS·↳ GL_DAILY_CONVERSION_TYPES·Explore CE module →
-
Table: FUN_BAL_RESULTS_GT 12.2.2
FUN_BAL_RESULTS_GT is a global temporary table used by the Intercompany balancing API. After balancing an Intercompany journal, the Intercompany balancing API inserts the resulting balancing lines into this table. Calling modules like SLA a
-
View: CE_222_TXN_FOR_BATCH_V 12.2.2
Available Remittance Batches for Reconciliation or Clearing.
APPS.CE_222_TXN_FOR_BATCH_V·↳ AR_BATCHES_ALL·↳ AR_CASH_RECEIPTS_ALL·↳ AR_CASH_RECEIPT_HISTORY_ALL·Explore CE module →
-
Table: AR_CM_FROM_GT 12.2.2
-
This table stores the payment information about payment made to TCS authority.
-
Table: AR_AUTOCLEAR_INTERIM 12.2.2
Temporary table used in the autoclearance parallel process
-
Table: AR_AUTOCLEAR_INTERIM 12.1.1
-
View: CEBV_ECT 12.2.2
Business View
APPS.CEBV_ECT·↳ CE_999_INTERFACE_V·↳ CE_BANK_ACCOUNTS·↳ GL_DAILY_CONVERSION_TYPES·Explore CE module →
-
Table: FUN_BAL_LINES_T 12.1.1
FUN_BAL_LINES_T is a temporary table used internally by the Intercompany Balancing API.
-
Table: FUN_BAL_LINES_GT 12.1.1
FUN_BAL_LINES_GT is a global temporary table used by the Intercompany Balancing API. Calling modules like SLA and GL populate this table with the details of the journals that needs to be balanced and then invoke the Intercompany Balancing A
-
Table: FUN_BAL_INTRA_INT_T 12.2.2
FUN_BAL_IINTRA_INT_T is a temporary table used internally by the Intercompany Balancing API.
-
Table: FUN_BAL_INTRA_INT_GT 12.2.2
FUN_BAL_INTRA_INT_GT is a global temporary table used internally by the Intercompany Balancing API
-
Table: FUN_BAL_INTRA_INT_T 12.1.1
FUN_BAL_IINTRA_INT_T is a temporary table used internally by the Intercompany Balancing API.
-
Table: FUN_BAL_RESULTS_T 12.1.1
FUN_BAL_RESULTS_T is a temporary table used internally by the Intercompany balancing API.
-
Table: FUN_BAL_INTER_INT2_GT 12.2.2
-
Table: FUN_BAL_INTER_INT_GT 12.2.2
FUN_BAL_INTER_INT_GT is a global temporary table used internally by the Intercompany Balancing API.
-
Table: FUN_BAL_INTER_INT_GT 12.1.1
FUN_BAL_INTER_INT_GT is a global temporary table used internally by the Intercompany Balancing API.
-
View: CE_AVAILABLE_BATCHES_V 12.2.2
Available batches for reconciliation
APPS.CE_AVAILABLE_BATCHES_V·↳ CE_200_BATCHES_V·↳ CE_200_GROUPS_V·↳ CE_222_BATCHES_V·Explore CE module →
-
View: CEFV_CASH_FORECASTS 12.2.2
Business View
APPS.CEFV_CASH_FORECASTS·↳ CE_FORECASTS·↳ CE_FORECAST_HEADERS·↳ CE_LOOKUPS·Explore CE module →
-
Business View
APPS.CEFV_BANK_STATEMENT_LINES·↳ CE_LOOKUPS·↳ CE_STATEMENT_HEADERS·↳ CE_STATEMENT_LINES·Explore CE module →
-
Business View
APPS.CEBV_BANK_STATEMENT_LINES·↳ CE_LOOKUPS·↳ CE_STATEMENT_HEADERS·↳ CE_STATEMENT_LINES·Explore CE module →
-
Table: FUN_BAL_RESULTS_T 12.2.2
FUN_BAL_RESULTS_T is a temporary table used internally by the Intercompany balancing API.