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

HDL Query

Received Response
95
Views
14
Comments
edited Feb 8, 2019 7:51PM in HCM Integrations 14 comments

Summary

HDL

Content

I have few records in Person Extra Information Table

PersonId,PerextraId,Value,effstartdate,effenddate
101,201,1,2017/01/01,2017/12/31
101,202,2,2018/01/01,4712/12/31

When I try to Replace the Values it is giving me an error: A Logical End date is required.

HDL
SET PURGE_FUTURE_CHANGES Y
METADATA|.....
MERGE|WorkerExtraInfo|PER_EIT|2017/07/11|2018/04/08|174

Is there any Way to Replace the First Record and remove all other effective date records.

I also tried to delete the Records but giving me an error The WorkerExtraInformationContextVO object is invalid. I believe this doesn't support DELETE.

Thanks.

 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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