Import HCM Cloud Data File (Worker) Encountered ORA-00001: Unique Constraint (HR.PER_RI_B_PERSONS_PK)
(Doc ID 2660016.1)
Last updated on APRIL 09, 2021
Applies to:Oracle Human Resources - Version 12.2.7 and later
Information in this document applies to any platform.
When attempting to run "Import HCM Cloud Data File for Payroll Integration" to import HCM Cloud data, the following error occurs.
ERROR: Exception occured during Import the Fusion Extract
ERROR: Failed while inserting rows for entity :Person
Caused by :ORA-00001: unique constraint (HR.PER_RI_B_PERSONS_PK) violated
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Select Cloud Integration from HCM Cloud Administrator Responsibility
- Click Import and Load Data and then submit
- Click View log and then the error can be seen.
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