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 JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10.2 to 12.1.1 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

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

ERROR: RCV_TP_INVALID_QUANTITY
RVTII-060: Subroutine INV_TXN_MANAGER_PUB.process_Transactions() returned error Cause: Subroutine INV_TXN_MANAGER_PUB.process_Transactions() returned an internal error. Action: Note this error number and the actions you a



Steps to Reproduce:

There are fractional quantities in mtl_supply due to UOM
conversions because of rounding issues when the primary and  transaction UOM's are different.
  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

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