My Oracle Support Banner

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 APRIL 15, 2021

Applies to:

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


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.



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.