Are there any seeded reports or even a OBIE sql statement to identify if a HR Data role has been re-

Summary

At times the regeneration of HR Data roles can be problematic, Particuarly if security policies have been manually overridden after originally generated.

Content

Is there any Oracle reports we can run, or even a quick SQL analysis that can be run to identify:

a) HCM data role
b) Re-generation date/time stamp
c) By which user
d) By which method? Manually via task 'Manage Data Roles and Security Profiles page.' or via Process Regenerate Data Security Grants

Thanks

Paul

Version

20C