Release
|
Cause
|
Fix
|
11.5.x to 12.1.x
|
Attempting to insert
contacts through the Customer Interface program and receive the following
error:
racict: Error inserting contacts. ORA-00001: unique constraint (AR.HZ_PARTIES_U2) violated |
When inserting
contacts using user-supplied customer and party numbers
(add party number into PARTY_NUMBER field in
ra_customers_interface_all)
Profile option HZ: Generate Party Number: Default value (No) The sequence number (HZ_PARTY_NUMBER_S), which is used for automatically generating the party_number for contacts is conflicting with the party numbers that are being
imported (which represents the party_number
for actual parties that own customers)
through the Customer Interface.
Customer Interface is not designed to supply a contact number, it's always generated automatically through the sequence HZ_PARTY_NUMBER_S |
11.5.x to 12.1.x
|
Attempting to import
customers using Customer Interface (RACUST) and receive the following error:
ORA-00001 running
Customer Interface
racina: ORA-00001: unique constraint (AR.HZ_LOCATIONS_PK) violated racina: Error inserting addresses. |
The Customer Interface
process is attempting to insert an existing location_id in the HZ_LOCATIONS
table
|
11.5.x to 12.1.x
|
Customer Interface
fails with the following error in the log file:
racina: inserted 2173 account sites racina: updated 0 account sites racina: ORA-00001: unique constraint (AR.HZ_PARTY_SITES_U2) violated racina: Error inserting addresses. |
The profile option HZ:
Generate Party Site Number was set to NULL
|
11.5.x to 12.1.x
|
Running the Customer
Interface and receive the following error:
racina: ORA-00001: unique constraint(AR.HZ_PARTY_SITES_U2) violated |
This error is due to
the next site number generated using HZ_PARTY_SITE_NUMBER_S is less than the
max (party_site_number) (i.e. already used).
|
12.0.x
|
When multiple Accounts
are Imported using Customer Interface for a Bank Branch, which is new to the
system, Customer Interface fails with the following:
racibb: ORA-00001: unique constraint (AR.HZ_CODE_ASSIGNMENTS_U2) violated racibb: Error inserting bank branches |
This issue has been
addressed in R12
RACUST ERROR CREATING BANK BRANCHES HZ_CODE_ASSIGNMENTS_U2 VIOLATED
|
11.5.x to 12.1.x
|
Attempting to run the
Customer Interface and receive the following error:
racinc: ORA-00001: unique constraint (AR.HZ_CUST_ACCOUNTS_U2) violated |
There is a restriction
on the sequence numbers for customer accounts
|
July 10, 2018
