EAP 9.2: A Performance Degradation Problem Has Been Detected At Voucher Search And Opening Levels Once PeopleTools Were Upgraded To Release 8.54 (Doc ID 2276795.1)

Last updated on JUNE 14, 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:

The PeopleSoft Enterprise FSCM 9.2 Image #11 systems were upgraded from PeopleTools 8.53 to PeopleTools 8.54.26. Since then, the Payables Functional Users are complaining about a performance degradation when performing Voucher Search, and opening of the selected transaction, to get displayed the Voucher Summary page (VCHR_SUMMARY_PG). From different tests, the below have been the results obtained:

     - To return Voucher Search results using 3 characters: Used to be 1-2 seconds, but now it takes 12 to 28 seconds
     - To return Voucher Search results using 2 characters: Used to be around 4 seconds, but now it takes over a minute sometimes, but never less than 10 seconds
     - To return Voucher Search results using 1 character: Used to be around 4 seconds, but now it takes no less than 30 seconds each time, sometimes worse
     - To open the Voucher Summary page once a transaction was selected: Used to take around 2 seconds, but currently it is taking a mean of 26 seconds

In order to improve performance, the technical team already has tried to:

     - Purge the cache locally
     - Delete the cache from the Server
     - Restart the Database
     - Rebuild the Views
     - Placed an ORDERED hint on the PS_VND_LVL_DFHI_VW and PS_VOUCHER_SRCH_VW views

However, while performance improved in the beginning after such tasks, with the past of several hours of daily work, it would start slowing down once again.

REPLICATION STEPS:

     1.- Log into the FSCM Online Application as a Payables User
     2.- Navigate to: Accounts Payable > Vouchers > Add/Update > Regular Entry
     3.- Perform a search on existing Vouchers (using one, two, or three characters on Voucher ID field)
     4.- The performance degrades for the search results to be listed
     5.- Select one transaction, and wait to get the Voucher Summary Page (VCHR_SUMMARY_PG) displayed
     6.- Again, performance degradation is being experienced before the page gets fully loaded

ACTUAL RESULT:

The Regular Voucher search functionality used to be efficient, but since the PeopleTools upgrade took place, both the search and the opening of the Voucher Summary page take a much longer time to complete. This affects efficiency, and productivity of the involved Users.

EXPECTED BEHAVIOR:

Voucher Search results getting displayed, and those selected transactions opened should be achieved in an efficient and timely manner.

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