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 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
    • 0