ETL9.x: Deadlock On PS_PY_PYBL_TM_WRK Table
Last updated on JULY 13, 2016
Applies to:PeopleSoft Enterprise HRMS Time and Labor - Version: 9
Information in this document applies to any platform.
Deadlock on table PS_PY_PYBL_TM_WRK while running Time Loads in 9.0 (PSPLDTL1)
This issue is with multiple loads running at the same time. It deletes old records from temp table. The following SQL statement needs to be modified.
WHERE PAYROLL_REQ_NUM <= :1
AND 1 = (SELECT COUNT(*) FROM PS_PMN_PRCSLIST WHERE PRCSNAME= 'PSPLDTL1' AND RUNSTATUS ='7') ;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms