14
We should prevent an user to submit Firm and consolidate process for same plan batch orders that have been already submitted for processing by another user.
Scenario is as follows:
- User A is selecting several planned batch orders for an item and is submitting the Firm and consolidate process.
- While the first process is still not yet completed (due to complexity of formula/route data), User B is selecting same planned batch order and is submitting Firm and consolidate process again.
- After some time, User B is receiving an error pointing to a deadlock that occurred on ReqPO table.
- After some more time, the process gets completed with success for User A.
- However, due to underlying deadlock issues, both processes are being delayed, leading to a performance problem.
Expectation is that the second user should be prevent to submit Firm and consolidate process for same planned batch orders that are being in process.
Scenario is as follows:
- User A is selecting several planned batch orders for an item and is submitting the Firm and consolidate process.
- While the first process is still not yet completed (due to complexity of formula/route data), User B is selecting same planned batch order and is submitting Firm and consolidate process again.
- After some time, User B is receiving an error pointing to a deadlock that occurred on ReqPO table.
- After some more time, the process gets completed with success for User A.
- However, due to underlying deadlock issues, both processes are being delayed, leading to a performance problem.
Expectation is that the second user should be prevent to submit Firm and consolidate process for same planned batch orders that are being in process.
STATUS DETAILS
Needs Votes