ETL9.1:TL_ST_LOADER Unique Constraint Error When Process Is Kicked From Financial Side.
(Doc ID 1585535.1)
Last updated on AUGUST 25, 2021
Applies to:PeopleSoft Enterprise HCM Time and Labor - Version 9 and later
Information in this document applies to any platform.
In 9.0 production environment TL_ST_LOADER when triggered from the finance side had two instances triggered with split second difference failed with unique constraint error
We have had a couple occurrences where two TL_ST_LOADER processes get initiated from the IB message ELAPSED_TIME_ADD. We see the first instance work on the rows designated by ST_INSTANCE and the 2nd TL_ST_LOADER then fails with a unique constraint
PSAESRV started service request at 05.12.15 2013-08-30
File: e:\pt85009b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1625 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_TL_ST_ELPTIME) violated
Failed SQL stmt:UPDATE PS_TL_ST_ELPTIME SET SEQNUM=2 WHERE EMPLID='47323' AND EMPL_RCD=0 AND DUR=TO_DATE('2013-08-26','YYYY-MM-DD') AND SEQNUM=3 AND ST_INSTANCE=19918
Process 446430 ABENDED at Step TL_ST_LIB.LDELPTIM.STEP025 (SQL) -- RC = 805 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 05.12.25 2013-08-30
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