Symptom
Receiving error message "ORA-01400: cannot insert NULL into "COL_NUM99_VAL"" while running schedule offering connector.
Environment
SuccessFactors Learning
Learning Management
Reproducing the Issue
1) Create a input file for schedule offering connector.
2) Ensure that "COL_NUM99_VAL" field value in input file is Null.
3) Place the input file on SFTP.
4) Schedule the schedule offering connector.
5) Check connector results and you will see the error message "ORA-01400: cannot insert NULL into "COL_NUM99_VAL""
Cause
Null values in input file for "COL_NUM99_VAL" field is cuaing the error message.
Resolution
To avoid the error message "ORA-01400: cannot insert NULL into "COL_NUM99_VAL"" while using schedule offering connector.
Request you to pass a unique value for "COL_NUM99_VAL" field in the input file for schedule offering connector.
Note: 1) Legacy ID is a default field mapped to the custom column COL_NUM99_VAL.
2) "COL_NUM99_VAL" is a mandatory field for schedule offering connector.
Keywords
COL_NUM99_VAL schedule offering connector ORA-01400: cannot insert NULL into "COL_NUM99_VAL" , KBA , LOD-SF-LMS-CON , Connectors , Problem