My Oracle Support Banner

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

Last updated on JANUARY 30, 2022

Applies to:

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

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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