My Oracle Support Banner

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.

Symptoms

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.