ROI Returns to Vendor Transactions Fail With 'Primary quantity (n) exceeds available subinventory quantity (n)' Error on WMS Org (Doc ID 2178286.1)

Last updated on AUGUST 11, 2020

Applies to:

Symptoms

In WMS organizations, returns via ROI fails with 'Primary quantity (n) exceeds available subinventory quantity (n)' even when there is enough onhand in the return subinventory.

Steps to reproduce:

1. Create a PO with ship to org as any WMS org + use standard routing.
2. Receive into an LPN via mobile to receiving subinventory: RS1 + receiving locator : RL1
3. Putaway the LPN to sub: S1, L1.
4. Load ROI Tables to perform return to vendor transaction
5. Make sure there is no onhand in receiving subinv: RS1 & receiving locator: RL1
6. Make sure there is sufficient onhand in the return subinv/locator/lpn selected for in the return RCV_TRANSACTIONS_INTERFACE
7. Run RTP to process the roi return

Receiving Transaction Processor fails with error below (as code looks for onhand from RS1/RL1)

      Error: Primary quantity (n) exceeds available subinventory quantity (n)
      Cause: The transaction quantity (n) in primary unit of measure exceeds the available quantity (n) in the subinventory.
      Action: Enter a smaller quantity. 

The details of the error in table PO_INTERFACE_ERRORS are:

      Column name = PRIMARY_QUANTITY
      Error name = RCV_TRX_QTY_EXCEEDS_INV_AVAIL
      Table name = RCV_TRANSACTIONS_INTERFACE

Cause

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