Duplicated Address Name When Loading Data In UCM (Doc ID 1998788.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Universal Customer Master - Version 8.2.2.14 [IP2014] and later
Information in this document applies to any platform.

Symptoms

Customer is using UCM Batch Process to load accounts but it's failing when an existing address is used.

When the address already exists it tries to insert it again and fails with unique constraint violated.

The logs shows something like:

EAISiebAdpt EAISiebAdptTrc 3 00000006551c45c8:0 2015-04-01 16:10:14 Using user key 'User Key:1' (Address Id) for the integration component 'Account_Business Address'
ObjMgrSqlObjLog NamedSearch 5 00000006551c45c8:0 2015-04-01 16:10:14 Begin: SetNamedSearch for SqlObj 'CUT Address' at 181f6650, Named Search: 'Sort Search Optimization' - ''
SELECT /*+ ALL_ROWS */
...
  FROM
      SIEBEL.S_ADDR_PER_UCMX T1,
      SIEBEL.S_CONTACT T2,
      SIEBEL.S_ADDR_PER_SS T3,
      SIEBEL.S_ADDR_PER T4
  WHERE
     T4.ROW_ID = T1.PAR_ROW_ID (+) AND
     T4.ROW_ID = T3.PAR_ROW_ID (+) AND
     T4.PER_ID = T2.ROW_ID (+) AND
     (T4.ED_DELETED_FLG = 'N') AND
     (T4.ROW_ID = :2)
ObjMgrSqlLog Detail 4 00000006551c45c8:0 2015-04-01 16:10:14 Bind variable 2: EDQ33012AST
ObjMgrSqlLog Debug 5 00000006551c45c8:0 2015-04-01 16:10:14 User search spec: [Id] = "EDQ33012AST"

ObjMgrSqlCursorLog Trace 5 00000006551c45c8:0 2015-04-01 16:10:14 SQL Cursor with ID 161175A0 Buscomp: CUT Address, Forward Only: 0, Fetch Rows: 0, Fetch All Time: 0.000 seconds.
ObjMgrLog Error 1 00000006551c45c8:0 2015-04-01 16:10:14 (adptutils.cpp (4286)) SBL-EAI-04378: No rows retrieved corresponding to the business component '<?>'

..
EAISiebAdpt EAISiebAdptTrcBusObj 4 00000006551c45c8:0 2015-04-01 16:10:14 Creating new record in business component 'CUT Address'

...
SQLParseAndExecute Execute 5 00000006551c45c8:0 2015-04-01 16:10:14 ORA-00001: unique constraint (SIEBEL.S_ADDR_PER_U1) violated
ORA-06512: at line 6



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