Is there a way to check, if a record was restored recently from deleted records?

[prasanna11]

I want to check if one of the "sys_security_acl_role" record has been restored from the deleted records table recently. 

Because one such record is seen to be created and later deleted in an update set. But recently it appears that it has comeback.! and causes issues.

[Ankur Bawiskar]

@prasanna11 

Things to check and my thoughts

1) Navigate to System Definition > Deleted Records to see records that have been deleted recently (typically within the last 7 days)

2) If the Delete operation is also captured in update set then you can remove it from update set before migration if you don't want.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[prasanna11]

Agree to both the points, but as you see the update was from 2019, update sets already moved to PROD. And i do not see the records in deleted records (implies it might have been restored from deleted records) 

I want to understand if there is way to check if a record was created in 2019 / if it was restored from a deleted record entry recently.

[Ankur Bawiskar]

@prasanna11 

I don't think you can verify that.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Anand2799]

Hi @prasanna11 ,

You can use Deleted Recovery module and sys_rollback_sequence table to search for the rollback records.

Thanks

Anand