My Oracle Support Banner

ELM 9.2: Process Asynchronous Data (AE LM_LD_ASYNC) Fails with Status No Success and Error Message Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL: INSERT INTO PS_LM_ACT into ("SYSADM"."PS_LM_ACT"."LM_START_DT") Failed SQL s (Doc ID 2925046.1)

Last updated on FEBRUARY 09, 2023

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

 
Process Asynchronous Data (Application Engine LM_LD_ASYNC) fails with status no success and receives an error message.


Error Message: 

Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL: INSERT INTO PS_LM_ACT into ("SYSADM"."PS_LM_ACT"."LM_START_DT") Failed SQL stmt: INSERT INTO PS_LM_ACT (LM_ACT_ID,LM_ACT_CD,LM_ACT_STATUS,LM_CI_ID,LM_DMTHD_ID,LM_DMTHD_TYPE_ID,LM_DISP_DATES,LM_MIN_ENRLMT,LM_MAX_ENRLMT,LM_PRG_AUTO_ENROLL,LM_NFRC_MAX_ENRLMT,LM_ENRL_TOT,LM_ENABLE_WTLST,LM_WTLST_CAP,LM_WTLST_TOT,LM_APRVL_TYPE_REQ,LM_APRVL_REQ_EXT,LM_ENRLMT_ADMIN_ID,LM_NFRC_PRQ,LM_AUTO_ATND,LM_AUTO_CMPL_DURN,LM_AUTO_ASGN_OBJV,LM_CEU,LM_LST_ENRL_START,LM_LST_ENRL_DAYS,LM_LST_ENRL_TYPE,LM_LST_DROP_START,LM_LST_DROP_DAYS,LM_LST_DROP_TYPE,LM_RMNDR_DAYS,LM_RMNDR_ID,LM_ACT_OWNER_ID,LM_OVERBOOK_PCT,LM_MIN_ENRL_DAYS,LM_LRN_PD_DAYS,LM_WRN_PD_DAYS,LM_INSTR_ID,LM_NFRC_COMP_ORDR,LM_ACT_TYPE,LM_ALLOW_CMPL_HIST,LM_LAUNCHABLE_HIST,LM_DURN_DAYS,LM_DURN_HRS,LM_DURN_MINS,LM_RESTRICT_TO_PRG,LM_RSRV_SEAT_MAX,LM_RSRV_SEAT_TOT,LM_INT_PRICE,LM_EXT_PRICE,LM_TRNG_UT,LM_INT_DP_PRICE,LM_EXT_DP_PRICE,LM_DP_TRNG_UT,CURRENCY_CD,LM_ROW_ADDED_OPRID,LM_ROW_MAINT_DTTM,LM_ROW_MAINT_OPRID,LANGUAGE_CD,LM_SPL_APPROVER,LM_WAIT_THRESHOLD,LM_LRQ_TOT,LM_RSN_CD,LM_RSRV_TYPE,LM_RSRV_ORG_ID,LM_PROVIDED_BY,LM_GEN_OBJ,LM_CODE_SEQ) 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,TO_TIMESTAMP(:56,'YYYY-MM-DD-HH24.MI.SS.FF'),:57,:58,:59,:60,:61,:62,:63,:64,:65,:66,:67)


The issue can be reproduced at will with the following steps:

  1. After Message WORKFORCE_SYNC completes to Status Done.

        Navigation:  Peopletools > Integration Broker > Service Operations Monitor

  1. Run Process Asynchronous Data, Application Engine LM_LD_ASYNC

        Navigation: Main Menu > Set up ELM > Process Asynchronous Data

  1. Notice process runs to no success and the Std Report file contains an error message.

        Navigation: Peopletools > Process Scheduler > Process Monitor

 

Changes

 

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
Changes
Cause
Solution
References


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