Payroll for NA / Time and Labor - PSFT (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center