Fusion Applications - OTBI - "Workforce Performance - Performance Rating Real Time" - Report Do Not Retrieve Data For Performance Document And Questionaire Section (Doc ID 2150583.1)

Last updated on JULY 09, 2016

Applies to:

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

Symptoms

On : 11.1.10.0.0 version, Technology Management - Reports/Analytics

ACTUAL BEHAVIOR
---------------
Requirement is to report on the Questionaire section and responses associated with Performance document.

Added the columns only from "Workforce Performance - Performance Rating Real Time"."Questionnaire Question" and we are able to pull basic data from this folder.

If we add field from "Performance Document Status" Folder, the analysis does not return data.


Below is the logical SQL of analysis that does not pull data:
----------------------------------------------
set variable LOGLEVEL = 2,DISABLE_CACHE_HIT=1,DISABLE_PLAN_CACHE_HIT=1;
SELECT
0 s_0,
"Workforce Performance - Performance Rating Real Time"."Performance Document"."Performance Document Period Name" s_1,
"Workforce Performance - Performance Rating Real Time"."Performance Document"."Performance Document Period Short Name" s_2,
"Workforce Performance - Performance Rating Real Time"."Questionnaire Question"."Question Text" s_3,
"Workforce Performance - Performance Rating Real Time"."Questionnaire Question"."Question Type" s_4,
"Workforce Performance - Performance Rating Real Time"."Questionnaire Question"."Response List Long Text" s_5,
"Workforce Performance - Performance Rating Real Time"."Questionnaire Question"."Response List Text" s_6,
"Workforce Performance - Performance Rating Real Time"."Questionnaire Question"."Response Status" s_7,
"Workforce Performance - Performance Rating Real Time"."Questionnaire Question"."Response Text" s_8,
"Workforce Performance - Performance Rating Real Time"."Questionnaire Question"."Response Type" s_9,
"Workforce Performance - Performance Rating Real Time"."Worker"."Employee Name" s_10,
DESCRIPTOR_IDOF("Workforce Performance - Performance Rating Real Time"."Questionnaire Question"."Question Type") s_11,
DESCRIPTOR_IDOF("Workforce Performance - Performance Rating Real Time"."Questionnaire Question"."Response Status") s_12
FROM "Workforce Performance - Performance Rating Real Time"
ORDER BY 1, 2 ASC NULLS LAST, 3 ASC NULLS LAST, 11 ASC NULLS LAST, 5 ASC NULLS LAST, 4 ASC NULLS LAST, 10 ASC NULLS LAST, 9 ASC NULLS LAST, 6 ASC NULLS LAST, 8 ASC NULLS LAST, 7 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

/* QUERY_SRC_CD='rawSQL' */

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Added the columns only from "Workforce Performance - Performance Rating Real Time"."Questionnaire Question" and we are able to pull basic data from this folder.
2. If we add field from "Performance Document Status" Folder, the analysis does not return data.

Cause

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