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

Last updated on JULY 13, 2018

Applies to:

Symptoms

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.



ACTUAL BEHAVIOR
---------------
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.

 
EXPECTED BEHAVIOR
-----------------------
Performance should be the same after upgrade

STEPS
-----------------------
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

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

Cause

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