Search Results ar_mc_misc_cash_dists




Overview
Explore in AI Chat

Overview

The AR_MC_MISC_CASH_DISTS table is a core technical object within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Receivables (AR) module. Its primary role is to store multi-currency and accounting information for miscellaneous cash applications across different reporting sets of books. This table is essential in multi-organization and global enterprise deployments where financial transactions must be accounted for in multiple ledgers or currencies. It acts as a supporting table that holds the detailed accounting distributions generated when miscellaneous cash receipts—payments not directly tied to a specific invoice, such as deposits or write-offs—are applied. The table's existence is a direct result of the system's need to maintain separate accounting records per reporting set of books for a single transactional event.

Key Information Stored

The table's structure is defined by its composite primary key and its foreign key relationships. The most critical columns include the composite primary key columns, MISC_CASH_DISTRIBUTION_ID and CASH_RECEIPT_ID, which together uniquely identify a distribution record. The SET_OF_BOOKS_ID column is fundamental, storing the identifier for the specific reporting ledger for which the accounting entries are recorded. The POSTING_CONTROL_ID links to the AR_POSTING_CONTROL table, managing the posting status of these distributions to the General Ledger. Other columns typically found in such distribution tables (implied by its purpose) would store accounted amounts in both transaction and functional currency, the accounted date, and the specific General Ledger code combination IDs (e.g., for cash, unapplied, or on-account accounts).

Common Use Cases and Queries

This table is primarily accessed for reconciliation, audit, and reporting purposes related to multi-currency cash applications. A common scenario involves tracing the accounting impact of a miscellaneous cash receipt across all reporting ledgers. For instance, an auditor may need to verify that the total accounted amount for a receipt matches across the primary and secondary sets of books. A typical query would join AR_MC_MISC_CASH_DISTS to AR_CASH_RECEIPTS_ALL to get receipt details and to GL_SETS_OF_BOOKS for the ledger name. Developers might also query this table to identify unposted distributions (via POSTING_CONTROL_ID) during period-end closing procedures or to build custom reports that show miscellaneous cash accounting by ledger. Sample SQL would filter on CASH_RECEIPT_ID or join through AR_MISC_CASH_DISTRIBUTIONS_ALL to the original miscellaneous cash distribution line.

Related Objects

The table has well-defined foreign key relationships, making it a central link between transactional, accounting, and control tables. The documented relationships are:

  • AR_MISC_CASH_DISTRIBUTIONS_ALL: The source transaction line. Joined via MISC_CASH_DISTRIBUTION_ID.
  • AR_CASH_RECEIPTS_ALL: The parent cash receipt. Joined via CASH_RECEIPT_ID.
  • GL_SETS_OF_BOOKS: The reporting ledger. Joined via SET_OF_BOOKS_ID.
  • AR_POSTING_CONTROL: The posting batch control. Joined via POSTING_CONTROL_ID.
These relationships indicate that for every miscellaneous cash distribution created in AR_MISC_CASH_DISTRIBUTIONS_ALL, one or more corresponding accounting records are created in AR_MC_MISC_CASH_DISTS—one for each relevant reporting set of books.