Receipts Workbench Issue: Old Remitted Credit Card Receipts Are Picked Up By Auto-Remittance
Last updated on JULY 08, 2015
Applies to:Oracle Receivables - Version 12 and later
Information in this document applies to any platform.
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.
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.
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' .
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms