Case 00033515 – AR Interim Cash Receipt Stuck in Incomplete Batch

AR Interim Cash Receipt Stuck in Incomplete Batch

Case Number	00033515
Oracle Module	Accounts Receivable (AR)
EBS Version	R12
Functional Area	Cash Receipts / Batch Processing
Related Patches	None

Symptoms

A cash receipt batch is stuck with an incorrect status and cannot be closed or reprocessed.
Interim cash receipt records exist in AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL that should have been processed and removed.
The batch's control_amount and control_count do not match the actual applied receipts.
Users cannot post or close the batch through the Receipts workbench.

Root Cause

During AutoLockbox or manual receipt batch processing, the batch's interim records were not properly cleaned up after the receipts were applied. The interim tables (AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL) retained stale rows, and the batch header in AR_BATCHES_ALL was not updated to reflect the correct status (CL — Closed) and reconciled control amounts.

Resolution

Step 1 – Create backup tables

Run data_fix.sql. The script creates backups:

rsi_ar_int_rcps_<case> — snapshot of AR_INTERIM_CASH_RECEIPTS_ALL
rsi_ar_int_rcps_lines_<case> — snapshot of AR_INTERIM_CASH_RCPT_LINES_ALL
rsi_ar_batch_<case> — snapshot of AR_BATCHES_ALL

Step 2 – Delete orphaned interim receipt records

Delete the stale rows from AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL for the affected cash receipt ID.

Step 3 – Update batch status and control totals

Update AR_BATCHES_ALL for the affected batch:

Set status = 'CL' (Closed)
Set batch_applied_status = 'PROCESSED'
Recalculate control_amount from the sum of actual AR_CASH_RECEIPT_HISTORY_ALL amounts for the batch
Recalculate control_count from the count of actual receipts in the batch

Step 4 – Commit and validate

Issue COMMIT. Verify the batch now shows Closed status and balanced control totals in the AR Receipts workbench.

Script Inventory

File	Description
data_fix.sql	Creates backups; deletes orphaned interim cash receipt and line records; updates the batch to Closed status with recalculated control amount and count.

Key Tables Affected

Table	Action
AR_INTERIM_CASH_RECEIPTS_ALL	Delete orphaned interim receipt
AR_INTERIM_CASH_RCPT_LINES_ALL	Delete orphaned interim receipt lines
AR_BATCHES_ALL	Update status to CL, batch_applied_status, control_amount, control_count