You can have a lot of trouble to resolve this error:
ORA-01400 Cannot Insert NULL into
When it's caused by a length of a string data type of zero in a target.
You can have this case when you use a bad ODBC driver to import your target tables