Outlook Sync Issue - JBO-27023 for lookup type PARTY_SITE_USE_CODE

(Doc ID 2352119.1)

Last updated on JANUARY 23, 2018

Applies to:

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

Symptoms

On ccvh.crm: 11.12.1.0.0 version, Microsoft Outlook

ERROR
-----------------------

About 50 sync issues in the screenshot attached and in the logs. The issue seems to appear for contact records

[18-01-18 15:25:49.078452,T5800] [ERROR] [sync_issue]: Updating error of 'person' object on storage 'Remote': object_locked (FusionSyncronizebleType error: Object type: person
Error details are available in the application log files.
JBO-27023: Failed to validate all rows in a transaction.JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000006072747 ] in PartySiteUseEOJBO-HZ:::HZ_API_INVALID_LOOKUP: HZ-120113The value for column Purpose must be a value defined in the lookup type PARTY_SITE_USE_CODE.
@@@@rref:soap_2018-01-18T09-54-01-879.xml.gz.bin
@@@@server error:ZOE_SERVICE_INVOKE_ERROR
@@@@xml:) srcId:#C3D1010000000000 destId:person#100000000387098
.........
[18-01-18 15:25:49.328509,T5800] [info] [sync_manager]: synchronization finished. result: warning (result code: SW0002, result message: 'detected: 0 conflict(s), 0 duplicate(s), 52 issue(s), 0 confirmation(s)', total duration: 101.406 seconds)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open Outlook
2. Start a sync process
3. Sync ends with error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot synchronize some of their records.

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