4 Replies Latest reply on Aug 6, 2015 6:51 AM by Jagadekara

    problem with insert into CST_ITEM_COSTS (ORA-01722:invalid number)

    2679576

      Hi,

      I would like to insert a line in the table CST_ITEM_COSTS but i have an error ORA-01722:invalid number.

      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,'Y','16,013','16,013','16,013','16,013','16,013',2);
      
      

      Please can you help me i didn't fix the problem ?