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

Use session variable to show only Health and Safety incidents for the user logged in

edited Apr 13, 2020 10:30PM in Reporting and Analytics for HCM 4 comments

Summary

Recording demonstrates steps to get display name of user logged in and pass as a sub report to query incidents for user logged in.

Content

Overview of steps:

  • Create report with two attributes (person ID and Display Name) from worker folder of Health and Safety subject area
  • Change person ID to number format, no decimals or commas
  • Create filter where display name = session variable PERSON_ID_HCM
  • Save report
  • Create another report with incident attributes desired
  • Create filter where incident owner matches display name in sub report (point to your first report above)
  • Save and run report to view only incidents for user logged in

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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