EAP: Performance Issue With Unpaid Voucher Status Link On Payables WorkCenter

(Doc ID 2015690.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ISSUE
Accounts Payable WorkCenter performance problem with the Unpaid Voucher Status link in our FSCM 9.2, PUM 10, PTools 8.54.05 test database.  When the user edits the filter to limit the number of rows returned, refreshing the filter takes nearly 4 minutes to complete. If the user then clicks on the Unpaid Voucher Status link, the processing wheel spins but never returns any results.

The longest running sql statement is:
SELECT COUNT(*) FROM PS_AP_WC_VCHUNP_VW WHERE 1=1 and BUSINESS_UNIT = 'MM1' and ENTERED_DT > TO_DATE('2014-06-30','YYYY-MM-DD'). Total time spent on this statement=349.847862.


STEPS
1) Edit filter for Unpaid Voucher Status to limit the number of rows returned
2) Click on the Unpaid Voucher Status link

Cause

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