You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Error Message occurs while changing the hire date using HDL

Accepted answer
1
Views
2
Comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!