SAP Knowledge Base Article - Public

2495081 - Error message : ORA-01400: cannot insert NULL into "COL_NUM99_VAL" while running schedule offering connector

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

Product

SAP SuccessFactors Learning all versions