Error Rvtptcontrol Failed WMSINB-22192 When Delivering Lot Controlled Item L_RLS_PRIMARY_QUANTITY:0 (Doc ID 1306305.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
Form:RCVRCERC.FMB - Enter Receipts
Form:RCVTXERT.FMB - Enter Receiving Transactions


Symptoms

When attempting to deliver specific internal requisition for lot controlled item
the following error occurs

rvtptcontrol failed

When setting debug per <Note 299497.1> in immediate mode RVCTP completes with error
 
RVTBM-120: Subroutine rvtptcontrol() returned error
Cause:        Subroutine rvtptcontrol() returned an internal error. 
Action:        Note this error number and the actions you are trying to
perform. Contact your system administrator
 
and Inventory debug log file shows

INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: Lot Control Code:2
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: Serial Number Control Code:1
...
VALIDATE_LOT_SERIAL_INFO: l_mtlt_rec.lot_number:840445H
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: l_mtlt_rec.primary_quantity:96
INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: L_RLS_PRIMARY_QUANTITY:0
INV_RCV_INTEGRATION_PVT: Exitting VALIDATE_LOT_SERIAL_INFO - execution error:2011-01-25 02:25:13:WMSINB-22192
INV_RCV_INTEGRATION_PVT: STACKED ERROR MESSAGES :
inv_receiving_transaction: TXN_COMPLETE - Enter txn_complete : 10: 2011-01-25 02:25:13
inv_receiving_transaction: TXN_COMPLETE - Parameters passed : 10.1: p_group_id - 10326905
inv_receiving_transaction: TXN_COMPLETE - Parameters passed : 10.2: p_txn_status - FALSE
inv_receiving_transaction: TXN_COMPLETE - Parameters passed : 10.3: p_txn_mode - PROCESSOR


Trace shows system fails on following query

SELECT SUM(RLS.PRIMARY_QUANTITY)
FROM
RCV_LOTS_SUPPLY RLS , RCV_SHIPMENT_LINES RSL WHERE RSL.SHIPMENT_LINE_ID =
RLS.SHIPMENT_LINE_ID AND RSL.SHIPMENT_HEADER_ID = :B3 AND RSL.ITEM_ID = :B2
AND RLS.SUPPLY_TYPE_CODE = 'SHIPMENT' AND RLS.LOT_NUM = LTRIM(RTRIM(:B1 ))


Steps
The issue can be reproduced at will with the following steps:
Receiving / Receiving Transactions
Deliver internal requisition previously received and inspected

The receiving organization is not WMS enabled, all the transactions have been entered on Core Purchasing forms.

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