Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
HDL ERROR when attempting to update a course in Oracle HCM Cloud
Summary:
An error occurs when updating a course using a CourseV3.dat file.
Are there any reason for this error?
Error:
You have 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}.
Content (please ensure you mask any confidential information):
The intention is to update the PublishEndDate.
Version (include the version you are using, if applicable):
25A
Code Snippet (add any code snippets that support your topic, if applicable):
METADATA|CourseV3|EffectiveStartDate|EffectiveEndDate|CourseNumber|PublishStartDate|PublishEndDate
MERGE|CourseV3|2025/03/17|4712/12/31|TR1991_41|2010/01/01|2024/01/31
0