Skip to main content

Error: 'ORA-01400: cannot insert NULL into ("COREHR"."PSOFT_NON_TIMESHEET"."START_DATE") ORA-06512: at "SYS.DBMS_SQL")'

When loading a PeopleHUB file, the following error appears.

O
Written by Onyema Onyejekwe
Updated over a month ago

If you encounter this error when attempting to load a PeopleHUB file, it is due to a missing required field in the input file.

This error indicates that a field expected by the system is missing (NULL). Specifically, the START_DATE field is either unpopulated or incorrectly positioned in the file. The system requires this field to insert data, and its absence will cause the load to fail.


Error handling overview

When processing PeopleHub files, two types of errors can occur:

  1. Stop Errors: These errors prevent the file (or specific records) from being uploaded due to structural issues in the file format.

  2. Validation Errors: These errors occur when data passes formatting checks but fails internal system validation.

Files that pass both types of checks can be successfully uploaded to PeopleXD.


Correct file format

To fix the file format, follow the steps below.

  1. From the dashboard menu, select PeopleHub Dashboard.

  2. Click Settings tab then beside the External HR Interface file group, click the three dot icon.

  3. Click Files then locate the appropriate file type:

    • Allowances/Deductions for NON_001_*** files

    • Employee for EMP_*** files

  4. To view the expected file format, click the three-dot icon then click Columns.

  5. Compare the column structure to your file and ensure the START_DATE field is in the correct column.

  6. Correct your file to match the required format and reload it.

Did this answer your question?