Oracle Fusion OTBI: Matrix Manager Dimension shows the wrong number of managers (Doc ID 2098474.1)

Last updated on JANUARY 31, 2024

Applies to:

Symptoms

On : 11.1.10.0.0 version, Global Human Resources

ACTUAL BEHAVIOR
---------------
When reporting on Matrix Manager Dimension, the results are not correct. Using Workforce Management- Worker Assignment Real Time subject area, the managers that result are not the managers that are on the employee record. The line manager is correct; however, the other manager types are not correct


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to /analytics and select New from the Menu:

2. Create an analysis based on the following Logical SQL:

SELECT

"Workforce Management - Worker Assignment Real Time"."Matrix Manager"."Effective End Date" s_1,
"Workforce Management - Worker Assignment Real Time"."Matrix Manager"."Effective Start Date" s_2,
"Workforce Management - Worker Assignment Real Time"."Matrix Manager"."Level 01 Manager Name" s_3,
"Workforce Management - Worker Assignment Real Time"."Matrix Manager"."Level 01 Manager Person Number" s_4,
"Workforce Management - Worker Assignment Real Time"."Matrix Manager"."Level 01 Manager Type" s_5,
"Workforce Management - Worker Assignment Real Time"."Worker"."Manager Name" s_6,
"Workforce Management - Worker Assignment Real Time"."Worker"."Manager Type" s_7,
"Workforce Management - Worker Assignment Real Time"."Worker"."Person Number" s_8,
DESCRIPTOR_IDOF("Workforce Management - Worker Assignment Real Time"."Matrix Manager"."Level 01 Manager Type") s_9
FROM "Workforce Management - Worker Assignment Real Time"

Cause

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