Total Pageviews

July 11, 2018

7/11/2018 02:25:00 PM
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).
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

Related Posts Plugin for WordPress, Blogger...