My Oracle Support Banner

HR2HR: Error When Loading The Element Entries From Fusion HCM To EBS: ORA-00001 - Unique Constraint (HR.PER_RI_B_GEN_ENTRY_VALUES_PK) Violated (Doc ID 2749026.1)

Last updated on FEBRUARY 02, 2021

Applies to:

Oracle Human Resources - Version 12.2.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2 version, Fusion Integration

When attempting to import the Element Entries export from Fusion HCM to EBS ,
the following error occurs.

ERROR
ERROR: Process :PER_RI_B_IMPORT_HR_DATA failed.
ERROR: Exception occured during Import the Fusion Extract
ERROR: Failed while inserting rows for entity :GenElemEntry
Caused by :ORA-00001: unique constraint (HR.PER_RI_B_GEN_ENTRY_VALUES_PK) violated


STEPS
The issue can be reproduced at will with the following steps:
1. Extract data from Fusion Cloud HCM by selecting the standard Business object as 'Element Entry'
2. Run the program Import HCM Could Data for Integration in EBS
3. Observe the error in the logs


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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