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
    • Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

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

    error in HDL while loading Assignment Name

    in Human Capital Management 10 comments

    Hello. We are loading the Assignment name for the employees but this error is keep on coming:

    'The corresponding date effective record in the WorkTerms for date 2022-01-17, action ASG_CHANGE, and effective sequence 1 is missing for the Assignment.'


    We are using this HDL for loading:

    METADATA|WorkTerms|ActionCode|AssignmentNumber|AssignmentStatusTypeCode|AssignmentType|BusinessUnitShortCode|EffectiveLatestChange|EffectiveSequence|EffectiveStartDate|PersonNumber|LegalEmployerName|DateStart|WorkerType|PrimaryWorkTermsFlag

    MERGE|WorkTerms|ASG_CHANGE|ET128396|ACTIVE_PROCESS|ET|Colombia|Y|1|2023/01/17|128396|Colombia|2022/01/17|E|Y

    METADATA|Assignment|ActionCode|EffectiveStartDate|PersonNumber|EffectiveSequence|EffectiveLatestChange|AssignmentType|AssignmentNumber|AssignmentStatusTypeCode|BusinessUnitShortCode|PrimaryAssignmentFlag|WorkTermsNumber|LegalEmployerName|AssignmentName

    MERGE|Assignment|ASG_CHANGE|2023/01/17|128396|1|Y|E|ET128396|ACTIVE_PROCESS|Colombia|Y|ET128396|Colombia|Administration Officer Colombia

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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