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

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