For more information, please refer to this announcement explaining best practices for getting answers to questions.
Assignment Supervisor load Error
Summary
Assignment Supervisor load ErrorContent
Hi All,
When we are trying to load Assignment supervisor data got below error,
Version: Oracle Cloud Application 19D (11.13.19.10.0)
Error:
The corresponding date effective record in the Assignment for date 2019-03-28, action MANAGER_CHANGE, and effective sequence 2 is missing for the Sibling Assignment.
The corresponding date effective record in the WorkTerms for date 2019-02-14, action ADD_ASSIGN, and effective sequence 1 is missing for the Assignments.
We are loading data with below Worker.dat
METADATA|WorkTerms|ActionCode|AssignmentNumber|AssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|PersonNumber|LegalEmployerName|DateStart|WorkerType|AssignmentStatusTypeCode|AssignmentType|BusinessUnitShortCode|ProjectedEndDate|PeriodOfServiceId|PersonTypeId|PeopleGroup|SourceSystemOwner|SourceSystemId