IBM Support

Unable to Decommission Locations

Troubleshooting


Problem

Receiving an error when changing location status to Decommisioned

Symptom



While changing the status of a location to decommission, get error: Status of location FH1 cannot be changed to inactive because it is referenced by an open work order

Cause

There might be some open work orders, purchase orders, receipts, active assets that reference this location.

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.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Locations","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"6.2.1;6.2.2;6.2.3;6.2.4;6.2.5;6.2.6;6.2.7;7.1;7.1.1;7.5","Edition":"All Editions","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
17 June 2018

UID

swg21515066