FRM-40212: Invalid value for field SERIAL_NUMBER

SELECT group_mark_id,

  line_mark_id,

  lot_line_mark_id

FROM mtl_serial_numbers

WHERE inventory_item_id=2701

AND serial_number     IN ('12703','12717');

SELECT inventory_item_id "Item Id", serial_number "Serial Number",

       current_organization_id "Organization Id", lot_number "Lot Number",

       DECODE (current_status,

               1, 'Defined but not used',

               3, 'Resides in Stores',

               4, 'Out of Stores',

               5, 'Intransit',

               6, 'Invalid',

               NULL, 'Verify Serial Number',

               current_status

              ) "Status",

       current_subinventory_code "Subinv", current_locator_id "Locator",

       group_mark_id "Group Mark Id", line_mark_id "Line Mark Id",

       lot_line_mark_id "Lot Line Mark Id", last_update_date

  from mtl_serial_numbers

 where  1 = 1

 and inventory_item_id = 4325

 and current_subinventory_code='EIS001062C'

 and serial_number in ('TB1-M000996','TB1-M000997','TB1-M000998','TB1-M000999','TB1-M001000','TB1-M001001','TB1-M001007','TB1-M001008')

  --UPDATE mtl_serial_numbers

SET group_mark_id      =NULL,

  line_mark_id         =NULL,

  lot_line_mark_id     =NULL

WHERE inventory_item_id=4325

 and current_subinventory_code='EIS001062C'

AND serial_number     IN ('TB1-M000996','TB1-M000997','TB1-M000998','TB1-M000999','TB1-M001000','TB1-M001001','TB1-M001007','TB1-M001008');

commit