My Oracle Support Banner

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.

Symptoms

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.

SQL Statements
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
  

Changes

 Tax Update 18-D

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.