Bills Receivable Remittance Issue: Bills Receivable Stuck in a Failed Remittance Batch and Cannot be Included in Another Remittance Batch (Doc ID 985673.1)

Last updated on MAY 20, 2024

Applies to:

Symptoms

Oracle Receivables (AR): Receipts Workbench Information Center >  Note 985673.1

Oracle Receivables (AR): Transactions Workbench Information Center > Note 985673.1

A Bills Receivable (BR) was selected for remittance in Batch X. However, batch X did not process successfully and now the BR is stuck. It is not yet remitted because the Remittance Batch X failed, nor can it be included in another remittance batch because it has been tagged as reserved by Batch X.

Review of the data in AR_TRANSACTION_HISTORY_ALL shows:

event = SELECTED_REMITTANCE
status = PENDING_REMITTANCE

Review of the remittance batch data in AR_BATCHES_ALL shows:

BATCH_APPLIED_STATUS = COMPLETED_CREATION

However, when navigating to Bills Receivable > Remittances, the batch cannot be queried.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.