Not able to End date the Person Contact Relationship using HDL

Not able to End date the Person Contact Relationship using HDL

Description : 

Using HDL trying to end date the Person Contact Relationship.

Resolution :

You can not end date contact relationship using HDL as this feature is not supported by Oracle.

In this case you can delete the Person Contact Relationship.

You can't delete the contact because the person is designated as a benefit dependent or beneficiary

 

You can't delete the contact because the person is designated as a benefit dependent or beneficiary

Error Message : 

You cannot delete the contact because the person is designated as a benefit dependent or beneficiary, or an attempt was made to process the benefit designation

Or

Error removing a duplicate beneficiary/contact

Solution : 

1. Check if Dependent is add as beneficiary or not. if yes then remove it.

2. Check if dependent is elected as beneficiary in any of the plan, remove if yes.

3. If Dependent is covered in any plan then void/purge the life event and Run Purge Backed-Out or Voided Life Event Data for the employee. 

After this you can delete or end date Person Contact Relationship either using HDL or UI.

 

HDL Template for Benefit Participant Enrollment

HDL Template for Benefit Participant Enrollment

For this use ParticipantEnrollment.dat file.

Please find the below sample template :

METADATA|ParticipantEnrollment|PersonNumber|ParticipantLastName|ParticipantFirstName|BenefitRelationship|LifeEvent|LifeEventOccuredDate|EffectiveDate

MERGE|ParticipantEnrollment|XXTEST_PER1|Adam|Baro|Default|NewHire|2016/11/05|2016/11/05

METADATA|CompensationObject|Program|OriginalEnrollmentDate|PersonNumber|LineNumber

MERGE|CompensationObject|XXTEST Benefits Program|2016/11/05|XXTEST_PER1|1