Hi everyone,
We have an order locked in a posted batch. All other orders have a mir_lock value of 0. I see this knowledgebase article suggesting that one run TP_UTL_UNLOCK_ORDERS_FOR_BATCH if ALL orders in a posted batch are locked. But ... I'm wondering, since it's just one, can I simply:
update T_ORDER
set mir_lock = 0
where order_no = <order_no>??
thank you!!!!!
frannie
Hey Frannie!
While I can't speak to having ever needed to unlock an entire batch, I did find myself needing to unlock a single order this afternoon. I stumbled upon this post in my searching and decided to give it a go. While your mileage may vary, it worked like a charm in my world!
Thank you for sharing!
Brian Jones
Brian - glad to hear it! I think I ended up using it as well... and nothing has blown up in my face, so.. maybe it's the charm.
This worked out great for me, thanks for posting!
Worked for me
Me too, just what I was looking for. Thanks.
Easy fix, thanks!
Worked for me too. Thank you!