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
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    HDL Query

    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!