Inventory Adjustments Are Created With Wrong Disposition Changes, Causing Inventory Imbalances Of Unavailable Units Between RWMS And RMS (Doc ID 2105477.1)

Last updated on JULY 10, 2017

Applies to:

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

Symptoms

Inventory adjustments are created with wrong disposition changes during cycle count which causes inventory imbalances of unavailable units between RWMS and RMS.

Steps To Recreate:

  1. Apply WIP code 'GIFT_C' to both the child labels on a labeled master in reserve location.
  2. Check INV_ADJUSTMENT_TO_UPLOAD records as below:
  3. Notice that inventory disposition changes from ATS to WIP.
  4. Mark reserve location for cycle count.
  5. Cycle count and find no inventory in the reserve location.
  6. Notice that the pallet goes to UNLOCATEDLOC and no change in INV_ADJUSTMENT_TO_UPLOAD.
  7. Apply trouble code 'LS' (Lost) to 2 child labels and notice that WIP to TRBL disposition change records get created in INV_ADJUSTMENT_TO_UPLOAD table.
  8. Cycle count the reserve location and now find the pallet with 2 children there.
  9. Notice that INV_ADJUSTMENT_TO_UPLOAD gets created from WIP to ATS disposition whereas the children are in 'T' status with 'TRBL' inventory disposition.

 

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