RSA Product Set: RSA Identity Governance & Lifecycle
RSA Product/Service Type: Software Appliance
RSA Version/Condition: 6.8.1

Roles that are already deleted can be still seen in RSA G&L User Interface and stuck in "Applied Delete" state even though the Change Request for Deletion is Complete.

I haven't seen this issue yet in 6.9.1 or 7.0.
Since the version is 6.8.1 which is about to end the support life this year so no Engineering ticket was opened (as no more fixes planned for 6.8.1).

To work around this issue, follow the steps below:

1. Backup the database.

2. As the avuser, run this SQL command:

Delete from t_av_roleversions where role_id=(select if from t_av_roles where name ='<Deleted_Role_name>'); 

Update t_av_roles set deletion_date=sysdate, run_id='-99' where id=(select if from t_av_roles where name ='<Deleted_Role_name>'); 

commit;

3. In the RSA Identity G&L User Interface, the role should not be visible.