My Oracle Support Banner

The Synchronize Person Records Process Is Unsuccessful Due To Error: JBO-27023, FND_CMN_RCRD_VAL (Doc ID 2907490.1)

Last updated on MARCH 27, 2024

Applies to:

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

Goal

On : 11.13.22.07.0 version, Accounts, Contacts, Households

While processing an expense report it was failing due to error:
Current assignment of the user is missing department (organization_id) and job (job_id).
NOTE: there could be other symptoms of this issue where the process is attempting to access a party record for an HCM Person.

Attempts were made to synchronize this person but the synchronization was not successful.

On further review by support of the synchronization SOA instance, it was observed that it was failing with error:
JBO-27023: Failed to validate all rows in a transaction.
FND_CMN_RCRD_VAL: A record with the value FUSION_HCM,{PersonId} already exists. Enter a unique value.

The affected person was terminated in 2015.
The OSR data was created as active with a CreatedByModule of HZ_FUSION_V1_UPGRADE in 2016 with an EndDateActive of the termination date.

This can be detected by using the following query:

NOTE: replace {PersonNumber} in the query with the HCM Person Number for the affected person.

select ORIG_SYSTEM_REF_ID, ORIG_SYSTEM, OWNER_TABLE_ID, STATUS, START_DATE_ACTIVE, END_DATE_ACTIVE, CREATED_BY_MODULE, CREATION_DATE
from HZ_ORIG_SYS_REFERENCES where OWNER_TABLE_NAME = 'HZ_PARTIES' and ORIG_SYSTEM='FUSION_HCM' and ORIG_SYSTEM_REFERENCE in (
select to_char(PERSON_ID) from PER_ALL_PEOPLE_F where PERSON_NUMBER = '{PersonNumber}')

ORIG_SYSTEM_REF_ID,ORIG_SYSTEM,OWNER_TABLE_ID,STATUS,START_DATE_ACTIVE,END_DATE_ACTIVE,CREATED_BY_MODULE,CREATION_DATE
999999999999999,FUSION_HCM,999999999999999,A,2014-01-01 00:00:00.0,2015-01-01 00:00:00.0,HZ_FUSION_V1_UPGRADE,2016-01-01 00:00:00.0

Solution

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
Goal
Solution


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