My Oracle Support Banner

ETL9.2: PSPLDTL1 Runs Slow In PSPLDTL2_S_PAYSHT When Processing Employees In Many Paygroups. (Doc ID 2533442.1)

Last updated on DECEMBER 11, 2019

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Load Time and Labor and Pay Calculation are running slow after applying TAX Update 18D.

R e t r i e v e C o m p i l e E x e c u t e F e t c h STMT TOTALS

Statement Count Time Count Time Count Time Count Time Time %SQL

PSPLDTL2_S_PAYSHT 15 0.00 15 0.02 15 3680.38 9335 0.26 3680.65 68.08

STEPS
-----------------------

1. Load payable time to Payroll and or Preliminary Calculation
2. The work tables get populated with the data that not cleaned up in the end of the process
3. Next Load or Pay Calculation would take a long time to complete

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.