My Oracle Support Banner

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

Last updated on JULY 10, 2023

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.

Changes

 

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.