ROI: RVCTP for Lot/Serial Controlled Items Errors RVTII-060 RCV_SPLIT_LOT_SERIAL_ERROR WMSINB-20941 ORA-01403: no data found in Package INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control (Doc ID 337941.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.
EXECUTABLE:RVCTP - Receiving Transaction Processor

Symptoms

While trying to import receipts after loading the tables RCV_HEADERS_INTERFACE, RCV_TRANSACTIONS_INTERFACE and MTL_TRANSACTION_LOTS_INTERFACE the Receiving Transaction Processor completes with error:

Concurrent program RVCTP returned error
Cause: RVCTP encountered an internal error. Parameters: RVCTP,BATCH,2050,
Action: Note both this error number and the actions you are trying to perform. Contact your system administ
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.


The problem only occurs for lot controlled items.

Debugging further following instructions of <Note 299497.1> shows for lot & serial item the receipt processing is failing with the following errors
[13-OCT-05 11:21:44] INV_RCV_INTEGRATION_PVT: SPLIT_LOT_SERIAL:l_lot_ser_qty:0
[13-OCT-05 11:21:44] INV_RCV_INTEGRATION_PVT: split_lot_serial:075.7: Lot Serial Quantity Mismatch
[13-OCT-05 11:21:44] INV_RCV_INTEGRATION_PVT: split_lot_serial:075.8: total_lot_qty : 97
[13-OCT-05 11:21:44] INV_RCV_INTEGRATION_PVT: split_lot_serial:075.9: lot_ser_qty : 0
[13-OCT-05 11:21:44] INV_RCV_INTEGRATION_PVT: SPLIT_LOT_SERIAL - Execution
Error::WMSINB-20941:2005-10-13 11:13:44
[13-OCT-05 11:21:44] INV_RCV_INTEGRATION_PVT: STACKED ERROR MESSAGES :
[13-OCT-05 11:21:44] INV_RCV_INTEGRATION_PUB: inv_rcv_intergration_pvt.split_lot_serial returned error
[13-OCT-05 11:21:44] RCV_ROI_TRANSACTION 8251: After split_lot_serial Api
[13-OCT-05 11:21:44] RCV_ROI_TRANSACTION 8258: split_lot_serial Api has errors
[13-OCT-05 11:21:44] RCV_ROI_TRANSACTION 8263: return value: false
[13-OCT-05 11:21:44] RCV_ROI_TRANSACTION 8266: x_return_status: E
[13-OCT-05 11:21:44] RCV_ROI_TRANSACTION 8267: x_msg_count: 
[13-OCT-05 11:21:44] RCV_ROI_TRANSACTION 8268: x_msg_data: WMSINB-20941
...
[13-OCT-05 11:21:44] RCV_ERROR_PKG begin: v-------Procedure Started----------v
[13-OCT-05 11:21:44] RCV_ERROR_PKG 180: set error message token =

RCV_SPLIT_LOT_SERIAL_ERROR

In Release 12.1.3 inventory debug log shows

[06-MAR-15 15:07:55] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.130 $): SPLIT_LOT_SERIAL:l_lot_ser_qty:0
[06-MAR-15 15:07:55] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.130 $): split_lot_serial:075.7: Lot Serial Quantity Mismatch
[06-MAR-15 15:07:55] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.130 $): split_lot_serial:075.8: total_lot_qty : 200
[06-MAR-15 15:07:55] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.130 $): split_lot_serial:075.9: lot_ser_qty : 0
[06-MAR-15 15:07:55] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.130 $): SPLIT_LOT_SERIAL - Execution Error::WMSINB-20941:2015-03-06 03:06:55
[06-MAR-15 15:07:55] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.130 $): STACKED ERROR MESSAGES : |ORA-01403: no data found in Package INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control|ORA-01403: no data found in Package INV_MATERIAL_STATUS_GRP Procedure get_lot_serial_status_control
[06-MAR-15 15:07:55] INV_RCV_INTEGRATION_APIS($Revision: 120.12.12010000.10 $): inv_rcv_intergration_pvt.split_lot_serial returned error
[06-MAR-15 15:07:55] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.10175:       After split_lot_serial Api


Steps:
a. Populate ROI interface tables rcv_header_interface (RHI), rcv_transactions_interface (RTI)  
and mtl_transaction_lots_interface (MTLI)  
b. Run Receiving Transaction Processor.
c. See error

In RCV_TRANSACTIONS_INTERFACE table row is stuck with
INTERFACE_TRANSACTION_ID=5055
PROCESSING_STATUS_CODE=ERROR
TRANSACTION_TYPE=RECEIVE
AUTO_TRANSACT_CODE=DELIVER
QUANTITY=97
ITEM_ID=3468
USE_MTL_LOT=2
USE_MTL_SERIAL=1
TO_ORGANIZATION_ID=477

In MTL_TRANSACTION_LOTS_INTERFACE table
LOT_NUMBER=CONV : 5055
TRANSACTION_QUANTITY=97
PRIMARY_QUANTITY=97
SERIAL_TRANSACTION_TEMP_ID=5055
PRODUCT_CODE=RCV      
PRODUCT_TRANSACTION_ID=5055 

In PO_INTERFACE_ERRORS table there is a record

INTERFACE_TYPE =RCV-856
COLUMN_NAME = INTERFACE_TRANSACTION_ID
ERROR_MESSAGE = An error occurred while trying to split lot and serial lines.
ERROR_MESSAGE_NAME=RCV_SPLIT_LOT_SERIAL_ERROR 

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