Search Results ar_mc_distributions_all




Overview
Explore in AI Chat

Overview

The AR_MC_DISTRIBUTIONS_ALL table is a core data object within the Oracle E-Business Suite Receivables (AR) module, specifically for versions 12.1.1 and 12.2.2. It functions as the multi-currency ledger for cash receipt-related accounting distributions. Its primary role is to store the currency-specific accounting details generated during the various transactional steps in a cash receipt's life cycle, such as application, adjustment, or miscellaneous cash entry. This table is essential for maintaining accurate financial records in environments operating with multiple currencies, ensuring that each distribution retains its original transaction currency amounts alongside converted functional currency amounts for the designated set of books.

Key Information Stored

The table's structure is defined by a composite primary key (LINE_ID, SET_OF_BOOKS_ID), anchoring each multi-currency record to a specific distribution line and ledger. Critical columns include LINE_ID, which links to the base distribution in AR_DISTRIBUTIONS_ALL, and SET_OF_BOOKS_ID, identifying the applicable ledger. Currency information is captured through CURRENCY_CODE (the transaction currency) and columns for AMOUNT, ACCTD_AMOUNT (the amount in the ledger's functional currency), and potentially exchange rate details. The SOURCE_ID and SOURCE_TYPE columns are pivotal, as they identify the originating transaction—such as a cash receipt history, receivable application, or adjustment—by referencing various source tables. Other significant columns include CODE_COMBINATION_ID for the accounting flexfield, THIRD_PARTY_ID for the customer account, and TAX_GROUP_CODE_ID for tax tracking.

Common Use Cases and Queries

This table is central to reconciliation, audit reporting, and troubleshooting accounting entries for international transactions. A common use case is tracing the complete accounting impact of a cash receipt across ledgers. For example, to retrieve all multi-currency distributions for a specific cash receipt, one might join through AR_CASH_RECEIPT_HISTORY_ALL. Another critical report involves verifying foreign currency gains or losses by comparing original and accounted amounts. A sample query pattern to analyze distributions by source type and currency would be:

  • SELECT source_type, currency_code, amount, acctd_amount, set_of_books_id
  • FROM ar_mc_distributions_all
  • WHERE third_party_id = :cust_account_id
  • ORDER BY source_type, line_id;

Such queries are fundamental for period-end closing procedures and ensuring the integrity of multi-currency general ledger postings.

Related Objects

AR_MC_DISTRIBUTIONS_ALL maintains extensive foreign key relationships, acting as a hub connecting transactional data with core master and accounting tables. The documented relationships are as follows: