HCM Data Loader (HDL) Error: ORA-00001: unique constraint violated (Doc ID 2253686.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to load Person EIT Worker with HDL, the following error occurs:

Error

 ERROR : An application error occurred: ORA-00001: unique constraint (FUSION.PER_PEOPLE_EXTRA_INFO_F_PK) violated . ERROR : JBO-26048: Constraint "PER_PEOPLE_EXTRA_INFO_F_PK" is violated during post operation "Insert" using SQL statement "INSERT INTO PER_PEOPLE_EXTRA_INFO_F(PERSON_EXTRA_INFO_ID,EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,INFORMATION_TYPE,PEI_INFORMATION_CATEGORY,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,LAST_UPDATED_BY,CATEGORY_CODE,PEI_INFORMATION_DATE1,PEI_INFORMATION_DATE2,PEI_INFORMATION_NUMBER1,PEI_INFORMATION_NUMBER2,PEI_INFORMATION_NUMBER3) VALUES

Steps
The issue can be reproduced at will with the following steps.
1. Navigate to Data Exchange
2. HCM Data Loader / Import and Load Data
3. Import File / Import Local File / Browse- select zip -click submit button


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms