My Oracle Support Banner

Oracle Fusion Global HR : Count Discrepancy Between The Organisation Chart In UI And The "PER_MANAGER_HRCHY_DN" . (Doc ID 2408355.1)

Last updated on DECEMBER 14, 2019

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version and later
Information in this document applies to any platform.


Due to limitation to export only 500 rows in a organisation chart ,customer has a requirement to develop a report similar to that chart.

Hence they are using the table "PER_MANAGER_HRCHY_DN" . But they found count discrepancy in the reportees count between the 2.
Eg : For Manager :xxxx , UI shows 11 reportees , but the table shows 12 reportees.
And the person employement page also shows the count of direct reports as 11 .
But why is this count discrepancy? Which is the table to be looked into for the development of the organisation chart.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.