Performance Issue With Voucher Approval Framework

(Doc ID 2381458.1)

Last updated on APRIL 02, 2018

Applies to:

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

Symptoms

Performance issue with Voucher Approval Framework

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. When there are more than 300 + vouchers to be submitted for approval framework as each submission is taking few seconds.


ERROR
-----------------------

ORA-01555: snapshot too old: rollback segment number 1 with name "_SYSSMU1_3819742559$" too small Failed SQL stmt: SELECT BUSINESS_UNIT , VOUCHER_ID FROM PS_VCHR_APPR_TAO16 WHERE PROCESS_INSTANCE = 19163324 AND PROCESSED_FLG = 'N'

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