Compare files with "ORA-01843: not a valid month" (4304777)

The compare/repair fails and exits with the following error in the sp_declt log:
000: Notice: Object ID of "SCHEMA"."TABLENAME" is 11751
000: Oracle Error: ORA-01843: not a valid month
000: Error 1843 calling oexec in de_repair_update
000: No further repairs will be applied
000: Error 1 calling de_repair_update in de_compare_client
000: Continuing to process so all the out-of-sync rows are reported
000: Status : Error
000: Status : Error
000: Error -1 calling de_compare_client in main
Exiting

You have invalid data in your source table.

The *.sql file of the compare/repair will contain the following message:
/*
* The following Oracle error occurred while repairing.
* ORA-01843: not a valid month
*
* The SQL statement immediately above, and all the statements
* following this message will not be applied.
*/
Check the SQL statements for invalid field data, in this example it was this offending data:
.....
SCHEDULE_DATE" = to_date('000000000000000'
,'SYYYYMMDDHH24MISS'),"
.......
-AND-
...
ATTRIBUTE6" = '27-ABR-07',"ATTRIBUTE7
....

Correct the invalid data and re-run compare/repair