My Oracle Support Banner

AP: Voucher Spreadsheet Upload Performance (Doc ID 2421403.1)

Last updated on FEBRUARY 01, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.