User and Role Access Audit Report - be aware
This is not a query but a heads up for users.
This delivered report does not return the values it's supposed to. Running the report with 'All roles' does NOT return all security roles. After a contentious back and forth for 6 months with Oracle Support, they insist it's not a bug and is working as designed. They will not log a bug report and fix it.
All users of this report need to be aware that you are not getting the information you expect and will need to create your own version.
Version (include the version you are using, if applicable):