WIP Move Transaction Quantity Is Over Than Quantity Available to Transact if Using Multiple Session

(Doc ID 2220002.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms