ETL9.1TL_ST_LOADER Has Been Failing AT TL_TA000600.SLCTPNCH.Step02b. (Doc ID 1618508.1)

Last updated on JANUARY 22, 2016

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 9 and later
Information in this document applies to any platform.

Symptoms

On : 9 version, TL Integrations

When attempting to run TL_ST_LOADER
the following error occurs.

ERROR
-----------------------

PeopleTools 8.53.02 - Application Engine Server
Copyright (c) 1988-2014 Oracle and/or its affiliates.
All Rights Reserved


PSAESRV started service request at 10.48.45 2014-01-02


Process 1246230 resumed after step TL_TA000600.SLCTPNCH.Step02a (108,538)

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_TL_PMTCH_TMP18) violated
Failed SQL stmt: INSERT INTO PS_TL_PMTCH_TMP18 (PROCESS_INSTANCE, EMPLID, EMPL_RCD, PUNCH_DTTM, SEQ_NBR, DUR, PUNCH_TYPE, HR_TYPE) SELECT A.PROCESS_INSTANCE, A.EMPLID, A.EMPL_RCD, A.PUNCH_DTTM, 100 + A.SEQ_NBR, A.DUR, A.PUNCH_TYPE, ' ' FROM PS_TL_PMTCH1_TMP8 A WHERE A.PROCESS_INSTANCE = 1246230 AND A.PUNCH_DTTM = ( SELECT MIN(B.PUNCH_DTTM) FROM PS_TL_PMTCH1_TMP8 B WHERE B.PROCESS_INSTANCE = 1246230 AND B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD)

Process 1246230 ABENDED at Step TL_TA000600.SLCTPNCH.Step02b (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 10.48.45 2014-01-02

 



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Reported time is being processed by TL_ST_LOADER.
2. TL_ST_LOADER fails with following error:

 

 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, time cannot be processed and may result in delayed payroll.

Cause

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