Error Message - The ContactRelationship SDO, ContactType attribute value is required.
Summary:
I get this error message when I try to load Contact data using HDL - The ContactRelationship SDO, ContactType attribute value is required. You must enter a value.
Content (required):
Here is the HDL file
METADATA|Contact|PersonId|EffectiveStartDate|EffectiveEndDate|StartDate|SourceSystemOwner|SourceSystemId
MERGE|Contact||2023/07/01||2023/07/01|HHOG_HCM|CT01
METADATA|ContactAddress|PersonAddrUsageId|EffectiveStartDate|AddressType|PersonId|PersonNumber|AddressId|AddressLine1|AddressLine2|Country|SourceSystemOwner|SourceSystemId
MERGE|ContactAddress||2023/07/01|HOME||HH/HxOG/20008||2nd Avenue 207 Road Block 6 Flat 7 Festac Town Lagos||NG|HHOG_HCM|CAD01
METADATA|ContactRelationship|ContactRelationshipId|EffectiveStartDate|EffectiveEndDate|PersonId|RelatedPersonNumber|PersonNumber|RelatedPersonId|ContactType|EmergencyContactFlag|ExistingPerson|PersonalFlag|PrimaryContactFlag|SequenceNumber|SourceSystemOwner|SourceSystemId
MERGE|ContactRelationship||2023/07/01|||HH/HxOG/20008|HH/HxOG/20008||IN_FR|Y|Y|Y|N||HHOG_HCM|CTR01