After Upgrade To R12 System Accepts Duplicate Corrections While Opening 2 Sessions Simultaneously / Negative Quantity Received
(Doc ID 1663943.1)
Last updated on MARCH 07, 2019
Applies to:Oracle Inventory Management - Version 12.0.0 to 12.2.4 [Release 12.0 to 12.2]
Information in this document applies to any platform.
Find system accepts duplicate corrections while opening 2 sessions simultaneously.
The issue can be reproduced at will with the following steps:
1) Create a Purchase Order for quantity 100 and approve it
2) Receive the PO for quantity 100 in Receipt form
3) Navigate to Receiving / Receiving Corrections RCVTXECO form
Open the correction form in two instances and query out the PO:
Open the Correction form against purchase from one session, select the transaction to be corrected
Open the same correction transaction from the other pc or two sessions on the same PC and select the transaction to be corrected
Do negative correction of -100 against the the receiving transaction in two instance concurrently;
4) Press save from the 2 sessions on the same time
The two correction transaction can be processed successfully
5) Receipt Transaction Summary form shows
Transaction Type Amount Unit
Receive 100 Each
Correct -100 Each
Correct -100 Each
6) Output of Receiving data Collection Script shows
it is negative
Shipment_Line_Status_Code PARTIALLY RECEIVED
So there is negative quantity received in RSL / PARTIALLY RECEIVED status
There are 2 CORRECT transactions with same RECEIVE Parent_Transaction_Id
Note: Same issue may occur for duplicate RETURN to VENDOR transactions.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document