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 JANUARY 14, 2021
Applies to:Oracle Inventory Management - Version 126.96.36.199 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
Executable:RVCTP - Receiving Transaction Processor
When attempting to process a return via Receiving Open Interface
the following error occurs
1. Record in RCV_TRANSACTIONS_INTERFACE table has
Transaction_Type RETURN TO VENDOR
2. Run RVCTP
3. It completes in error
In PO_INTERFACE_ERRORS see records including
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.
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
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