Oracle Error Message
SQL*Loader-00427: a field condition references a non-scalar field or a LOB field string
Reason for the Error
The field condition is referencing a field which is either a nested table, varray, column object, LOB or BILE field. These fields with these typescannot be references by other field.
Solution
Correct the NULLIF, DEFAULTIF, or WHEN clauses to reference only non-LOB scalar data fields.