TL9.2: TL_ST_LOADER Is Erroring Out AT
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.
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.
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)
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.
The issue has the following business impact:
Due to this issue, we can not load the punches into PeopleSoft and payroll is getting delayed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms