Need to export all the Custom job roles in the instance
Our clients have a requirement to export all the Custom Job roles in the system into a report.
I have tried to use a SQL with PER_ROLES_DN_TL.
That gave only some seeded roles exiting in the system.
Tried another query with PER_GENERATED_DATA_ROLES, that gives only Data roles.
As per my requirement, I need both Custom Job and Data Roles to be exported into maybe an Excel file.
Request kind help from the experts on any query or Table details where I can fetch it from.
Version (include the version you are using, if applicable):