Fusion HCM OTBI - Poor performance / slow response when add the column Person Profile Real Time - Person Profile - All Profile Content - ItemText3010 (Doc ID 1997155.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Symptoms

Fusion HCM 11.1.8 Cloud - column Workforce Profiles - Person Profile Real Time"."- All Profile Content"."ItemText3010" can cause poor  performance /lapsed times when used in analysis

Unexpected behavior
------------------------------------------

The column by itself  Elapsed time 0.019 seconds

compare this with an analysis using it plus 2 other columns, the lapsed time increases:

with 3 columns

"Workforce Profiles - Person Profile Real Time"."- All Profile Content"."ItemText3010" s_1,
  "Workforce Profiles - Person Profile Real Time"."Worker"."Employee Name" s_2,
  "Workforce Profiles - Person Profile Real Time"."Worker"."Person ID" s_3
FROM "Workforce Profiles - Person Profile Real Time"
ORDER BY 1, 2 ASC NULLS LAST, 3 ASC NULLS LAST, 4 ASC NULLS LAST
FETCH FIRST 75001 ROWS ONLY

Elapsed time 16.576

Other Notes:   ItemText3010 is equal to Content_type_ID and is a NUMBER (3-digit)

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