My Oracle Support Banner

"RL" Adjustment Code Is Not Updated In RMS When Short Receiving An Item On A Transfer (Doc ID 1370232.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Retail Store Inventory Management - Version 13.0.5 and later
Information in this document applies to any platform.


Retail Merchandising System (RMS) is not updating SHIPSKU table with proper adjustment type, when a transfer generated via transfer request is under received in Store Inventory Management (SIM) system.

Note : SHIPSKU is correctly updated with the right adjustment type, if a normal transfer is under received in SIM.

Steps to recreate:

  1. Data Setup:
    • RMS:
    • SIM:
      • System Admin Option: Transfer Force Close Indicator = 'RL' - Receiving Loss
  2. Consider two stores (ex: Store A, Store B)
  3. Log into SIM, using Store A
  4. Navigate to 'Shipping/Receiving' -> 'Transfers'
  5. Click on 'Create Request'
  6. Create a transfer request to Store B for an item that is available at both stores
  7. Create the request for a quantity of 10 units
  8. Click on 'Request'
  9. Log out of Store A, and log into Store B, in SIM
  10. Navigate to 'Shipping/Receiving' -> 'Transfers'
  11. Open the incoming transfer request, enter the requested quantity of 10, and click on 'Accept'
  12. Note that a new transfer is created
  13. Dispatch the transfer
  14. Log out of Store B and log into Store A in SIM
  15. Navigate to 'Shipping/Receiving' -> 'Transfers'
  16. Open the incoming transfer
  17. Enter a quantity less than dispatched quantity (for example, enter a quantity of 5 units)
  18. Click on 'Confirm'
  19. Query RMS database table SHIPSKU and note that the new record created and has a null value for SHIPSKU.ADJUST_TYPE column
  20. Now log into SIM, into Store B
  21. Navigate to 'Shipping/Receiving' -> 'Transfers'
  22. Click on 'Create' (to create a Transfer, not a transfer request)
  23. Select Store A
  24. Create a transfer for the same item for a quantity of 20 units and dispatch the transfer
  25. Using SIM, log into Store A
  26. Navigate to 'Shipping/Receiving' -> 'Transfers'
  27. Open the incoming transfer and enter a received quantity of 10 and confirm the receipt
  28. Query RMS database table SHIPSKU and notice, the new record created and has a non-null ('RL')value for SHIPSKU.ADJUST_TYPE column




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.