Home/ deepika/Answers
  1. Asked: February 9, 2019In:

    Error: You cannot deactivate an asset for which there are open work requests or service requests or work orders

    deepika
    deepika Explorer
    This answer was edited.

    Check for any open work orders/work requests for the asset number. If open work orders/work requests exists update work order status to close/complete/cancel. Below are the queries to check open work orders/work requests -- Check for open Work Orders SELECT COUNT (1) FROM eam_work_orders_v WHERE ( wRead more

    Check for any open work orders/work requests for the asset number. If open work orders/work requests exists update work order status to close/complete/cancel. Below are the queries to check open work orders/work requests

    -- Check for open Work Orders
SELECT COUNT (1) FROM eam_work_orders_v
WHERE ( work_order_status NOT LIKE (‘%Cancelled%’)
AND work_order_status NOT LIKE (‘%Complete%’)
AND work_order_status NOT LIKE (‘%Close%’)
)
AND instance_number = asset_num

     

    -- Check for open Work Requests

SELECT COUNT (1)
FROM wip_eam_work_requests_v
WHERE ( work_request_status NOT LIKE (‘%Cancelled%’)
AND work_request_status NOT LIKE (‘%Complete%’)
AND work_request_status NOT LIKE (‘%Rejected%’)
)
AND asset_number = asset_num

     

    See less