Search Results ar_misc_cash_distributions_all




Overview
Explore in AI Chat

Overview

The AR_MISC_CASH_DISTRIBUTIONS_ALL table is a core data object within Oracle E-Business Suite Receivables (AR), specifically in versions 12.1.1 and 12.2.2. It serves as the central repository for all accounting entries generated from miscellaneous cash applications. When a user applies a cash receipt to a non-standard destination, such as a general ledger account for unapplied cash, on-account credits, or miscellaneous income, the system creates distribution records in this table. These records are critical for ensuring accurate financial accounting and reconciliation, as they capture the detailed accounting impact (debits and credits) of cash receipt activities that fall outside standard invoice applications. The table is multi-org enabled, as indicated by the '_ALL' suffix, meaning it stores data for all operating units.

Key Information Stored

The table's primary purpose is to store the accounting distributions for miscellaneous cash. Its structure is defined by key columns that link to other fundamental entities and hold monetary and descriptive data. The primary key is MISC_CASH_DISTRIBUTION_ID, which uniquely identifies each distribution line. Essential foreign key columns establish critical relationships: CASH_RECEIPT_ID links to AR_CASH_RECEIPTS_ALL, identifying the source receipt; CASH_RECEIPT_HISTORY_ID references AR_CASH_RECEIPT_HISTORY_ALL for the specific receipt activity; and CODE_COMBINATION_ID points to GL_CODE_COMBINATIONS, defining the accounted general ledger segment. The SET_OF_BOOKS_ID column ties the entry to the applicable ledger. The table also stores the accounted amount (AMOUNT) for the distribution line, which is posted to the general ledger.

Common Use Cases and Queries

This table is pivotal for auditing, troubleshooting, and generating detailed reports on cash accounting. A common scenario involves tracing the full accounting impact of a specific cash receipt to ensure all miscellaneous applications are properly recorded. For instance, an auditor may run a query to list all miscellaneous distributions for a receipt to verify postings. Another frequent use case is period-end reconciliation, where accountants need to review all miscellaneous cash entries posted to specific GL accounts within a date range. Sample SQL to retrieve key distribution details often joins with related cash receipt and code combination tables:

  • SELECT armcd.misc_cash_distribution_id, armcd.amount, arcrh.trx_date, gcc.segment1 FROM ar_misc_cash_distributions_all armcd JOIN ar_cash_receipt_history_all arcrh ON armcd.cash_receipt_history_id = arcrh.cash_receipt_history_id JOIN gl_code_combinations gcc ON armcd.code_combination_id = gcc.code_combination_id WHERE arcrh.cash_receipt_id = :p_receipt_id;

Related Objects

As per the provided metadata, AR_MISC_CASH_DISTRIBUTIONS_ALL has integral relationships with several other core Receivables and General Ledger tables. It is a direct child of AR_CASH_RECEIPTS_ALL and AR_CASH_RECEIPT_HISTORY_ALL, sourcing its transactional context. Its link to GL_CODE_COMBINATIONS is essential for accounting. Furthermore, it acts as a source for distribution summarization and multicurrency accounting. The metadata specifies that its primary key (MISC_CASH_DISTRIBUTION_ID) is referenced as a foreign key by AR_MC_MISC_CASH_DISTS for multicurrency records. Additionally, its rows are linked as the SOURCE_ID for entries in the central distribution tables AR_DISTRIBUTIONS_ALL and AR_MC_DISTRIBUTIONS_ALL, integrating it into the broader AR accounting engine.