WIP Move Transaction Quantity Is Over Than Quantity Available to Transact if Using Multiple Session
(Doc ID 2220002.1)
Last updated on FEBRUARY 03, 2019
Oracle Work in Process - Version 12.1.3 and later Information in this document applies to any platform.
ACTUAL BEHAVIOR: If doing move transaction by two sessions at the same time (full soon), WIP Move transaction quantity is over than quantity available to transact
When "Operator A" opened move transaction form trying to transact Qty of 6 to To move, the transaction was performed at 27/06/2016 8:50:52 PM. Meanwhile "Operator B" opened the move transaction form at 27/06/2016 8:47:34 PM, tried transact Qty of 2 to To move, the transaction was performed at 27/06/2016 8:48:35 PM. Question is why the first transaction didn’t error at 8:50PM, then after the transaction created, the job operation quantity is wrong, it should show -2 at Queue, 8 at To move.
EXPECTED BEHAVIOR: If doing move transaction by two sessions at the same time (full soon), WIP Move transaction quantity will not be over than quantity available to transact
STEPS: The issue can be reproduced at will with the following steps: 1. Create a JOB Operations Seq:10 IN Queue :10
2. First session Do Move Transaction From Seq:10 Queue -> To 10 To move Available :10 Quantity:10
3.Second session Do Move Transaction From Seq:10 Queue -> To 10 To move Available :10 Quantity:4
4. Saved transaction for second session
5. Saved for first session.
6. Two move transactions created - View Move Transactions Step Seq To Ope Step Quantity Queue 10 To move 4 Queue 10 To move 10
7. But quantity on Operation 10 is not correct. JOB: A Operations Seq:10 IN Queue :10 To Move : 4
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!