Home/ Questions/Q 28590
In Process

Oraask Latest Questions

Question
kenDonald
  • 0
  • 0
Junior
Asked: 2019-02-09T09:42:46+03:00 In:

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

  • 0
  • 0

When trying to  inactivate asset number in define Asset number form,  the following error is appearing ERROR —————- You cannot deactivate an asset for which there are open work requests or service requests or work orders please help me in to discover where is the problem exactly. thanks in advance

assetdeactivate asset numberdeactivate EAM assetwork requestworkorder
Share

    1 Answer

    1. 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 ( 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

       

    Leave an answer

    You must login to add an answer.

    Need An Account,