Receipts Workbench Issue: Old Remitted Credit Card Receipts Are Picked Up By Auto-Remittance (Doc ID 2021310.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Receivables - Version 12 and later
Information in this document applies to any platform.

Symptoms

After upgrading from 11i to R12 (12.1.3), the Automatic Remittances Creation Program (API) (AUTOREMAPI) is run and the program picked up the Credit Card Receipts migrated from 11i to R12 and remitted them again.

Due to this, the Automatic Remittances Execution Report is failing with the following error:

Capture of credit card transaction failed.
DUPLICATE_SETTLEMENT:

Receipts got REMITTED incorrectly.
AR_CASH_RECEIPT_HISTORY_ALL has CONFIRMED & REMITTED rows twice.
The user created the receipt in CONFIRMED status and REMITTED it in 11i, upgraded to R12, and made it CONFIRMED.
Automatic Remittances Creation Program picked up the receipt and changed it to REMITTED.

You need to change the receipt back to CONFIRMED status.

Fix Approach
================
a. Undo account the accounting entries correspond to the latest CONFIRMED record with Current_record_flag - 'Y' .
b. Delete the latest CONFIRMED record data in AR tables.
c. Mark the latest REMITTED record with Current_record_flag as 'Y' .