My Oracle Support Banner

Fusion Apps, OTBI - "Workforce Performance - Performance Rating Real Time" Subject Area, How to Display Ratings Of the Manager and of the Worker on the Same Row (Doc ID 1941715.1)

Last updated on MAY 25, 2018

Applies to:

Oracle Fusion Performance Management Cloud Service - Version 11.1.8.0.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.8.0.0 and later
Oracle Fusion Application Toolkit - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Goal

Cloud, HCM, R8, OTBI - "Workforce Performance - Performance Rating Real Time" subject area


How to report the manager's rating and the worker's rating on the same row in OTBI.
The logical SQL:

 
SELECT
  0 s_0,
  "Workforce Performance - Performance Rating Real Time"."- Performance Rating"."Overall Manager Rating" s_1,
  "Workforce Performance - Performance Rating Real Time"."- Performance Rating"."Overall Worker Rating" s_2,
  "Workforce Performance - Performance Rating Real Time"."Document and Rating Details"."Performance Document Status" s_3,
  "Workforce Performance - Performance Rating Real Time"."Performance Document"."Performance Document Period Name" s_4,
  "Workforce Performance - Performance Rating Real Time"."Worker"."Employee Name" s_5,
  "Workforce Performance - Performance Rating Real Time"."Worker"."Manager Name" s_6,
  DESCRIPTOR_IDOF("Workforce Performance - Performance Rating Real Time"."Document and Rating Details"."Performance Document Status") s_7
FROM "Workforce Performance - Performance Rating Real Time"
ORDER BY 1, 6 ASC NULLS LAST, 7 ASC NULLS LAST, 5 ASC NULLS LAST, 4 ASC NULLS LAST, 3 ASC NULLS LAST, 2 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY



 

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
References


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