11.5.x to 12.1.x
A attempting to import customers through Customer Interface (RACUST) and receive the following error:
racinc: inserting customers.
Current system time is 01-DEC-2011 11:23:43
racinc: ORA-00001: unique constraint (AR.HZ_CUST_ACCOUNTS_U2) violated
racinc: Error inserting customers
Customer Interface will not complete.
The system options form is reviewed for this org_id.
The Trans and Customers tab shows that the customer number is NOT being generated by a sequence (the box is not checked).
The column for RA_CUSTOMERS_INTERFACE_ALL.CUSTOMER_NUMBER contains values.
If the box to Auto-generate the account number is NOT checked, this error occurs. The error has nothing to do with the sequence HZ_CUST_ACCOUNTS_S.
Import the records in the table RA_CUSTOMERS_INTERFACE_ALL into a worksheet.
Sort on the column ACCOUNT_NUMBER.
Locate the duplicate account number used for a second account.
Remove the duplicated account numbers.
Run customer interface again and it should progress without error
July 11, 2018