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!