Duplicate Correct To Expense Transactions / Missing Correct To Receiving / Corruption / Cannot Correct in iProcurement : Quantity entered should be zero or more.
(Doc ID 1675416.1)
Last updated on FEBRUARY 18, 2019
Applies to:
Oracle Inventory Management - Version 12.1.3 and laterOracle iProcurement - Version 12.1.3 and later
Information in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |