Lockbox Error: Lockbox and Autoreconciliation Raises Error: ORA-1: unique constraint (AR.AR_DISTRIBUTIONS_U2) violated
(Doc ID 1556931.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Receivables - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]Information in this document applies to any platform.
Symptoms
Process Lockbox and Autoreconciliation Programs end in Error:
ORACLE error 1 in FDPSTP
Cause: FDPSTP failed due to ORA-1: unique constraint
(AR.AR_DISTRIBUTIONS_U2) violated
ORA-6512: at "APPS.CE_AUTO_BANK_REC", line 408
ORA-6512: at line
and
ARLPLB module: Process Lockboxes
AR-ARMIADJ: Excep Code <3792>
AR-arcctcr: cash_receipt - ORA-00001: restriction unique(AR.AR_DISTRIBUTIONS_
AR-arcrollback: Rollbacked
The error shows that the unique constraint AR.AR_DISTRIBUTIONS_U2 is getting violated during autoreconciliation.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |