My Oracle Support Banner

Outlook Sync Issue - JBO-27023 for lookup type PARTY_SITE_USE_CODE (Doc ID 2352119.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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


On ccvh.crm: version, Microsoft Outlook


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.
@@@@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)

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

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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.