Error - : ROI Fails with WMSINB-23840: Lot/Serial Validation Failed. Please Check Log for Details Ref Doc ID 352570.1

Error -: ROI Fails with WMSINB-23840: Lot/Serial Validation Failed. Please Check Log for Details (Doc ID 352570.1)

Applies to:

Oracle Inventory Management - Version 11.5.1 to 11.5.10.CU2 

And [Release 11.5 to 11.5.10]

Information in this document applies to any platform.

EXECUTABLE: RVCTP - Receiving Transaction Processor

The following tables have been populated: 

 RCV_HEADERS_INTERFACE

 RCV_TRANSACTIONS_INTERFACE

 RCV_SERIALS_INTERFACE.

Cause

MTL_SERIAL_NUMBERS_INTERFACE table is not populated in a proper way for Serial Controlled Item.

Solution

If Item is Serial controlled, the following should be used:

INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (

 TRANSACTION_INTERFACE_ID,

 LAST_UPDATE_DATE,

 LAST_UPDATED_BY,

 CREATION_DATE,

 CREATED_BY,

 LAST_UPDATE_LOGIN,

 FM_SERIAL_NUMBER,

 TO_SERIAL_NUMBER,

 PRODUCT_CODE,

 PRODUCT_TRANSACTION_ID) VALUES (

 MTL_MATERIAL_TRANSACTIONS_S.CURRVAL, --only for Items that are both Serial and Lot Controlled

For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide