Active\Inactive Employees with assigned Line Managers — Cloud Customer Connect
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

Active\Inactive Employees with assigned Line Managers

edited Oct 17, 2018 12:50PM in Reporting and Analytics for HCM 12 comments

Summary

A requirement for a BIP report to show all employees and their Line Managers

Content

Hi All,

I have a requirement to create a BIP report to display all Active and Inactive employees and their Line managers.

When I run the below report it only shows active assignments but the leavers are missing.

If I comment out\remove the PER_ASSIGNMENT_SUPERVISORS_F as well as any other reference relating to the manager the report runs correctly showing both active and Inactive employees.

Is there a way to fix this or use the table PER_MANAGER_HRCHY_DN as an alternative? if so how do I show employees and their line managers?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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