E-FLUID: Personalizing Fluid Homepage causes mass update to PSPRUHDEFN table and cause Performance Issue

(Doc ID 2097264.1)

Last updated on MARCH 23, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 to 8.55 [Release 8.4]
Information in this document applies to any platform.


When a user moves a tile on the homepage or does some other personalization , it will update the PSPRUHDEFN table with that userid as the last updated oprid... but it updates all the rows of other users who have previously updated this same home page . This causing a hanging effect to the end user. If the same action of personalizing the home page was done on a classic page , it only updated the row for that one userid.

Expected behaviour:

Only the one row for the user should be updated.

Observed behaviour:

All the rows for fluid home page for ALL the users is getting updated.

Steps to Replicate:

1. Login with an employee useid

2. access the Employee self service homepage

3. Personalize the home page by moving the position of a tile like for example " Personal Details "

Observe that page hangs

Business Impact:

This affects all users who access the application in Fluid mode.


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