TL9.2: TL_ST_LOADER Is Erroring Out AT (Doc ID 2052129.1)

Last updated on JUNE 01, 2017

Applies to:

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

Symptoms

On : 9.2 version, TL Integrations

TL9.2- TL_ST_LOADER is erroring out

We just upgraded from 9.1 to 9.2 and we are hitting errors and processes keep getting blocked while TA is running.


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

Process 1885053 resumed after step TL_ST_LIB.GA000_P.Step120 (108,538)

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1703 Error Position: 30 Return: 1407 - ORA-01407: cannot update ("SYSADM"."PS_AUDIT_TLRPTTIME"."REPORTED_STATUS") to NULL
Failed SQL stmt: UPDATE PS_AUDIT_TLRPTTIME SET REPORTED_STATUS = ( SELECT B.REPORTED_STATUS FROM PS_TL_RPTD_TIME B WHERE B.ST_INSTANCE = 829557 AND B.ST_INSTANCE = PS_AUDIT_TLRPTTIME.ST_INSTANCE AND B.EMPLID = PS_AUDIT_TLRPTTIME.EMPLID AND B.EMPL_RCD = PS_AUDIT_TLRPTTIME.EMPL_RCD AND B.DUR = PS_AUDIT_TLRPTTIME.DUR AND B.PUNCH_TYPE = PS_AUDIT_TLRPTTIME.PUNCH_TYPE AND PS_AUDIT_TLRPTTIME.SEQ_NBR = B.SEQ_NBR AND PS_AUDIT_TLRPTTIME.AUDIT_ACTN = 'A' AND PS_AUDIT_TLRPTTIME.AUDIT_OPRID = 'PSAPPS' AND PS_AUDIT_TLRPTTIME.REPORTED_STATUS= ' ' AND B.REPORTED_STATUS <> ' ') WHERE ST_INSTANCE = 829557 AND AUDIT_OPRID = 'PSAPPS' AND AUDIT_ACTN = 'A' AND REPORTED_STATUS = ' '

Process 1885053 ABENDED at Step TL_ST_LIB.GA000_P.Step151 (SQL) -- RC = 1407 (108,524)
 




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
 1. Punches coming from Time clocks(Cesium) and kicks off the TL_STLOADER to load punches, we have one job got failed this morning and rest of them all are failing due to that.

BUSINESS IMPACT
 -----------------------
 The issue has the following business impact:
 Due to this issue, we can not load the punches into PeopleSoft and payroll is getting delayed.

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