My Oracle Support Banner

Error 'Lot/Serial validation failed.' Occurs When Inventory transaction worker(INCTCW) is Processing Issue and Receipt Transactions Continuously for the Same Serial Number (Doc ID 2719521.1)

Last updated on OCTOBER 14, 2020

Applies to:

Oracle Inventory Management - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Goal

Problem Statement
When Inventory transaction worker(INCTCW) is processing Issue and Receipt transactions continuously for the same Serial Number, the following error occurs.

Error
Lot/Serial validation failed.  Please check log for details.

Steps to Reproduce

  1. Serial Controlled Item
    On-hand serial number: SN-001

  2. Insert Misc Issue transaction into MTL_TRANSACTIONS_INTERFACE with the following batch id and batch sequence:
    TRANSACTION_BATCH_ID  : 999
    TRANSACTION_BATCH_SEQ : 1
    The corresponding record in MTL_SERIAL_NUMBERS_INTERFACE is with the following serial number:
    FM_SERIAL_NUMBER: SN-001
    TO_SERIAL_NUMBER: SN-001

  3. Insert Misc Receipt transaction into MTL_TRANSACTIONS_INTERFACE with the following batch id and batch sequence:
    TRANSACTION_BATCH_ID  : 999
    TRANSACTION_BATCH_SEQ : 2
    The corresponding record in MTL_SERIAL_NUMBERS_INTERFACE is with the following serial number:
    FM_SERIAL_NUMBER: SN-001
    TO_SERIAL_NUMBER: SN-001

    - The purpose is to issue out the serial number and then receive the same serial number immediately.

    - Above batch id and batch seq are to make sure Inventory transaction worker(INCTCW) will process Misc Issue transaction first and then Misc Receipt transaction.
  4. Run Process transaction interface(INCTCM) which will launch Inventory transaction worker(INCTCW) to process the transactions

 

In 11i, above scenario is supported. As a result, the serial number will be issued out and then received again successfully.

In R12(both 12.1 and 12.2), above scenario is not supported because the Misc Receipt transaction will be stuck with error:  Lot/Serial validation failed.  Please check log for details.
Also the result is still same if using different TRANSACTION_BATCH_ID for those two transactions.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.