ETL9.2: Poor Performance In Time And Labor TEAM TIME Tile

(Doc ID 2384164.1)

Last updated on APRIL 09, 2018

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Technical

ACTUAL BEHAVIOR
---------------
Extremely poor performance in Time and Labor TEAM TIME Tile and navigating to Fluid pages

Performance for the Admin type employees is extremely slow when navigating to Fluid pages, mainly in the MSS Team Time Tile. We are using "Security by Permission list" core security setup. For system Administrators we give them a cloned version of Permission list "HCDPALL" called "HYDPALLC" for their Primary and Row Security in their User Profile page of their security.
 
The performance for Non-Admin Employees is better however we still see a big difference when navigating between classic page and Fluid pages within the system but mainly in Time and Labor.

We ran a trace and it is attached along with some other screen shot that we received.

In looking at it, I’m still seeing 22551 occurrences of:
SELECT EMPLID, EMPLOYEE_PHOTO FROM PS_USER_PH_CARD_FL WHERE EMPLID=:1 ORDER BY EMPLID

Is this normal and can we do anything to stop that execution?


EXPECTED BEHAVIOR
-----------------------
Fluid pages should not experience performance issues

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Navigate to MSS Team Time Tile.
 

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