HCM Data Loader (HDL): Loading Element Entries "Logical Start Date Is Required" (Doc ID 2235026.1)

Last updated on MARCH 20, 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 trying to load Not recurring element, only the first occurrence for a specific element can be loaded.

The others goes in error with the error in the object.

ERROR
-----------------------
ERROR : An application error occurred: ORA-00001: unique constraint (FUSION.HRC_INTEGRATION_KEY_MAP_UK2) violated . ERROR : JBO-25050: Batch mode post operation failed. See Exception details for a list of failures. ERROR : JBO-26040: Failed to post entity oracle.jbo.Key[ElementEntryValue 300000030664654 ] to database during "Insert" : SQL Statement "ORA-00001: unique constraint (FUSION.HRC_INTEGRATION_KEY_MAP_UK2) violated ".
ERROR : A logical end date is required.
ERROR : A logical start date is required.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load the attached "ElementEntry.dat" file
2. See the errors in the Diagnostic Report

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