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

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms