My Oracle Support Banner

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
Quantity_Received -100
it is negative
Quantity_Shipped 100
Quantity_Received -100
Shipment_Line_Status_Code PARTIALLY RECEIVED
Source_Document_Code PO
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.