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 SEPTEMBER 28, 2023

Applies to:

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

Goal

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.
 

Solution

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
Goal
Solution


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