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:

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

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