Unable to Perform Receipt or Return RCV_TP_INVALID_QUANTITY Due to Fractional Quantities Transaction Quantity Cannot Be Zero (Doc ID 1071403.1)

Last updated on JANUARY 12, 2025

Applies to:

Symptoms

When attempting to receive or return specific Purchase Order for a remaining quantity .000002 Metric Ton for specific item, Records are stuck in rcv_transactions_interface in Transaction Status Summary form with error

Steps to Reproduce:

• Navigate to Enter Return form (RCVTXERE) or Enter Receipts form (RCVRCERC)
  
  
• Perform return for the PO for the item for quantity .000002 Metric Ton (or .000008 Each)

There are fractional quantities in mtl_supply due to UOM
conversions because of rounding issues when the primary and  transaction UOM's are different.

• Specific inter class conversions have been defined for the item in mtl_uom_class_conversions 

  INVENTORY_ITEM_ID    67372
  FROM_UNIT_OF_MEASURE    Each
  FROM_UOM_CODE    EA
  FROM_UOM_CLASS    Quantity
  TO_UNIT_OF_MEASURE    Kilogram
  TO_UOM_CODE    KG
  TO_UOM_CLASS    Weight
  CONVERSION_RATE    .00353107
So 1 Metric Ton = 1000 * 0.00353107 each = 3.53107 each

Inventory debug log shows when receiving

[18-FEB-16 05:36:02] po.plsql.RCV_TRANSACTION_PROCESSOR.RCV_TRANSACTION_PROC.171: RVTTHIns(p_rti_id:4435362, p_transaction_type: RECEIVE, p_shipment_header_id: 1362633, p_shipment_line_id: 3779453, p_primary_unit_of_measure: 12/Box, p_primary_quantity: 0, p_source_doc_unit_of_measure: Sheet, p_source_doc_quantity: .000000004, p_parent_id: 0, p_receive_id: 0, p_deliver_id: 0, p_correct_id: 0, p_return_id: 0)
...
[18-FEB-16 05:36:06] INV_TRX_MGR: TrxType=12,OrgCstType=1,mPrjId=0,XfrPrjId=0,SrcPrjId=0,CG=1041,XfrCG=1041
[18-FEB-16 05:36:06] INV_TRX_MGR: mWIPEntityType=0
[18-FEB-16 05:36:06] INV_TRX_MGR: invconv mTrxTypeId= 12
[18-FEB-16 05:36:06] INV_TRX_MGR: TrxQty == zero !!
[18-FEB-16 05:36:07] INV_TRX_MGR: Ex.. in geAttributes:oracle.apps.inv.transaction.utilities.InvTrxException
[18-FEB-16 05:36:07] INV_TRX_MGR: Get Attributes. Rollbacking all changes: oracle.apps.inv.transaction.utilities.InvTrxException
[18-FEB-16 05:36:07] INV_TRX_MGR: error expl :null
[18-FEB-16 05:36:07] INV_TRX_MGR: TrxUtil: stacked message - Transaction quantity cannot be zero
[18-FEB-16 05:36:07] INV_TRX_MGR: error msg :Transaction quantity cannot be zero
[18-FEB-16 05:36:07] INV_TRX_MGR: error msg2 :Transaction quantity cannot be zero
[18-FEB-16 05:36:07] INV_TRX_MGR: Mssg peeked :Transaction quantity cannot be zero
...
[18-FEB-16 05:36:08] INV_LPN_TRX_PUB: retval=1, regmsg=Transaction quantity cannot be zero
[18-FEB-16 05:36:08] INV_LPN_TRX_PUB: calling API to clear the picked quantity
[18-FEB-16 05:36:08] INV_LPN_TRX_PUB: API call to clear picked quantity successful
[18-FEB-16 05:36:08] INV_TXN_MANAGER_PUB: Error from PROCESS_LPN_TRX.. Transaction quantity cannot be zero
[18-FEB-16 05:36:08] po.src.rvtp.rvtii.RVTII.C.1915: RVTII:060 INV TRX Manager Error Msg: Transaction quantity cannot be zero
[18-FEB-16 05:36:08] po.src.rvtp.rvtii.RVTII.C.1915: ORA-01405: fetched column value is NULL

and records are stuck in

RCV_TRANSACTIONS_INTERFACE
Interface_Transaction_Id 4435362
Transaction_Type RECEIVE
Transaction_Status_Code ERROR
Quantity .000000004
Unit_Of_Measure Sheet
Item_Id 66358
Primary_Quantity 0
Primary_Unit_Of_Measure 12/Box
Receipt_Source_Code INVENTORY

there is record in MTL_SUPPLY with small fractional quantities
Supply_Type_Code SHIPMENT
Item_Id 66358
Quantity .000000004
Unit_Of_Measure Sheet
To_Org_Primary_Quantity .000000000333333333333333
To_Org_Primary_Uom 12/Box
Destination_Type_Code INVENTORY
Mrp_Primary_Uom B12

Cause

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