...
An exception report is generated and saved with a Timesheet Import batch whenever a batch completes processing successfully and one or more timesheet exceptions were encountered during the processing of the batch. That is, an exception report is generated for a batch if the final status of the batch is Completed with Exceptions. An exception report is also generated for a Timesheet Import batch if there are no exception errors in the import file, and therefore the status of the batch is Completed, but there are one or more leave request warnings.
A timesheet exception occurs when Timesheet Import is unable to create a timesheet or timesheet item based on the data contained in a row of the import file. For example, if a row in the import file references a job order number that does not exist then it will not be possible to create the corresponding timesheet or timesheet item. In such cases, the corresponding timesheet is not created and the offending row, and all other rows in the import file that correspond to the same timesheet, are written to the exception report.
...
the first row of the report lists the column header names from the original import file
subsequent rows in the report list each row from the original import file that failed to be imported (failed rows)
beneath to the right of each failed row is an Error Message column displays the exception/error message that applies to the preceding failed row.
...
Exceptions can apply to individual rows (timesheet items) or an entire timesheet. Where the latter is the case, the relevant exception error appears beneath next to each row that corresponds to the timesheet. For example, if a timesheet corresponds to a standard rates job order but none of the items in the import file that correspond to the timesheet represent additional items, each row for that timesheet will be written to the exception file and will be flagged with an exception error.
...
For more information about exception errors that may be logged to the exception report, see Data Validation.
Leave Request Warnings
If an attendance or additional item in a timesheet import file clashes with an approved leave request that already exists in the FastTrack system, a warning message such as the following will be written to the exception report:
...