Outlook Synchronization Problem JBO-25071: Applying List binding <field_name> with given set of values leads to multiple matching rows for a row of type:Opportunity (Doc ID 2210169.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, Microsoft Outlook

When attempting to ,
the following error occurs.

ERROR
-----------------------
[16-10-18 12:33:11.617241,T6612] [info] [sync_manager]: synchronization finished. result: warning (result code: SW0002, result message: 'detected: 1 conflict(s), 0 duplicate(s), 31 issue(s), 0 confirmation(s)', total duration: 90.153 seconds)

Seeing these errors:

[16-10-18 12:32:48.616241,T6612] [ERROR] [sync_issue]: Recreation resolution error of activityAssignee object: object_locked (FusionSyncronizebleType error: Object type: activityAssignee
Fehlerdetails werden in den Anwendungslogdateien aufgeführt.
JBO-FND:::FND_GENERIC_MESSAGE: Die Meldung lautet oracle.jbo.service.errors.ServiceException : JBO-25030: Detail entity ActivityAssigneeEO with row key oracle.jbo.Key[null 300000143326446 ] cannot find or invalidate its owning entity..

[16-10-18 12:32:47.394241,T6612] [ERROR] [sync_issue]: Addition error of 'opportunity' object to storage 'Remote': object_locked (FusionSyncronizebleType error: Object type: opportunity
Fehlerdetails werden in den Anwendungslogdateien aufgeführt.
JBO-FND:::FND_GENERIC_MESSAGE: Die Meldung lautet oracle.jbo.service.errors.ServiceException : JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000150864803 ] in OpportunityEOJBO-25183: Exception in expression "OpportunityEO" trigger "PopulateOpportunityType" : oracle.jbo.ListBindingMismatchException JBO-25071: Applying List binding LOV_For_OpportunityType_c with given set of values leads to multiple matching rows for a row of type:Opportunity, key oracle.jbo.Key[300000150864803 ].

[16-10-18 12:32:47.394241,T6612] [ERROR] [sync_issue]: Addition error of 'opportunity' object to storage 'Remote': object_locked (FusionSyncronizebleType error: Object type: opportunity
Fehlerdetails werden in den Anwendungslogdateien aufgeführt.
JBO-FND:::FND_GENERIC_MESSAGE: Die Meldung lautet oracle.jbo.service.errors.ServiceException : JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000150864803 ] in OpportunityEOJBO-25183: Exception in expression "OpportunityEO" trigger "PopulateOpportunityType" : oracle.jbo.ListBindingMismatchException JBO-25071: Applying List binding LOV_For_OpportunityType_c with given set of values leads to multiple matching rows for a row of type:Opportunity, key oracle.jbo.Key[300000150864803 ].

[16-10-18 12:32:47.394241,T6612] [ERROR] [sync_issue]: Addition error of 'opportunity' object to storage 'Remote': object_locked (FusionSyncronizebleType error: Object type: opportunity
Fehlerdetails werden in den Anwendungslogdateien aufgeführt.
JBO-FND:::FND_GENERIC_MESSAGE: Die Meldung lautet oracle.jbo.service.errors.ServiceException : JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000150864802 ] in OpportunityEOJBO-25183: Exception in expression "OpportunityEO" trigger "PopulateOpportunityType" : oracle.jbo.ListBindingMismatchException JBO-25071: Applying List binding LOV_For_OpportunityType_c with given set of values leads to multiple matching rows for a row of type:Opportunity, key oracle.jbo.Key[300000150864802 ].

.....etc


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Start sync
2. Sync ends with errors


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot upsync the opportunity or activity records to OSC.

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