EPY: Paycalc Running Slow After Tax Update 18-D
(Doc ID 2502733.1)
Last updated on JUNE 29, 2021
Applies to:PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 and later
Information in this document applies to any platform.
Customer applied Tax Update 18-D and noted that the Update Caused an increase run time for PSPPYRUN when processing Payroll Off-Cycle data
with large number of rows.
There are 3 SQL's that are looping once per row. Processing of 3000+ rows
took 4 hours long.
1. PSPSTCAL_S_DEDUS -- 2887 executions in 9200 seconds/2.5 hours (3+ seconds per execution)
2. PSPSTCAL_S_ERNUS -- 2200 executions in 1600 seconds
3. PSPSTCAL_S_TAXUS -- 2200 in 870 seconds
Tax Update 18-D
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