Last updated on JUNE 07, 2016
Applies to:Oracle Receivables - Version 18.104.22.168 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Process Lockbox and Autoreconciliation Programs end in Error:
ORACLE error 1 in FDPSTP
Cause: FDPSTP failed due to ORA-1: unique constraint
ORA-6512: at "APPS.CE_AUTO_BANK_REC", line 408
ORA-6512: at line
ARLPLB module: Process Lockboxes
AR-ARMIADJ: Excep Code <3792>
AR-arcctcr: cash_receipt - ORA-00001: restriction unique(AR.AR_DISTRIBUTIONS_
The error shows that the unique constraint AR.AR_DISTRIBUTIONS_U2 is getting violated during autoreconciliation.
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