ElementEntryWithCosting.dat HDL Load Error
Summary:
While loading the ElementEntryWithCosting.dat file getting below error :
The input value with a primary key ({INPUT_VALUE_ID}) was supplied when creating or updating the entry value but it doesn't exist in the PAY_INPUT_VALUES_F table.
Below is the sample file used to load
METADATA|ElementEntryWithCosting|AssignmentNumber|EffectiveStartDate|ElementName|EntryType|CreateEntrySequence|InputValueName1|ScreenEntryValue1|InputValueName2|ScreenEntryValue2|InputValueName3|ScreenEntryValue3|InputValueName4|ScreenEntryValue4|InputValueName5|ScreenEntryValue5|InputValueName6|ScreenEntryValue6|InputValueName7|ScreenEntryValue7|InputValueName8|ScreenEntryValue8|Segment1|Segment2|Segment3|Reason
MERGE|ElementEntryWithCosting|E11111111|2025/10/05|OVERTIME PAY|E|1|Hours|4.5|||Location Name||||||Earned Date|2025/10/05|||||1001|10001|10001|Final_File
Please assist