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

03:37 0 Comments A+ a-


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.comOr Subscribe your email-id on OracleAppsGuide