Extracting Role Hierarchy data from Oracle Cloud via SQL or Seeded Report

Content

Hi,

We are using 19D (11.13.19.10.0).

I have a requirement to create copies of some existing Roles. Some of the Roles are seeded Oracle Roles, others are custom roles.

I am familiar with being able to run SQL to find roles assigned to users:

select prdt.role_name
, prd.role_common_name
, fu.username
, to_char(pur.creation_date, 'YYYY-MM-DD HH24:MI:SS') date_assigned_to_user
, pur.created_by
from per_users fu
join per_user_roles pur on fu.user_id = pur.user_id
join per_roles_dn_tl prdt on pur.role_id = prdt.role_id
join per_roles_dn prd on prd.role_id = prdt.role_id and prdt.language = 'US'
where 1 = 1
and prdt.role_name in ('Collections Manager')
order by to_char(pur.creation_date, 'YYYY-MM-DD HH24:MI:SS') desc