Get Started with Redwood for Oracle Cloud HCM Begin Now

To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

HDL Data Loader while creating Pending Worker in Fusion HCM R13

Jun 14, 2018 10:13AM edited Jun 14, 2018 10:13AM in HCM Integrations 4 comments

Summary

Pending Worker creation issue

Content

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

Tagged:

1

Howdy, Stranger!

To view full details, sign in.

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