Duplicated Rows Into Transact Move Order When Choose Quantity From Different Locator (Doc ID 1540468.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Material Move Orders

ACTUAL BEHAVIOR
---------------
Into form 'Transact Move Order' (INVTOTRX.fmb), the following issue is reproducible at will:
when user change allocation for line using button 'Select Available Inventory' (INVPCKLT.fmb) and choose quantity from different locator then suggested and choose 'Done', System go back to Transact Move Order Line Allocations and create new line but in detail 'Lot/Serial' was created duplicated records for lot number. The quantity in lot exceed quantity from line allocation.
You can see that issue is related with mtl_lot_numbers. When only exists one record for one lot number, problem does not occur, but if the same lot exists in different organization or exists the same lot for different item then system create duplicated records as many as are records in table mtl_lot_numbers for lot number.

EXPECTED BEHAVIOR
-----------------------
Change of allocation should not created duplicated row for lot number.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Go into Transact Move Order Form
  2. Change allocation for line using button "Select Available Inventory"
  3. Choose quantity from different locator then suggested and choose 'Done'
  4. System go back to Transact Move Order Line Allocations and create new line but in detail 'Lot/Serial' was created duplicated records for lot number. The quantity in lot exceed quantity from line allocation.

 

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