How to set a timeout while using Lock_Order in OE_ORDER_PUB
I am using OE_ORDER_PUB in my custom program to update the sales order and below is my flow.
1. Call Get_Order
2. If success then pass values to Lock_Order
3. If success then call Process_Order to update the sales order
But the issue comes when an order is locked by an front end user, the lock_order procedure in the custom program keeps on waiting indefinitely.
I could not find any useful information regarding this Oracle Support.
Any advise is much appreciated.
Thanks,
Viswanathan