I have cancelled one request and then reopened to move the request to a previous workflow step, previously I defined the reopen step in the workflow but when I click on Cancel Request button and then click on Reopen Request button, the request still appearing in Cancelled status, I checked in database and is displaying the status as IN_PROGRESS so I want to know what could I do?
There is a remote possibility you are seeing a caching issue. Are you running a server cluster? Have you tried clearing caches?
Does the step that you are moving to have a status value set? If not, the status value would retain its previous value, namely 'Cancelled'.
In order to deal with those situations where we wanted to change the active step in a request to one that did not have an established transition, we built a 'move request' request that built and executed the ksc_move_request_workflow special command. It works great and requires no temporary changes to the request types running in production.