We have the following situation.
An item is created with a generic routing (Rev 001) commoned from another item.
An unreleased standard discrete job is created for that item which gets the common_routing_sequence_id of the generic routing.
A new specific routing is created for the item - also Rev 001 since it's the first specific routing for this item.
So the routing for the item now has a different common_routing_sequence_id and we want to update the unreleased WIP job use the new routing. Is there any way to do it? I've tried selecting from the front-end but since 001 is the only revision, there is nothing to change. I've also tried loading via wip_job_schedule_interface with a revison of 001 and a revision date of current day. That doesn't seem to change the common_routing_sequence_id on the job. Any suggestions or solutions?
Version 12.2.7