ROI Errors RCV_TRX_QTY_EXCEEDS_AVAILABLE For Return 'qty from GET_AVAILABLE_QUANTITY for return is 0' (Doc ID 1401286.1)

Last updated on OCTOBER 16, 2024

Applies to:

Symptoms

When attempting to process a return via Receiving Open Interface
the following error occurs

 
Steps

1. Record in RCV_TRANSACTIONS_INTERFACE table has

Interface_Transaction_Id 1405019
Transaction_Type RETURN TO VENDOR
Processing_Mode_Code BATCH
Transaction_Status_Code PENDING
Quantity 1
Uom_Code EA
Shipment_Header_Id 687934
Shipment_Line_Id 657218
Receipt_Source_Code VENDOR
Parent_Transaction_Id 693065
Po_Header_Id 32583
Po_Line_Id 72591
Po_Line_Location_Id 72720
Po_Distribution_Id 71347

2. Run RVCTP

3. It completes in error
In PO_INTERFACE_ERRORS see records including
Interface_Type RCV-856
Error_Message The Quantity entered for receipt is greater than the available Quantity. The sum of quantity to be received and already received, 1, is greater than the sum of ordered quantity and over receipt tolerance, 0.
Error_Message_Name RCV_TRX_QTY_EXCEEDS_AVAILABLE
Table_Name RCV_TRANSACTIONS_INTERFACE
Batch_Id 42839
Interface_Line_Id 1405019

4. When setting debug profile options per Note 299497.1 RVCTP log file shows the following

What has been checked
. There is available quantity to be returned:
In po_line_locations_table the quantity_received is 1, Receiving_Routing_Id 3 direct delivery,
In po_distributions_all quantity_delivered is 1.
. In rcv_transactions table Receive and Deliver transactions have not been corrected
. Parent_Transaction_Id 693065 is the id of the DELIVER transaction as the routing is direct delivery
. There are no other records stuck in RTI with Parent_Transaction_Id = 693065
. Rollup Patch 23 has been applied to so have latest version of RCV_ROI_RETURN package RCVPRERB.pls

Changes

Cause

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