Search Results ar_cash_receipt_history_all

Overview

The AR_CASH_RECEIPT_HISTORY_ALL table is a core transactional table within Oracle E-Business Suite Receivables (AR) module, versions 12.1.1 and 12.2.2. It serves as the definitive audit trail for the life cycle of a cash receipt. Every significant action or status change performed on a receipt, from its initial entry through final reconciliation and potential reversal, generates a new record in this table. Its primary role is to maintain a chronological history of each receipt's financial and operational state, which is critical for accounting, reporting, troubleshooting, and ensuring a complete audit history. The "_ALL" suffix indicates it is a multi-organization table, storing data for all operating units configured within the instance.

Key Information Stored

The table's structure captures the sequence and details of receipt processing. The primary identifier is CASH_RECEIPT_HISTORY_ID. Each record is linked to a specific receipt via CASH_RECEIPT_ID (foreign key to AR_CASH_RECEIPTS_ALL) and is associated with a status (e.g., 'APPROVED', 'CLEARED', 'REVERSED'). The PRV_STAT_CASH_RECEIPT_HIST_ID column creates a linked list, pointing to the immediate prior history record for the same receipt, enabling reconstruction of its complete status timeline. Key transactional columns include ACCOUNT_CODE_COMBINATION_ID (the cash account), BATCH_ID (link to AR_BATCHES_ALL), and POSTING_CONTROL_ID (link to AR_POSTING_CONTROL for GL transfer). For reversals, REVERSAL_CASH_RECEIPT_HIST_ID and REVERSAL_POSTING_CONTROL_ID track the corresponding reversal entries.

Common Use Cases and Queries

This table is central to receipt inquiry, audit reports, and reconciliation processes. A common use case is tracing the complete history of a receipt to diagnose application or posting issues. Another is identifying receipts in a specific status, such as all 'UNCLEARED' receipts for bank reconciliation. Sample queries include retrieving the current status of a receipt by finding its most recent history record, or listing all status changes for a receipt in chronological order by leveraging the PRV_STAT_CASH_RECEIPT_HIST_ID chain. Reporting often joins this table with AR_CASH_RECEIPTS_ALL, RA_CUSTOMERS, and GL_CODE_COMBINATIONS to produce detailed cash application and accounting reports.

Related Objects

AR_CASH_RECEIPT_HISTORY_ALL has extensive relationships with other Receivables and General Ledger tables. Its primary foreign key dependencies, as per the metadata, are:

• AR_CASH_RECEIPTS_ALL: The master receipt header.
• AR_BATCHES_ALL: The receipt batch.
• GL_CODE_COMBINATIONS (twice): For cash and bank charge accounts.
• AR_POSTING_CONTROL (twice): For posting to the General Ledger.
• Self-referencing Foreign Key: Links history records for the same receipt.

It is also a source for distribution records (AR_DISTRIBUTIONS_ALL, AR_MISC_CASH_DISTRIBUTIONS_ALL) and is referenced by multi-currency objects (AR_MC_CASH_RECEIPT_HIST, AR_MC_RECEIVABLE_APPS), highlighting its central role in the accounting flow.