Problem Summary:

When we use a column from "Organization Hierarchy", the intended number of records are NOT returned

Problem Description:

We are developing a report in which we are using the subject area " "Workforce Management - Worker Assignment Real Time"
in one of our OTBI reports.

When we don't use the folder "Organization Hierarchy", then the data is coming well as intended
but we join with "Organization Hierarchy", the data is not returning as we intended.

In the leaf node of the 'Organization Hierarchy', for some employees, the Department
has not been set in the Organization Hierarchy.

For some employees, the Department has been set up in the 'Organization Hierarch'y hence the data is returning
correctly for this set of employes.

But We want both the employee list i.e. irrespective of Department has been set up or not, we want those employees to show
in the report.

The below query is when we don't use "Organization Hierarchy":
SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
0 s_0,
"Workforce Management - Worker Assignment Real Time"."Department"."Department Name" s_1,
"Workforce Management - Worker Assignment Real Time"."Worker"."Person Number" s_2
FROM "Workforce Management - Worker Assignment Real Time"
ORDER BY 3 ASC NULLS LAST, 2 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

The below query is when use "Organization Hierarchy":
SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
0 s_0,
"Workforce Management - Worker Assignment Real Time"."Department"."Department Name" s_1,
"Workforce Management - Worker Assignment Real Time"."Organization Hierarchy"."Level 01 Organization Name" s_2,
"Workforce Management - Worker Assignment Real Time"."Worker"."Person Number" s_3
FROM "Workforce Management - Worker Assignment Real Time"
ORDER BY 4 ASC NULLS LAST, 2 ASC NULLS LAST, 3 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY