Unable To Return To Supplier RCVTXERE APP-PO-14888: Primary Quantity XXX Exceeds Subinventory Quantity 0 (Doc ID 1526276.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 26-Aug-2014***

Symptoms

When attempting to return specific Purchase Order PO 925
the following error occurs.


Steps
The issue can be reproduced at will with the following steps:

1) Navigate to Receiving returns form RCVTXERE in org KFI
 
2) Search for Receipt 833 / Item 117093
  See one record quantity 540 Bottle
  Destination --RET-R.00.00.000
 
3) Enter Reason... Save
  Get the error message
  APP-PO-14888: Primary quantity 540 exceeds available
  subinventory quantity 0
 
As soon as clicking on Lot-Serial Button ERROR pops up.
It doesn't even allow to enter Lot-Serial.

What has been checked
Following instructions of <Note 414640.1>  it has been confirmed
 
1) There is enough on hand quantity available for the item on the subinventory / locator_id / organization_id  where the initial deliver
transaction has been performed.  
Receipt Transaction Summary form shows for PO 925
deliver transaction has Quantity 540
Destination --RET-R.00.00.000

Material Workbench form shows
On hand / RET / R.00.00.000
On Locator R.00.00.000 for Item 117093 On-hand = 540
 
2) Rcv11i output from <Note 402245.1> shows

The following transactions occurred for the receipt

TRANSACTION_ID    TRANSACTION_TYPE    QUANTITY    UNIT_OF_MEASURE    SHIPMENT_HEADER_ID    PARENT_TRANSACTION_ID    PO_HEADER_ID    ORGANIZATION_ID    SUBINVENTORY    LOCATOR_ID    LPN_ID    TRANSFER_LPN_ID    MOBILE_TXN
22217873    RECEIVE    540    Bottle    4704105    -1    432326    108                170383    Y
22220432    REJECT    540    Bottle    4704105    22217873    432326    108            170383    222406    Y
22324434    DELIVER    540    Bottle    4704105    22220432    432326    108    RET    180393    222406    222406    Y


In rcv_transactions table Deliver transaction has
  TRANSACTION_ID 22324434 <--
  TRANSACTION_TYPE DELIVER
  QUANTITY 540
  UNIT_OF_MEASURE Bottle
  PARENT_TRANSACTION_ID 22220432
  SOURCE_DOCUMENT_CODE PO
  DESTINATION_TYPE_CODE INVENTORY
  PO_HEADER_ID 432326
  ORGANIZATION_ID 108
  SUBINVENTORY RET
  LOCATOR_ID 180393
  LPN_ID    222406
  MOBILE_TXN Y
 
Parent Reject TRANSACTION_ID 22220432 has LPN_ID    170383

In mtl_transaction_lot_numbers
  TRANSACTION_ID 112016099
  INVENTORY_ITEM_ID 145669
  ORGANIZATION_ID 108
  TRANSACTION_SOURCE_ID 432326
  TRANSACTION_QUANTITY 540
  LOT_NUMBER 11F06
  PRODUCT_CODE RCV
  PRODUCT_TRANSACTION_ID 22324434 <--
 
The SQL>
  Select concatenated_segments from mtl_item_locations_kfv
  where organization_id=108  and inventory_location_id = 180393;
returns Locator name R.00.00.000
 
3) The following scripts have been run for ORGANIZATION_ID 108 and ITEM_ID 145669
Pending transactions:
  Select * from mtl_material_transactions_temp
  where organization_id=&org_id
  and inventory_item_id=&item_id;
  -No records
 
Reservations:
  Select * from mtl_reservations
  where organization_id=&org_id
  and inventory_item_id=&item_id;
  -No records
 
select * from MTL_TRANSACTION_LOTS_TEMP
  where lot_number like '11F06';
  -No records
 
Onhand Quantities details:
  Select * from mtl_onhand_quantities_detail
  where organization_id=&org_id
  and inventory_item_id=&item_id
  Last record has
  INVENTORY_ITEM_ID 145669
  ORGANIZATION_ID 108
  DATE_RECEIVED 01/15/2012 13:31:42
  SUBINVENTORY_CODE RET
  LOCATOR_ID 180393
  LOT_NUMBER 11F06
  TRANSACTION_UOM_CODE BT
  TRANSACTION_QUANTITY 540
  IS_CONSIGNED 2
  LPN_ID 222406
 
  so there is on hand quantity.

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