ROI Fails for Unavailable Quantity Reason when Performing a Return To Vendor Even if Quantity is Available (Doc ID 1494734.1)

Last updated on SEPTEMBER 06, 2021

Applies to:

Symptoms

When attempting to import Return to Vendor transactions using the Receiving Open Interface, even if the Returned quantity is available,the following occurs

 
The same transaction completes when using the Returns form

Steps:
1. Create and Receive a Purchase Order
2. Try to return the same using the ROI
3. The error above is raised by the Receiving Transaction Processor
4. In po_interface_errors see
INTERFACE_TYPE RCV-856
COLUMN_NAME QUANTITY
ERROR_MESSAGE Error: 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

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.