This columns (inventory_asset_flag, TL_MATERIAL, material_cost,tl_item_cost,item_cost,unburdened_cost) are 'NUMBER' data type you are passing string.
Please check the below possibility of getting the error.
- Non numeric column is specified without quotation.
- The description of the column was inserted, string into a numeric field.
As stated in above posts, you are trying to insert a non-numeric in a numeric field.
When writing your insert (or update) statements, you should check the data types of the columns you're using and any numeric columns values shouldn't contain non-numeric characters and no need to enclose then in quotes. Although Oracle does some implicit conversion, you should not rely on it (as best practice).
Try the following:
insert into CST_ITEM_COSTS( inventory_item_id, organization_id, cost_type_id, last_update_date,last_updated_by,creation_date,created_by, inventory_asset_flag,tl_material,material_cost,tl_item_cost,item_cost,unburdened_cost,defaulted_flag ) values ( 124431,88,2, to_date('17-JUN-15','DD-MON-RR'),1256,to_date('17-JUN-15','DD-MON-RR'),1256, 1,16013,16013,16013,16013,16013,2 );
As I guess you want to insert 16.013 in your table for those columns. If yes then give like this. 16.013 instead of '16,013'
When ever we try to insert string into number data type this error will occur.