My Oracle Support Banner

Fusion OTBI - Performance Document Comments Not Visible in Workforce Performance - Performance Rating Real Time (Doc ID 2347655.1)

Last updated on JULY 04, 2022

Applies to:

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

Goal

When creating below report in OTBI :

SELECT
0 s_0,
"Workforce Performance - Performance Rating Real Time"."Questionnaire Question"."Question Text" s_1,
"Workforce Performance - Performance Rating Real Time"."Questionnaire Question"."Response Text" s_2,
"Workforce Performance - Performance Rating Real Time"."Worker"."Person ID" s_3,
"Workforce Performance - Performance Rating Real Time"."Worker"."Person Number" s_4,
"Workforce Performance - Performance Rating Real Time"."- Performance Rating"."Average Section Rating" s_5
FROM "Workforce Performance - Performance Rating Real Time"

The comments entered in a performance document  should be visible.

 

Note: If you add Average Manager Overall Rating column to the above query, you will still be unable to view section comments ("Response Text"). This behavior is as per design. To get a comment which are technically a section comments we need to add "Average Section Rating". The Overall Rating will not help you to get required details.

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.