Data Quality: UCM Batch Process: 'ORA-00001: unique constraint (SIEBEL.S_ADDR_PER_U1) violated' Error When Inserting Address. (Doc ID 1678360.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.2.2.3 SIA [23021] and later
Information in this document applies to any platform.

Symptoms

When running a UCMBatchProcess job against an SDH record that contains an Address that is similar to an existing one in S_ADDR_PER, but where only the Postal Code value differs, an error such as the following is encountered:

...
ObjMgrBusCompLog Error 1 0000000651de2224:0 2013-07-11 04:26:47 (oracon.cpp (3870)) SBL-DBC-00111: An error has occurred writing to a record.
Please continue or ask your systems administrator to check your application configuration if the problem persists.

SQLParseAndExecute Execute 5 0000000651de2224:0 2013-07-11 04:26:47 ORA-00001: unique constraint (SIEBEL.S_ADDR_PER_U1) violated
ORA-06512: at line 6

ObjMgrBusCompLog Error 1 0000000651de2224:0 2013-07-11 04:26:47 (oracon.cpp (893)) SBL-DAT-00381: A record that contains identical values to the record you have created already exists.
If you would like to enter a new record, please ensure that the field values are unique.

ObjMgrBusCompLog Error 1 0000000651de2224:0 2013-07-11 04:26:47 (oracon.cpp (2299)) SBL-DAT-00382: The same values for 'Address Name' already exist.
If you would like to enter a new record, please ensure that the field values are unique.
...

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