EAP 9.2: Performance Degradation At Invoice Information Page When Saving New Comments On A Voucher With 1200 Lines

(Doc ID 2396855.1)

Last updated on MAY 21, 2018

Applies to:

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

Symptoms

ISSUE:

Payables Users are unable to successfully save Comments at the Voucher Header level, once entered in the Voucher Comments Page (VCHR_COMMENTS_TXT), if the affected Voucher contains a large amount of Invoice Lines, such as 1,200. The system suffers from a performance degradation, and eventually it times out, kicking the User out of the PeopleSoft session. Upon returning into the transaction, the Voucher Header Comments have not been registered, (Record Field PS_VOUCHER.DESCR254_MIXED is empty).

Similar problem was already raised in the past via <Bug 23505161> (EAP: PERFORMANCE ISSUES WHILE ADDING HEADER COMMENTS ON LARGE VOUCHER), and a fix was delivered within PeopleSoft Enterprise FSCM 9.2 Image #21. However, that was for a sample Voucher with roughly 700 Invoice Lines. The issue seems to still persist with larger volume transactions.

REPLICATION STEPS:

     1.- Use the ExcelUploadforVouchers Excel Spreadsheet to interface a new Voucher ID with 1200 Invoice Lines into the Voucher Staging Tables
     2.- Launch Voucher Build to create the Voucher transaction at hand
     3.- Open the transaction in the Regular Voucher component
     4.- Go to the Invoice Information tab, and click on the Comments link available
     5.- Once at the Voucher Comments Page (VCHR_COMMENTS_TXT), enter a new comment, and click on OK
     6.- Click on SAVE button to register the latest changes into the database
     7.- The Internet Browser keeps spinning, until it times out

ACTUAL RESULTS:

As Voucher Header Comments cannot be added at Voucher Maintenance or Voucher Search components, and only at Regular Entry, such information cannot be recorded in the system, affecting possible auditing on such transactions.

EXPECTED BEHAVIOR:

The system should allow the proper saving of Voucher Header Comments (Record Field PS_VOUCHER.DESCR254_MIXED) on transactions with large volume of Invoice Lines on the Regular Entry component, and if not, provide an alternative for such scenarios, such as Voucher Maintenance pages.

 

Changes

 

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