Oracle Fusion OTBI: Matrix Manager Dimension shows the wrong number of managers
(Doc ID 2098474.1)
Last updated on JANUARY 31, 2024
Applies to:
Oracle Fusion Global Human Resources Cloud Service - Version 11.1.10.0.0 and laterInformation in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |