Workforce Performance - Performance Rating Distribution Real Time does not return any Data with all Required Roles

(Doc ID 2374348.1)

Last updated on MAY 10, 2018

Applies to:

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

Goal

Following Analysis does not return any data :

SELECT 0 s_0, "Workforce Performance - Performance Rating Distribution Real Time"."Review Period"."Review Period Name" s_1,
  "Workforce Performance - Performance Rating Distribution Real Time"."Worker"."Employee Name" s_2
FROM "Workforce Performance - Performance Rating Distribution Real Time"
ORDER BY 1, 2 ASC NULLS LAST, 3 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

It is not a security roles issue since we don't see 1=2 in the physical SQL
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms