After Upgrade To R12 System Accepts Duplicate Corrections While Opening 2 Sessions Simultaneously / Negative Quantity Received (Doc ID 1663943.1)

Last updated on JUNE 01, 2016

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.

Symptoms

Find system accepts duplicate corrections while opening 2 sessions simultaneously.
 
Steps
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
In PO_LINE_LOCATIONS_ALL
Quantity_Received -100
it is negative
 
In RCV_SHIPMENT_LINES
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

RCV_TRANSACTIONS
There are 2 CORRECT transactions with same RECEIVE Parent_Transaction_Id

Note: Same issue may occur for duplicate RETURN to VENDOR transactions.

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