Prevent records being deleted from sysapproval_approver table

Preethi Malligo
Giga Expert

For a customized form, there are a series of approvers. When each one of the approvers are approving the record, their entries in sysapproval_approver table are getting deleted and stored in the sys_audit_delete table by the system automatically. Is there any way to prevent the deletion as I want the records in future.

 

Thanks in advance,

Preethi M.

1 ACCEPTED SOLUTION

vinothkumar
Tera Guru

Create a delete operation on Approval table and set answer = false; which will prevent the deletion of record in your instance.

You can also create before delete business rule on approval table and use current.setAbortAction(true);

View solution in original post

5 REPLIES 5

vinothkumar
Tera Guru

Create a delete operation on Approval table and set answer = false; which will prevent the deletion of record in your instance.

You can also create before delete business rule on approval table and use current.setAbortAction(true);

Hi

What do you mean with "delete operation"?

BR

Dirk

The Before delete business rule prevented record deletion. Thanks a lot!

DirkRedeker
Mega Sage

Hi

Can you show a screenshot to explain your case? I do not know the OOB function to delete approval records.

When I approve - e.g. a request - the approval record is  not deleted or achived.

Is that some custom behavior on your instance?

Thanks & BR

Dirk