Results for “ar_misc_cash_distributions_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AR_MISC_CASH_DISTRIBUTIONS_ALL is a Receivables (AR) transaction table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores all accounting distributions (distribution lines) generated for miscellaneous cash applications. When a miscellaneous receipt is created and applied, Oracle Receivables creates accounting entries that determine which general ledger accounts are debited and credited. This table holds those entries, linking each distribution line to the associated cash receipt, cash receipt history record, and GL code combination.

The table resides in the AR schema and is owned by the Receivables product. It is a key component in the AR subledger accounting and posting flow, bridging Receivables receipt processing to Oracle General Ledger. The _ALL suffix indicates that the table supports multiple organizations (multi-org enabled), with the ORG_ID column acting as the operating unit discriminator.

Based on the Data Vault classification heuristics derived from its foreign key structure, this table is satellite-leaning. In Data Vault modeling terms, this suggests the table functions primarily as a descriptive satellite that records attributes and accounting detail about a business event, rather than as a hub or link. The primary key MISC_CASH_DISTRIBUTION_ID anchors each distribution record, while the foreign keys connect it to the broader transaction and accounting graph.

Key Information Stored

The table contains 47 documented columns. The most significant include:

• MISC_CASH_DISTRIBUTION_ID — The surrogate primary key (AR_MISC_CASH_DISTRIBUTIONS_PK). Also enforced as a unique index (AR_MISC_CASH_DISTRIBUTIONS_U1), making it a business-key candidate.
• CASH_RECEIPT_ID — Foreign key to AR_CASH_RECEIPTS_ALL, identifying the parent miscellaneous receipt.
• CASH_RECEIPT_HISTORY_ID — Foreign key to AR_CASH_RECEIPT_HISTORY_ALL, tracking the receipt's status history.
• CODE_COMBINATION_ID — Foreign key to GL_CODE_COMBINATIONS, identifying the accounting flexfield account for the distribution.
• SET_OF_BOOKS_ID — The ledger (set of books) associated with the accounting entry.
• GL_DATE — The GL date on which the distribution is recognized.
• AMOUNT — The distribution amount in the entered currency.
• ACCTD_AMOUNT — The accounted amount in the ledger currency.
• PERCENT — The percentage of the receipt allocated to this distribution.
• GL_POSTED_DATE — The date the entry was posted to General Ledger.
• POSTING_CONTROL_ID — Foreign key to AR_POSTING_CONTROL, governing posting behavior.
• APPLY_DATE — The date the miscellaneous cash was applied.
• EVENT_ID — Reference to the subledger accounting event.
• REVERSAL_GL_DATE — GL date for reversal entries.
• MRC_* columns (MRC_GL_POSTED_DATE, MRC_POSTING_CONTROL_ID, MRC_ACCTD_AMOUNT) — Multiple Reporting Currency (MRC) equivalents for reporting currencies.

Descriptive attributes include COMMENTS, ATTRIBUTE_CATEGORY, ATTRIBUTE1–15, USSGL_TRANSACTION_CODE and its context, CREATED_FROM, and the standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, REQUEST_ID, ORG_ID).

Common Use Cases and Queries

This table is queried most often for reconciliation and accounting audit purposes: verifying that miscellaneous receipts produced the correct GL distributions, tracing a receipt's accounting entries, and checking posting status.

A typical query to retrieve all distributions for a given miscellaneous receipt joins to the receipt and GL account tables:

SELECT mcd.misc_cash_distribution_id,
       mcd.cash_receipt_id,
       mcd.gl_date,
       mcd.amount,
       mcd.acctd_amount,
       mcd.gl_posted_date
FROM   ar_misc_cash_distributions_all mcd
WHERE  mcd.cash_receipt_id = :receipt_id;

To identify unposted distributions (those not yet posted to GL), filter on a null GL_POSTED_DATE:

SELECT mcd.* 
FROM   ar_misc_cash_distributions_all mcd
WHERE  mcd.gl_posted_date IS NULL
AND    mcd.set_of_books_id = :sob_id;

For account-level reporting, join to GL_CODE_COMBINATIONS to resolve the accounting flexfield. Organizations also use this table to validate MRC amounts and to audit reversals via REVERSAL_GL_DATE.

Related Objects

• AR_CASH_RECEIPTS_ALL — joined via CASH_RECEIPT_ID; parent receipt header.
• AR_CASH_RECEIPT_HISTORY_ALL — joined via CASH_RECEIPT_HISTORY_ID; receipt status history.
• GL_CODE_COMBINATIONS — joined via CODE_COMBINATION_ID; accounting flexfield.
• AR_POSTING_CONTROL — joined via POSTING_CONTROL_ID; posting rules for the ledger.
• AR_DISTRIBUTIONS_ALL — references this table via SOURCE_ID; general subledger distributions.
• AR_MC_DISTRIBUTIONS_ALL — references this table via SOURCE_ID; MRC distribution records.
• AR_MC_MISC_CASH_DISTS — references MISC_CASH_DISTRIBUTION_ID; MRC miscellaneous cash distributions.