RTP is Failing for Lot Controlled Items After Receipt in Mobile and Inspection in Forms

(Doc ID 1069365.1)

Last updated on MARCH 27, 2016

Applies to:

Oracle Quality - Version 12.1.2 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

A receipt for lot controlled item is performed through Oracle Mobile.
The inspection transaction then is performed through the desktop and it is erroring  out with following error:
The same flow was working fine in 12.0.6 but in 12.1.1 is failing


ERROR
======
rvtptcontrol failed


Log file shows the following:
-----------------------------------------
[05-FEB-10 14:53:27] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.19 $): VALIDATE_LOT_SERIAL_INFO: Lot Controlled :WMSINB-22076
[05-FEB-10 14:53:27] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.19 $): Exitting VALIDATE_LOT_SERIAL_INFO - execution error:2010-02-05 02:05:27:WMSINB-23188
[05-FEB-10 14:53:27] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.19 $): STACKED ERROR MESSAGES :
[05-FEB-10 14:53:27] INV_RCV_INTEGRATION_APIS($Revision: 120.12.12010000.2 $): validate_lot_serial_info: private API new debug
[05-FEB-10 14:53:27] inv_receiving_transaction: TXN_COMPLETE - Enter txn_complete : 10: 2010-02-05 02:05:27
[05-FEB-10 14:53:27] inv_receiving_transaction: TXN_COMPLETE - Parameters passed : 10.1: p_group_id - 4342
[05-FEB-10 14:53:27] inv_receiving_transaction: TXN_COMPLETE - Parameters passed : 10.2: p_txn_status - FALSE
[05-FEB-10 14:53:27] inv_receiving_transaction: TXN_COMPLETE - Parameters passed : 10.3: p_txn_mode - ONLINE
[05-FEB-10 14:53:27] inv_receiving_transaction: TXN_COMPLETE - Release Level is J or Above
[05-FEB-10 14:53:27] inv_receiving_transaction: TXN_COMPLETE - PROCESSING MODE:ONLINE
[05-FEB-10 14:53:27] inv_receiving_transaction: TXN_COMPLETE - Txn Failed for Online mode. Rolling back all work by tm
[05-FEB-10 14:53:27] inv_receiving_transaction: Number of MOL updated: 0
[05-FEB-10 14:53:27] inv_receiving_transaction: TXN_COMPLETE - Deleting mtli, msni, mtlt, msnt, wlpni for interface id:116046
[05-FEB-10 14:53:27] inv_receiving_transaction: Delete records from WLPN with context 6, operation_mode of -99999 and group_id

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