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