Time And Labor Load (PSPLDTL1) and TL_LOAD_CLNP
Good morning....
We experienced an issue with the Time and Labor Load Process (PSPLDTL1) where a user ran a custom process at the same time as PSPLDTL1 was running causing an abend in PSPLDTL1.
As a result, records are locked in TL_PAYABLE_TIME with Payable Status 'SP' and some of the records have gone to PAY_EARNINGS and PAY_OTH_EARNS, all of which need to be cleaned up and loaded again.
I have found Doc ID 1269684.1 that address this situation, although from a different cause. Additionally, this Doc ID references Doc ID 661174.1 a Red Paper with steps to clean-up and reprocess using the TL_LOAD_CLNP application engine. When I compare the Red Paper against this program I see the same processing and SQL statements. We are doing all this in a backup copy of production before attempting this in prod. I have tried to validate the results via SQL and my results seem to indicate we are good. The users will be validating first thing Monday morning from a functional perspective.