Deleting a Change Request

[mah1]

Xanadu Patch 7

What related records are deleted when a change request is deleted?  What controls this?

It seems that when a change request is deleted on our instance, change tasks are not deleted but are orphaned. This doesn't seem to be the case OOB; i.e., I confirmed that change tasks are not orphaned when a change request is deleted on my PDI. It appears to have been happening for quite a while since I see orphan change tasks as far back as 2017.  I compared the Delete UI Action on our instance to my PDI and they appear to be the same.

On the delete confirmation popup, change tasks are not listed under automatic deletion of related records. My guess is that it is something that was customized here but I am not sure where to look.  Any suggestions would be appreciated.

Thank you

[AmM01]

I assume the customization might exist in the Delete UI action, a business rule or possibly a flow. 

[mah1]

The Delete UI action appears to be OOB. I did not see any business rules for change request involving delete but I will look again. I'm not aware of any flows set up for this but I will look again.

Thank you

[Dr Atul G- LNG]

Hi @mah1 

Try to repair the change plugin and then test.

[Bert_c1 · Accepted solution]

Check the 'Reference cascade rule' defined on the 'change_request' field on the 'change_task' record. It is set to "Delete" in my PDI. Meaning any change_task record that references a change_request that is deleted will also be deleted. It may be different on your affected instance.