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).
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



Next
This is the most recent post.
Older Post
 
Related Posts Plugin for WordPress, Blogger...