Double Inventory Adjustment Posted to RMS From Forward Case Picking Location (FCPL) Editor (Doc ID 2011239.1)

Last updated on MARCH 26, 2017

Applies to:

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

Symptoms

It is possible, when using the Forward Case Picking Location (FCPL) editor, to pass double inventory adjustments to Retail Merchandising System (RMS).  However, this act only changes the Retail Warehouse Management System (RWMS) stock once.  This causes a stock on hand (SOH) mismatch between RWMS and RMS.


The following scenario posts a double inventory adjustment to RMS:

 1. Select a a Pick Face Location that has inventory. This can be verified from PICK_FROM_LOC entry.
 2. Validate the INV_ADJUSTMENT_TO_UPLOAD for any records for this item today. There will not be any records.
 3. Attempt to clear the inventory in the location with the Forward Picking Location editor.
     a. User 1 logs on to the Forward Picking Location editor from the GUI and queries the above identified record.
     b. User 2 also logs on to the Forward Picking Location editor from the GUI at the same time and queries the same record.
 4. Both users update the case quantity at the same time.
 5. Both users should save the records but not select and confirm the reason code.
 6. Confirm the appropriate reason code in the first user’s screen.
 7. Validate Inventory adjustment posted by the first user in the INV_ADJUSTMENT_TO_UPLOAD table.
 8. At this moment the second user also confirms the appropriate reason code on the Forward Picking Location editor screen. This user receives the error: "Record has been updated by another user".
 9. Query to validate if any additional inventory adjustment was posted in the INV_ADJUSTMENT_TO_UPLOAD table. There is no additional adjustment posted.
10. The second user now clears the Forward Picking Location editor by clicking on the clear option (yellow button) and queries the same record, then double clicks it.
11. The user now clicks on the Save option instead of Exit. An additional inventory adjustment is posted in the INV_ADJUSTMENT_TO_UPLOAD table.

Changes

 

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