I guess you may need to write a SQL code that sets the status of all requests to 'Cancelled' or 'Closed'
It would be something in the lines of:
update kcrt_requests set status_id= (put in the code of the status = Closed or Cancelled) where request_type_id = (select request_type_id from kcrt_request_types where request_type_name='Your_Request_type_name_here'
You'll need to research if any updates should be made to the workflow tables.
Yes, this was my concern. I think there are many other tables that would need updated to reflect a complete closure of the request and associated request workflows. I will test this to see if it works. Thanks
One Kcrt_Requests tables - status_code and status_id.
KWFL_WORKFLOW_INSTANCES tables - STATUS to "CANCELLED"
IN KWFL_WORKFLOW_INSTANCE_STEPS table using this filter WORKFLOW_INSTANCE_ID = () and update ACTIVE FLAG ='N' and CURRENT_STEP_TRANSACTION_ID to cancelled transactinon ID. You can find the cancelled transactinon ID.
Also dont forget to update the UPDATED_DATE wherevere applicable to keep ur audits clear.