Good, now you are certain the problem is caused by these offending dates.

Would you mind in loading a single row with effect_date = '11-MAR-08 03.24.52.312664000 AM -07:00'... meaning, the format your database appears to be expecting?