My Oracle Support Banner

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

Last updated on APRIL 22, 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 is 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

After the process is complete, here are the rows count remaining in the tables.
PS_PY_PYBL_TM_WRK - Number of rows still exist in the table is 72215. (all of them in IG status)
PS_PY_LDTLEMP_WRK1 number of rows exist is zero.
PS_PY_LDTLEMP_WRK2 number of rows exist is zero.

REPLICATION STEPS
=================
1. Run Paysheet Creation process prior to running the Load job.

2. Run the Load job with Processing Option: Load Filtered Time. Filtered time is defined by Company and Paygroup.

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
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.