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

    Unable to delete assignment with TERMINATION action

    edited Nov 27, 2020 2:43PM in HCM Integrations 5 comments

    Summary

    Unable to delete assignment with TERMINATION action. Error message 'You can't delete the WorkTerms record with effective start date 2020-01-01 because a corresponding Termination record exists.'

    Content

    The current assignment is :

    Effective Start Date - Effective End Date - Action Code      - Effective Sequence - Effective Latest Change

    2020/01/01              - 2020/01/01             - TERMINATION - 1                              - N

    2020/01/01              - 4712/12/31             - TERMINATION - 2                              - Y

    And below is the command that I use to merge the record:

    SET PURGE_FUTURE_CHANGES Y
    METADATA|WorkTerms|AssignmentId(SourceSystemId)|PeriodOfServiceId(SourceSystemId)|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|ReasonCode|AssignmentStatusTypeCode
    MERGE|WorkTerms|WT1|PPOS1|RETIREMENT|2020/01/01|4712/12/31|1|Y|CT_NRML_RTR|INACTIVE_PROCESS

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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