Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Error Message occurs while changing the hire date using HDL
Hi,
We're trying to change the hire date of a person record via HDL(Worker.dat)
HDL Code used:
SET PURGE_FUTURE_CHANGES N
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|NewStartDate
MERGE|WorkRelationship|FUSION|XXXX|YYYY|ABC|YYYY/MM/DD
Wherein
SourceSystemId = (Select *from per_periods_of_service WHERE Person_ID = '123456789') - which results in POSID
PersonId = (Select *from PER_ALL_PEOPLE_F Where Person_Number ='000') - which results in PERSONID
NewStartDate - any date
While we run the HDL code, we're getting the below error:
The Effective Start Date attribute must be on or before the Effective End Date attribute.
0