My Oracle Support Banner

E-PC: PT 8.56 Performance Issues After Transfer peoplecode is triggered. (Doc ID 2422927.1)

Last updated on FEBRUARY 07, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.56 and later
Information in this document applies to any platform.


PT 8.56.05
FSCM 9.2
PUM 11 but multiple patches have been applied
Using classic page
User is clicking a link on a custom grid and when the new window is opened it and it takes 200 seconds

The parent grid has 337,000 rows in it and it ti chunked at 1000. The secondary page only has 1 row.

PageTransfer call very slow after PT8.56.05 upgrade

Custom page calling delivered pagetransfer peoplecode. After 8.56 upgrade, the transfer takes a very long time to complete. Appears to be isolated to specific page, but I'm not entirely sure about that.

Developers have traced PC for a "good" and "bad" environment, and noted the only difference as this in "bad":
PSAPPSRV.1141 (153) 1-7364 04.17.08 213.656839 Cur#0.1141.PSFDV2 RC=0 Dur=0.000344 Destroy Connection Handle=000000000237D8D0

A trace from a "good" environment does not has a "destory connection handle" call - it just moves on to creating the next connection.

Performance should be the same after upgrade

The issue can be reproduced at will with the following steps:
1.User logs in and navigates to custom page with grid
2. Selects a row on the grid where another window will open
3. System hangs for 3.5 minutes before rendering page

The issue has the following business impact:
Due to this issue, users experience performance when clicking on link in grid on custom page.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.