i created a mapping that loads data from an external table to the destination table.
The external table contains less fields than the destination table, so i leave these fields unconnected.
Verifying and delpoying the mapping works fine. So i did a test of the mapping.
Now a warning occurs "ORA-01400: cannot insert null into tablename.fieldname". But the field which is complained is one of the unconnected fields in my mapping.
But in the destination table this field is defined as NOT NULL.
Target table has 3 column . source has 2 column and those 2 gets connected to your target . The un-connected column is defined as not null .
Now when your code runs it inserts value for 2 column and a null value being passed to your 3rd target column.
Oracle does not like this and it gives error.
If you remove not null column then this issue will not come other wise set a default value to this column so that when your code runs it inserts value for 2 column and oracle privieds the default value to the 3rd column.