Loading Assignment Changes via HDL
Summary:
We are trying to load new assignment change via HDL using following dat file and getting this error:
You must provide a valid reference to the parent record. Ensure that the parent record is supplied in the same file, or has already been created.
We are following Oracle documentation for dat file format and have loaded changes in the past successfully
Content (please ensure you mask any confidential information):
METADATA|WorkTerms|AssignmentNumber|PersonNumber|LegalEmployerName|DateStart|WorkerType|ActionCode|ReasonCode|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|AssignmentStatusTypeCode|BusinessUnitShortCode
MERGE|WorkTerms|ET101683|101683|****|2021/03/29|E|PROMOTION||2025/07/01|4712/12/31|Y|1|ACTIVE_PROCESS|Finance
METADATA|Assignment|AssignmentNumber|PersonNumber|LegalEmployerName|DateStart|WorkerType|ActionCode|ReasonCode|WorkTermsNumber|EffectiveStartDate|EffectiveEndDate|EffectiveLatestChange|EffectiveSequence|GradeCode|JobCode|AssignmentStatusTypeCode|BusinessUnitShortCode