Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
HDL Data Loader while creating Pending Worker in Fusion HCM R13
Summary
Pending Worker creation issueContent
Hi,
I am trying to load pending worker data using HDL but facing following issue
"The Primary Work Relationship attribute of the assignment with effective start date 2018-01-01 and effective sequence 1 does not match the work relationship"
Worker.dat file content:
METADATA|WorkRelationship|PersonId(SourceSystemId)|LegalEmployerName|ActionCode|DateStart|WorkerType|PrimaryFlag|SourceSystemOwner|SourceSystemId
MERGE|WorkRelationship|654322W|Saudi Arabia Legal Entity|ADD_PEN_WKR|2018/01/01|P|N|SOURCETEST1|654322_EMP_WR
METADATA|WorkTerms|PersonId(SourceSystemId)|PeriodOfServiceId(SourceSystemId)|ActionCode|ProjectedStartDate|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentType|PrimaryWorkTermsFlag|PersonTypeCode|SystemPersonType|ProposedUserPersonType|LegalEmployerName|SourceSystemOwner|SourceSystemId
MERGE|WorkTerms|654322W|654322_EMP_WR|ADD_PEN_WKR|2018/06/18|2018/01/01|4712/12/31|1|Y|PT|Y|Pending Worker|PWK|Employee|Saudi Arabia Legal Entity|SOURCETEST1|654322_EMP_TERM