Manufacturing - JDE1 (MOSC)

MOSC Banner

Error Work Order Number Invalid

edited Jan 6, 2022 2:21AM in Manufacturing - JDE1 (MOSC) 1 commentQuestion

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center