Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Error while updating Element Entry value using HDL
Summary:
Hello,
This is the HDL we are using:
METADATA|ElementEntry|AssignmentNumber|EffectiveStartDate|EffectiveEndDate|ElementName|EntryType|LegislativeDataGroupName|MultipleEntryCount|ReplaceLastEffectiveEndDate
METADATA|ElementEntryValue|AssignmentNumber|EffectiveStartDate|ElementName|EntryType|LegislativeDataGroupName|MultipleEntryCount|InputValueName|ScreenEntryValue|ReplaceLastEffectiveEndDate
MERGE|ElementEntry|E109763|2024/07/07|4712/12/31|Employer HSA|E|US Legislative Data Group|5|N
MERGE|ElementEntryValue|E109763|2024/07/07|Employer HSA|E|US Legislative Data Group|5|Amount|400|N
We are getting the following error:
You've provided a date-effective row that starts on {FIRST_ROW_START_DATE} for an existing record that doesn't start until {DB_LOGICAL_START_DATE}.
Another record with the same identifier exists, starting on {DB_LOGICAL_START_DATE}. If you're attempting to create a new record, provide a unique reference using the source key or user key attributes. To change the existing record to have an earlier start date, supply the ReplaceFirstEffectiveStartDate attribute with a value of Y. Use the View Business Objects task to confirm that this object supports a change to the earliest start date.