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 laterInformation 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. |