Fusion Applications - OTBI - "Workforce Talent Review - Talent Review Meeting Real Time" - Performance Issue With Inclusion Of Department Hierarchy Columns (Doc ID 2241742.1)

Last updated on JUNE 15, 2017

Applies to:

Oracle Fusion Application Toolkit Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Talent Review Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

Below is the sample analysis. As soon as we include the "Department Hierarchy" columns, the analysis does not finish execution and keeps running:

SELECT
0 s_0,
"Workforce Talent Review - Talent Review Meeting Real Time"."Box Matrix"."Performance and Potential Box Sequence" s_1,
"Workforce Talent Review - Talent Review Meeting Real Time"."Box Matrix"."Performance and Potential Box" s_2,
"Workforce Talent Review - Talent Review Meeting Real Time"."Calibrated Performance"."Rating Description" s_3,
"Workforce Talent Review - Talent Review Meeting Real Time"."Calibrated Performance"."Rating Level" s_4,
"Workforce Talent Review - Talent Review Meeting Real Time"."Calibrated Performance"."Rating Model" s_5,
"Workforce Talent Review - Talent Review Meeting Real Time"."Calibrated Potential"."Rating Description" s_6,
"Workforce Talent Review - Talent Review Meeting Real Time"."Calibrated Potential"."Rating Level" s_7,
"Workforce Talent Review - Talent Review Meeting Real Time"."Calibrated Potential"."Rating Model" s_8,
"Workforce Talent Review - Talent Review Meeting Real Time"."Department Hierarchy"."Level 1 Department" s_9,
"Workforce Talent Review - Talent Review Meeting Real Time"."Department Hierarchy"."Level 2 Department" s_10,
"Workforce Talent Review - Talent Review Meeting Real Time"."Department Hierarchy"."Level 3 Department" s_11,
"Workforce Talent Review - Talent Review Meeting Real Time"."Department Hierarchy"."Level 4 Department" s_12,
"Workforce Talent Review - Talent Review Meeting Real Time"."Department"."Department Name" s_13,
"Workforce Talent Review - Talent Review Meeting Real Time"."Grade"."Grade Name" s_14,
"Workforce Talent Review - Talent Review Meeting Real Time"."Job"."Job Name" s_15,
"Workforce Talent Review - Talent Review Meeting Real Time"."Position"."Position Name" s_16,
"Workforce Talent Review - Talent Review Meeting Real Time"."Talent Review Meeting Details"."Meeting Id" s_17,
"Workforce Talent Review - Talent Review Meeting Real Time"."Talent Review Meeting Details"."Meeting Status" s_18,
"Workforce Talent Review - Talent Review Meeting Real Time"."Talent Review Meeting Details"."Meeting Title" s_19,
"Workforce Talent Review - Talent Review Meeting Real Time"."Worker"."Employee Name" s_20,
"Workforce Talent Review - Talent Review Meeting Real Time"."Worker"."Manager Name" s_21,
"Workforce Talent Review - Talent Review Meeting Real Time"."Worker"."Person Number" s_22,
DESCRIPTOR_IDOF("Workforce Talent Review - Talent Review Meeting Real Time"."Job"."Job Name") s_23,
DESCRIPTOR_IDOF("Workforce Talent Review - Talent Review Meeting Real Time"."Position"."Position Name") s_24,
DESCRIPTOR_IDOF("Workforce Talent Review - Talent Review Meeting Real Time"."Talent Review Meeting Details"."Meeting Status") s_25
FROM "Workforce Talent Review - Talent Review Meeting Real Time"
ORDER BY 1, 18 ASC NULLS LAST, 20 ASC NULLS LAST, 19 ASC NULLS LAST, 23 ASC NULLS LAST, 21 ASC NULLS LAST, 22 ASC NULLS LAST, 14 ASC NULLS LAST, 16 ASC NULLS LAST, 17 ASC NULLS LAST, 15 ASC NULLS LAST, 6 ASC NULLS LAST, 5 ASC NULLS LAST, 4 ASC NULLS LAST, 9 ASC NULLS LAST, 8 ASC NULLS LAST, 7 ASC NULLS LAST, 2 ASC NULLS LAST, 3 ASC NULLS LAST, 10 ASC NULLS LAST, 11 ASC NULLS LAST, 12 ASC NULLS LAST, 13 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

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