ETL9.2: Poor Performance In Time And Labor TEAM TIME Tile
(Doc ID 2384164.1)
Last updated on OCTOBER 02, 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.
On : 9.2 version, Technical
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?
Fluid pages should not experience performance issues
The issue can be reproduced at will with the following steps:
Navigate to MSS Team Time Tile.
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