Now you can Subscribe using RSS

Submit your Email

Thursday, 11 June 2015

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

KULDEEP CHAUHAN



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

KULDEEP CHAUHAN / Author & Editor

"A Guide for Oracle E-business Suit" . For any Query and help Please drop your mail on - Oracleappsguide.com@gmail.com . Thanks a lot for your visit on OracleAppsGuide.com .Please Subscribe and Comment our website feed and Youtube channel.

0 comments:

Post a comment

OracleAppsGuide.com © Coprights 2016,