Two methods to use so that ILL Staff can delete a request that was canceled in VDX but not automatically canceled in Horizon. These processes remove the ILL Request # so that ILL staff can then go in and cancel the request in Horizon.
In SQL - change the number at the end to the specific ILL request number
update request
set ill_request# = null
where request# = 23686911
In Horizon
Administration
Table Editor
Request_edit - all pending requests will display
File
Compound search...
Use Index - ILL Request
Search for the request number provided by ILL
click on edit
delete the number from the Ill Request Field
Save
Close
Let ILL staff know they can cancel the request from the patrons Horizon record.