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

Last updated on MARCH 14, 2017

Applies to:

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

Symptoms

On :  12.2.4 version, Labor Mangement

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

STEPS
-----------------------
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.


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

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