Receipts Workbench: Automatic Remittance Failing With Error Exception : autoremapi() ORA-00001: unique constraint (Doc ID 1472078.1)

Last updated on APRIL 06, 2017

Applies to:

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

Symptoms

Attempting to run the Automatic Remittance process and it completes with the following error:

Exception : create_and_update_remit_rec()
error code() -1
Exception : autoremapi() ORA-00001: unique constraint
(AR.AR_CASH_RECEIPT_HISTORY_U2) violated
Exception : autoremapi()
error code() -1

Receipt has multiple confirmed records that have current_record_flag = Y.

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