The Lot Number Which Is Not Received Is Saved in MTL_LOT_NUMBERS Table (Doc ID 2210992.1)

Last updated on DECEMBER 12, 2016

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior
The Lot Number Which Is Not Received Is Saved in MTL_LOT_NUMBERS Table

Expected Behavior
The Lot Number Which Is Not Received Should Not Be Saved in MTL_LOT_NUMBERS Table

Steps to Reproduce

When receiving lot controlled item by Miscellaneous receipt, PO Receipt, etc:

  1. Lot Entry form is shown
  2. Enter Lot-1 with Quantity
  3. Enter Lot-2 with Quantity
  4. Change Lot-1 to Lot-11
  5. Change Lot-2 to Lot-22
  6. Click Done button and save the transaction

As a result, all the four lot numbers: Lot-1, Lot-2, Lot-11, Lot-22 are saved/committed into MTL_LOT_NUMBERS Table.
Lot-1 and Lot-2 should not be saved.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms