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

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

Ask for a sample to load New Hire and Termination in one HDL template

edited Aug 27, 2024 1:53PM in HCM Data Loader (HDL) 1 comment

Summary:

When try to load the New Hire and Terminatation in the same HDL template, it has the error: Work terms or assignment can't be specified when terminating a work relationship.

Content (please ensure you mask any confidential information):

Here is the HDL:

METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|DateStart|WorkerType|PrimaryFlag|ActionCode|ActualTerminationDate|TerminateWorkRelationshipFlag
MERGE|WorkRelationship|DHA|10003_POS|10003| AAA Co., Ltd.|1997/07/23|E|Y|HIRE|2019/03/26|Y

METADATA|WorkTerms|SourceSystemOwner|SourceSystemId|PeriodOfServiceId(SourceSystemId)|ActionCode|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentNumber|AssignmentStatusTypeCode|PrimaryWorkTermsFlag|BusinessUnitShortCode
MERGE|WorkTerms|DHA|10003_TRM|10003_POS|HIRE|1997/07/23|2019/03/26|1|Y||ACTIVE_PROCESS|Y|Lab
MERGE|WorkTerms|DHA|10003_TRM|10003_POS|TERMINATION|2019/03/27|4712/12/31|1|Y||INACTIVE_NO_PROCESS||Lab

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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