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 JULY 12, 2017

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:

---------------------------------------------------------------------------
Receivables: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
ARHLSG2W module: TCA Import - Data Load Stage 2
---------------------------------------------------------------------------
Current system time is 20-MAR-2014 03:51:17
---------------------------------------------------------------------------
**Starts**20-MAR-2014 03:51:18
**Ends**20-MAR-2014 03:51:24
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:610125916
to_osr:620875166
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
---------------------------------------------------------------------------
Executing request completion options...

Output file size:
0

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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms