Skip to main content

Error: 'Unable to read External Timesheet date file'

When trying to load an external timesheet takeon file, the below error message is received: Unable to read External Timesheet date file, please check date file being loaded ... ...ORA-06502: PL/SQL: numeric or value error.

O
Written by Onyema Onyejekwe
Updated over 3 months ago

If you encounter this error message when loading an external timesheet takeon file, it's likely due to a data issue within the file.

The error message indicates that the system has detected inconsistencies in the data format or that the file contains invalid values.

To resolve the file loading error, follow these steps.


Review file format

  1. Open the External Timesheet Takeon user guide.

  2. Compare your file structure against the provided template.

  3. Verify that all required fields are present and correctly formatted.

  4. Check that data types match the template specifications (numeric fields contain only numbers).


Check for blank lines

  1. Open your timesheet file in a Notepad (not Excel or other spreadsheet applications)

  2. Scroll to the end of the file then remove any blank lines at the end of the file

  3. Save the file after making changes.


Validate Data Content

  1. Review each row for:

    • Missing required data

    • Invalid characters in numeric fields

    • Incorrect date formats

    • Extra spaces or special characters

  2. Correct any identified issues then save the file in the correct format.


​

Did this answer your question?