HCM Data Loader (HDL): Loading Element Entries "Logical Start Date Is Required"
Last updated on MARCH 20, 2017
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 18.104.22.168.0 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
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