Last updated on JULY 11, 2017

Applies to:

Symptoms

Find it is not possible to correct one receipt of Amount based PO due to data corruption  
of one correction line not generated for receipt 102 / there are duplicate correct to expense records / quantity received is negative.

Sqls scripts from <Note 1383212.1>  iProcurement Receiving Correction Partially Fails Intermittently Resulting in Different Quantity / Amount in iProcurement vs Core Apps Receiving do NOT return the PO/Receipt


Steps
The issue can be reproduced at will with the following steps:

In iProcurement
1)  Amount Based PO  1111  show delivered amount as 19777

2) Receiving Tab / Correct Receipts
For Order Number 1111, see 2 receipts
Receipt 777  has Received Amount = 22300
Receipt 888  has Received Amount = -2530

3) Receipt Details 888
Transaction History
Net Quantity Received  = -2530
Original Receipt Quantity   = 2530

Transactions are
Transaction         Quantity   Unit
Receive Items      2530     AUD
Correct Receipt    -2530     AUD
Correct Receipt    -2530     AUD

4) Correct Receipts: Select Receipts form
Try to correct Receipt 888  with Received Amount = -2530

Enter Positive quantity 2530
get

In Core Purchasing Responsibility
5)  Receipt Transaction Summary page shows for Receipt 888
Transaction Type  Amount   Destination
Receive               2530       Receive
 Deliver               2530       Expense
        Correct       - 2530     Expense
        Correct       - 2530     Expense
 Correct              - 2530     Receiving  

6) In fact there is missing positive correction on Deliver Record with Expense destination but  it is NOT possible to ONLY perform a
positive CORRECTION on DELIVER for 2530 quantity as There is no way in iprocurement to only do it and  it cannot be done via core purchasing form per Note 399153.1
as  this is Amount PO the RCVTXECO form does not return any record to correct on Core Purchasing form 

In Core Purchasing responsibility
Corrections form          
Search for PO 89005030
Get APP-PO-14094
--Normal - Amount based PO so it is not possible to create one new line with correct to Receiving

7) Examination of the RCV11i output (Note 402245.1) shows the following:

PO_LINE_LOCATIONS_ALL
Line_Location_Id 11992946
Po_Header_Id 10011405
Amount 22300
Amount_Received 22300
Value_Basis FIXED PRICE
Matching_Basis AMOUNT

PO_DISTRIBUTIONS_ALL
Po_Distribution_Id 12279306
Po_Header_Id 10011405
Line_Location_Id 11992946
Destination_Type_Code EXPENSE
Amount_Ordered 22300
Amount_Delivered 19770

In RCV_TRANSACTIONS table the following transactions can be seen
Transaction_Id Transaction_Type Destination_Type_Code User_Entered_Flag Parent_Transaction_Id Amount
7560302    RECEIVE       RECEIVING     Y        -1              2530
7560303    DELIVER       EXPENSE        N         7560302    2530
10359144  CORRECT     EXPENSE        Y         7560303   -2530      
10359145  CORRECT     RECEIVING     Y         7560302   -2530
10360213  CORRECT     EXPENSE        Y         7560303   -2530

Cause