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