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
0 comments:
Post a Comment
Note: only a member of this blog may post a comment.