EAP: Performance Issue When Opening Vouchers Or Clicking Next/Previous Button on Voucher Entry Page
(Doc ID 2724171.1)
Last updated on JULY 02, 2023
Applies to:
PeopleSoft Enterprise FIN Payables - Version 9.2 and laterInformation in this document applies to any platform.
Goal
When opening vouchers or clicking Next/Previous button on Voucher Entry Page, there is a 20+ second delay.
In the trace file, below log can be seen:
PSAPPSRV.5888 (2625) 1-1192102 08.27.13 0.000000 Cur#3.5888.notSamTran RC=0 Dur=0.000000 Open Cursor Handle=0000022EE82A38E8
PSAPPSRV.5888 (2625) 1-1192103 08.27.13 0.000000 Cur#3.5888.FINLIVE RC=0 Dur=0.000000 COM Stmt=SELECT CONNURL FROM PSGATEWAY WHERE LOCAL_FLAG='Y'
PSAPPSRV.5888 (2625) 1-1192104 08.27.13 0.002000 Cur#3.5888.FINLIVE RC=0 Dur=0.000000 Fetch
PSAPPSRV.5888 (2625) 1-1192105 08.27.13 0.000000 Cur#3.5888.FINLIVE RC=1 Dur=0.000000 Fetch
PSAPPSRV.5888 (2625) 1-1192106 08.27.13 0.000000 Cur#3.5888.FINLIVE RC=0 Dur=0.000000 Disconnect
PSAPPSRV.5888 (2625) 1-1192107 08.27.34 21.045000 Cur#3.5888.notSamTran RC=0 Dur=0.000000 Open Cursor Handle=0000022EE82A38E8
PSAPPSRV.5888 (2625) 1-1192108 08.27.34 0.000000 Cur#3.5888.FINLIVE RC=0 Dur=0.000000 COM Stmt=SELECT IB_PRE_848 FROM PSIBPROFILE
PSAPPSRV.5888 (2625) 1-1192109 08.27.34 0.001000 Cur#3.5888.FINLIVE RC=0 Dur=0.000000 Fetch
Step:
1. Navigate to Regular Entry
2. Enter search criteria and opening a voucher
3. Click Next in List or Previous in List button
Solution
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
| Goal |
| Solution |
| References |