ETL9.2 TL_ST_LOADER Failing at Step TL_ST_LIB.GA000_E.Step121 (SQL)
(Doc ID 2194045.1)
Last updated on OCTOBER 06, 2023
Applies to:
PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
TL_ST_LOADER process is failing at step TL_ST_LIB.GA000_E.Step121 (SQL) with the following error message:
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 = 270996 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 =
'HUMPRCS' AND PS_AUDIT_TLRPTTIME.REPORTED_STATUS= ' ' AND B.REPORTED_STATUS
<> ' ') WHERE ST_INSTANCE = 270996 AND AUDIT_OPRID= 'XXXXXX' AND AUDIT_ACTN
= 'A' AND REPORTED_STATUS = ' '
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 |
Cause |
Solution |
References |