ETL9.1 Time Admin Failed With Error ORA-01400: cannot Insert NULL into ("SYSADM"."PS_TL_TA_MAIN_AET"."EMPLID") (Doc ID 1572124.1)

Last updated on JULY 03, 2017

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Goal

ISSUE STATEMENT
================
Time Admin Failed with following error ORA-01400: cannot insert NULL into ("SYSADM"."PS_TL_TA_MAIN_AET"."EMPLID")
Refresh TL Security AE also failed with error ORA-01400: cannot insert NULL into ("SYSADM"."PS_TL_TA_MAIN_AET"."EMPLID")

ENVIRONMENT
=============
PeopleSoft HCM 9.1 Bundle 11
PeopleTool 8.52

ERROR
======
ORA-01400: cannot insert NULL into ("SYSADM"."PS_TL_TA_MAIN_AET"."EMPLID")
Failed SQL stmt:INSERT INTO PS_TL_TA_MAIN_AET (PROCESS_INSTANCE,OPRID,RUN_CNTL_ID,AE_SECTION,AE_PROGRAM,RECNAME,BATCH_NUM,STORE_RULE_MAP,STORE_BTCH_INFO,WORKGROUP,RULE_PGM_ID,TL_FORECASTED_IND,TIME_RPTG_TYPE,USE_CURRENT_DATE,TL_RSL_MAIN_IND,TL_RSL_BATCH_IND,TL_RSL_SECT_IND,TL_KEEP_CT,KEEP_GOING,TL_IN_PROD,TL_TA_STARTED,ALT_RUN_CTRL_ID,ST_INSTANCE,TL_IPT_CT,IMAGE_NUM,TABLE_NAME,TA_BATCH_SIZE,CURRENT_YEAR,PUNCH_COUNT,TL_USE_RPTD_TIME,ATTENDANCE_PGM_ID,TL_ONLINE_RULES,TA_COUNTER,TA_COUNTER1,TA_COUNTER2,DBNAME,TL_PAY_TIME_CT,TL_FRCT_TIME_CT,TL_EXCEPT_CT,COUNTER,PERCENTAGE,TEMP_FLD,TA_PCT_COUNTER2,SQLID,EXIST,AE_APPLID,ELAPSED_COUNT,HOLIDAY_COUNT,PAYABLE_COUNT,TRC_TYPE,TL_NOTIFICATION,DESCR,TL_CONTINUE_TA,TL_AM_EXIST,TL_EXCEPTION,INCL_ALL_EMPL_RCD,TL_APRV_RETRO,TL_PAY_APRVL,TL_RI_CHECK,PRIORITY) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43,:44,:45,:46,:47,:48,:49,:50,:51,:52,:53,:54,:55,:56,:57,:58,:59,:60)

2013-07-23-10.28.27.218149 AeStatCheckpoint [606] Exception logged: RC=8.

Temporary Table processing failure during allocation phase. (108,530)
2013-07-23-10.28.27.218206 ProcessRequest [1669] Exception logged: RC=8.
10.28.26 SQL Error: ORA-01400: cannot insert NULL into ("SYSADM"."PS_TL_TA_MAIN_AET"."EMPLID")
 

Solution

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