My Oracle Support Banner

DNB Import Issue: Error When Loading DNB Data - ORA-00001: Unique Constraint (AR.HZ_IMP_ADDRESSES_SG_U1) Violated (Doc ID 1638954.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Attempting to import the D&B File, the TCA Import - Batch Data Load program and receive the following error:

ARHLSG2W module: TCA Import - Data Load Stage 2

The following SQL error occurred:
ORA-00001: unique constraint (AR.HZ_IMP_ADDRESSES_SG_U1) violated.
---------------------------------------------------------------------------
Start of log messages from FND_FILE
---------------------------------------------------------------------------
Stage 2 WORKER_PROCESS (+)
Retrieved Work unit
wu_os:DNB
from_osr: xxxxxx
to_osr: xxxxxx
debug: P_RERUN = N
debug: l_dml_record.RERUN = N
MATCH_RELATIONSHIPS completed
MATCH_CONTACTS completed
Stage 2 worker: SQLERRM: ORA-00001: unique constraint (AR.HZ_IMP_ADDRESSES_SG_U1) violated
l_msg_data =
---------------------------------------------------------------------------
End of log messages from FND_FILE
---------------------------------------------------------------------------

Exceptions posted by this request:
Concurrent Request for "TCA Import - Data Load Stage 2" has completed with error

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.