My Oracle Support Banner

System Overwrites The Field Of The Loader With The Name Of The Dropper. (Doc ID 2243996.1)

Last updated on JANUARY 20, 2021

Applies to:

Oracle Warehouse Management - Version 12.2.4 and later
Information in this document applies to any platform.


On :  12.2.4 version, Labor Mangement

Find that the system overwrites the 'Created by' field of the loader with the user_id of the dropper.  

After releasing a sales order, there is one person who performs the pick load through WMS.

While doing pick load, the data gets inserted in MTL_MATERIAL_TRANSACTIONS_temp table.
In this temp table the created_by column is the user id of the person who is doing pick load.

There is then another person whodoes the drop of that particular LPN.  
While dropping, the data gets deleted from temp table as expected, and there is new entry get created in MTL_MATERIAL_TRANSACTIONS table.

The issue is the value of the created_by column is now the user_id of the person who is dropping that LPN.
This was not the casein 11i.   The value of created_by column should remain the user_id of the person who did the pick load.

This issues is confusing the customers as they are not able to properly identify who loaded the item, and who dropped the item.


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

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