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.

Symptoms

 

ISSUE:
 
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.

 

STEPS:
 
1. Load vouchers via excel voucher upload with 2000 vouchers

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