Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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
Get Started with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Report for users with current roles

edited May 21, 2019 2:21AM in Reporting and Analytics for HCM 6 comments

Summary

Not able to pull all users for above report

Content

Hello Folks - We have been using below report to satisfy one of our downstream system for periodic audits. Requirement is to have below columns as per report with list of all current active users along with their current roles. Works fine for majority of the users(FTEs).

However, we also create few user accounts manually via security console and grant them access to application.these are contractors who are not present in Fusion (they are not present in Person Management page). I noticed that below query doesn't fetch contractors. Upon further research, i noticed that they are not present in HZ_USERS table.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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