My Oracle Support Banner

Tca Import - Batch Data Load Program Errors (Doc ID 1212635.1)

Last updated on FEBRUARY 21, 2019

Applies to:

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

Symptoms


11.5.10Cu2.

When trying to import the D&B File, the TCA Import - Batch Data Load program is erroring out

ARHLWRPB module: TCA Import - Batch Data Load

LOAD_PARTIES successfully
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 =

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.