ProblemThis problem occurs when a user wants to update the “Next number” formatting field at a specific site in APM. In this case, we have considered an example of updating the “Next number” formatting field for Work Order.Solution
Running the below query updates the Document Numbering for work orders to start at a bigger number,
select * from oq.NEXTOBJwhere classid = 1000002844select SITENAME, SITEOI, WOUKEYPARAM_FORMATTOUSE, WOUKEYPARAM_NEXTNUMBER from fnd.SITEwhere SITEOI = 22update fnd.SITE set WOUKEYPARAM_NEXTNUMBER = 5004, VERS = VERS + 1 where SITEOI = 22
See AlsoSR 7001016516