Error Work Order Number Invalid
Hi Experts,
When I do completion, this error appear in P31113 menu after I clicked the OK button.
This case have been happened before and the result of our investigation is it's because of F4108.iodoc1 is not equal to F4108.iolotn. The solution is update direct using sql query as below.
-- select query select iolotn, iodoc1, to_number(iolotn) from proddta.f4108 where iolotn in ('535011', '535012', '535013') -- iodoc1 before -- 631752 -- 631753 -- 631754 -- update query update proddta.f4108 set iodoc1 = to_number(iolotn) where iolotn in ('535011', '535012', '535013')
But this case, when I run sql query the F4108.iodoc1 is already equal to F4108.iolotn.