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:

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

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