Hello,
i'm trying to bulk insert data into planning and i get an error. As i can understand it seems related to some bad settings regarding decimal separator. I'm from italy where default decimal separator is ",". As far as i can check everything is set on english including Oracle Client (... sqlldr).
As you can see in datafile.log i get oracle ORA-01722 error.

Processing Codes:------------------------------------------------------------------------------------------------BLANK............. Line is blank or empty.ESD............... Excluded String Detected, SKIP Field value was found.NN................ Non-Numeric, Amount field contains non numeric characters.RFM............... Required Field Missing.TC................ Type Conversion, Amount field could be converted to a number.ZP................ Zero Suppress, Amount field contains a 0 value and zero suppress is ON.

Control File: C:\Users\INSTAL~1\AppData\Local\Temp\tWadmin154840402517.ctlCharacter Set UTF16 specified for all input.Using character length semantics.First primary datafile C:\Users\INSTAL~1\AppData\Local\Temp\tWadmin154840402517.tmp has alittle endian byte order mark in it.

Table TWADMIN154840402517:
+0 Rows successfully loaded.+
+51 Rows not loaded due to data errors.+
+0 Rows not loaded because all WHEN clauses were failed.+
+0 Rows not loaded because all fields were null.+