My Oracle Support Banner

EAP: Performance Issue With Unpaid Voucher Status Link On Payables WorkCenter (Doc ID 2015690.1)

Last updated on FEBRUARY 04, 2019

Applies to:

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


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.

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


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.