You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need to export all the Custom job roles in the instance

Received Response
edited Oct 2, 2022 6:02PM in Applications Security 4 comments


Hi Experts,

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.



Content (required):

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!