AP: Voucher Spreadsheet Upload Performance

(Doc ID 2421403.1)

Last updated on JULY 10, 2018

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.



We are experiencing performance issue with Voucher Spreadsheet upload performance.
Generate XML process taking approximately 16 minutes to process 1 voucher with 2500 lines and also taking similar amount of time to generate XML to create 2000 vouchers for different suppliers.

That is, more than 90% time generating XML and 10% to post the voucher into staging table. Therefore, the tuning at the database level is limited due to the small % of time during POST process. Need to know if Oracle has a way to improve the performance during XML generation.


1. Load vouchers via excel voucher upload with 2000 vouchers




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