SBL-EAI-04381 Error With EAI Siebel Adapter When User Key Contains Special Characters (Doc ID 1198153.1)

Last updated on OCTOBER 12, 2016

Applies to:

Siebel Call Center - Version 8.0 SIA [20405] and later
Siebel CRM - Version 8.0 SIA [20405] and later
Information in this document applies to any platform.


Symptoms

The EAI Siebel Adapter is used to upsert Account / Address data.  The user key field (Street Address) of the child component (Account_Business Address) includes special characters, like hex 0A (linefeed) or 0C (carriage return).

In the first call of the EAI Siebel Adapter upsert, IO is Account > Account_Business Address, and the user key on Account_Business Address includes a field (e.g. Street Address), which may contain hex 0A, all data in created fine.

On second call (upsert) with exactly the same data, EAI Siebel Adapter does not recognize that the address already exists, and tries to create again. So it fails, because the address already exists, with error :-

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.

SBL-EAI-04381: For instance of Integration Component 'Account_Business Address', using user key '[Street Address] = "1234 Bognor Street" AND [City] = "Bognor" AND [State] = "CA"', a record with identical values already exists in the Siebel database.


Please ensure that the field values in the input message 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