My Oracle Support Banner

EAP: Performance Issue When Opening Vouchers Or Clicking Next/Previous Button on Voucher Entry Page (Doc ID 2724171.1)

Last updated on OCTOBER 29, 2020

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information 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


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