My Oracle Support Banner

EAI Siebel Adapter Trying to Insert a New Grandchild Record Rather Than Update the Existing Record Causing Identical Values Error. (Doc ID 1609659.1)

Last updated on MARCH 01, 2018

Applies to:

Siebel CRM - Version 8.1.1.9 [23016] and later
Information in this document applies to any platform.

Symptoms

Environment:
-------------------
Product Type: Siebel CRM
Version: 8.1.1.9 [23016]
OS platform: Oracle Solaris on SPARC (64-bit)
DB: N/S
Env type: Dev

Statement of Issue:
-----------------------------
A web service is being called that calls a workflow that calls the Upsert method on the EAI Siebel Adapter and passes an instance of the IO FMA OPA Service Agreement to it. This includes the following ICs:

Parent: FMA OPA Service Agreement
Child: FMA OPA Agreement Item
Grandchild: FMA OPA History Agreement Item New

If the FMA OPA History Agreement Item New field FMA Set Name is set to a value then the Upsert completes correctly. If it’s null, then the Upsert fails with errors.

Error:
-------
10:25:13 (oracon.cpp (3842)) 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.

10:25:13 (oracon.cpp (870)) 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.

10:25:13 (oracon.cpp (2276)) SBL-DAT-00382: The same values for 'FMA Key Concat' already exist.
If you would like to enter a new record, please ensure that the field values are unique.

10:25:13 (adptutils.cpp (6867)) SBL-EAI-04381: For instance of Integration Component 'FMA OPA History Agreement Item New', using user key '[FMA Key Concat] = "68309152BNouvelle Sandero"', a record with identical values already exists in the Siebel database.

Please ensure that the field values in the input message are unique.

10:25:13 [0] For instance of Integration Component 'FMA OPA History Agreement Item New', using user key '[FMA Key Concat] = "68309152BNouvelle Sandero"', a record with identical values already exists in the Siebel database.

Please ensure that the field values in the input message are unique.(SBL-EAI-04381) (0x75017e)

Business Impact:
-------------------------
The web service call doesn’t complete as expected.

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.