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 JUNE 07, 2016

Applies to:

Oracle Receivables - Version: 11.5.10.2 and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.
Form:ARBRREMI.FMB - Bills Receivable Remittances

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms