EAP: Performance Issue With Unpaid Voucher Status Link On Payables WorkCenter
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.
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
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