Revoke Roles in Security Console R12 Still Showing Assigned in BI Report

Summary

Since R12 upgrade revoking roles in Security Console, the revoked users' roles still appear to be assigned in our existing custom BI report (SQL below)

Content

In R12 we have been revoking users' roles in security console which seems fine but I suspect we need to change the source for our pre-existing custom user roles report.  In the table "fusion.per_user_roles" these roles are still assigned.  SQL below.  Can anyone guide me as to the solution to this?  Thanks, Wendy

SELECT

pu.person_id,

ppn.display_name,

pu.username,

pu.suspended,

prdv.role_name,

prdv.description,

prdv