My Oracle Support Banner

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

Last updated on FEBRUARY 06, 2019

Applies to:

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


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 : 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.

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


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

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