The current application as designed will not allow customer to delete the
routing if it is used referencing any WIP Discrete Jobs that are not Closed (status_type=12)
1. In order to delete the routings all the WIP Discrete Jobs that reference the routing have to be closed.
2. The other option is to disable the RTG_CON3 delete constraint and create your own similar to the RTG_CON3 with the addition of the
Thanks for the reply. But, in my case, all the WIP Jobs are in closed status, still we are getting this error 'A discrete job references this routing'.
Could you please suggest any help on that.