Unable to Decommission Locations

Resolving The Problem

Need to close all the open work orders, purchase orders and ensure that there is no active asset before decommissioning location.

1. Error: Status of location FH1 cannot be changed to inactive because it is referenced by an open work order

Try to change the status to CLOSE for parent and task work orders via the front end.

Run update statements via the backend to change the status to CLOSE
and historyflag to 1 for those problem records.

Queries to identify open records (replace FH1 with the problem location):

SELECT wonum,istask,historyflag,status FROM WORKORDER
WHERE
(WOCLASS = 'WORKORDER' or WOCLASS = 'ACTIVITY')
AND HISTORYFLAG = 0 AND LOCATION = 'FH1';


SELECT wonum,istask,historyflag,status FROM WOACTIVITY
WHERE
(WOCLASS = 'WORKORDER' or WOCLASS = 'ACTIVITY')
AND HISTORYFLAG = 0 AND LOCATION = 'FH1';


select * from wostatus where PARENT IN ('XXX')
-- where XXX is the open work order from the first query above.

2. Error: Status of location FH1 cannot be changed to inactive because it is referenced by an open PO

Go to the advanced search in the PO application, enter the problem location in the location field. Click the Find button. Change the status of the PO to CLOSE.

If error comes up about unapproved receipts exist, then go to the receiving application. Bring up the PO, go to the Select Actions menu, Change Inspection Status, select the POLINE, click OK. Then go back to the PO and this time you should be able to close the PO.

3. Error: Status of location FH1 cannot be changed to inactive because it is referenced by an Active Asset.

There should not be an active Asset in an inactive Location.