RVCTP Errors When Receiving Lot Controlled Items Via API ROI WMSINB-23184 (Doc ID 315649.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 16-Nov-2015***
RVCTP - Receiving Transaction Processor

Symptoms

OPM/PO integration using the PO Receiving Open Interface (ROI) execution fails.
This works for items with non lot controlled attribute but sends validation errors for lot controlled items.

Receiving Interface Errors Report indicates
Lot/Serial validation failed. Please check log for details.
WMSINB-23184:Lot/Serial validation failed.

 

The error message in the RVCTP log file is:
RVCTP module: Receiving Transaction Processor
Concurrent program RVCTP returned error
Cause:        RVCTP encountered an internal error.  Parameters: RVCTP,BATCH,,
Action:        Note both this error number and the actions you are trying to perform. Contact your system adminis
RVTBM-007: Subroutine rvtbm_batch_mngr() returned error
Cause:        Subroutine rvtbm_batch_mngr() returned an internal error. 
Action:        Note this error number and the actions you are trying to perform. Contact your system admini
RVTBM-080: 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
Concurrent Manager encountered an error while attempting to start your immediate concurrent program RVCTP. Routine &ROUTINE received a return code of failure.

 

In PO_INTERFACE_ERRORS table the error message is:
WMSINB-22161:Lot/Serial validation failed. Please check log for details.
or
WMSINB-23184:Lot/Serial validation failed.

 

After setting debug profile options per <Note:299497.1>
The inventory debug file shows the following errors
[04-MAY-09 18:12:59] INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: MTL_SYSTEM_ITEMS query done :WMSINB-22021
[04-MAY-09 18:12:59] INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: Lot Control Code:2
[04-MAY-09 18:12:59] INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: Serial Number Control Code:1
[04-MAY-09 18:12:59] INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: Lot Status Enabled:N
[04-MAY-09 18:12:59] INV_RCV_INTEGRATION_PVT: VALIDATE_LOT_SERIAL_INFO: Lot Controlled :WMSINB-22076
[04-MAY-09 18:12:59] INV_RCV_INTEGRATION_PVT: Exitting VALIDATE_LOT_SERIAL_INFO - execution error:2009-05-04 06:04:59:WMSINB-23184
[04-MAY-09 18:12:59] INV_RCV_INTEGRATION_PVT: STACKED ERROR MESSAGES : Lot/Serial validation failed.  Please check log for details.

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