My Oracle Support Banner

Enhancement Request: InTransits For Whse To Store Shipments Are Not Reconciled Quickly For A Missing/misdirected Carton (Doc ID 2661008.1)

Last updated on DECEMBER 01, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 16.0 and later
Information in this document applies to any platform.


When a container is acknowledged as "missing" during receiving in SIM and SIM has sent the container level short receipt details to RMS the in-transit values are not resolved in RMS where as they are resolved immediately in SIM. Thus RMS will not correctly calculate replenishment until the loss has been reconciled.

Steps to reproduce:
1. Create/approve a warehouse to store transfer which will ship from WMS in multiple containers.
2. Within SIM receive one container as missing (acknowledge all line items in the container has having received 0). Receive the remaining containers in full.
3. Capture the processed outbound SIM MPS_STAGED_Message payloads. Note that all are container-based receiving messages and that the "missing" items all correctly send RMS all of the information it needs to be aware that the contents were received with zero quantity (a loss has been taken).
4. Review the related RMS shipment/shipsku data:
  a) Line items with non-zero receiving activity are updated in shipsku.
  b) Line items with receipt quantities of zero have not been updated in RMS (observe last_update_datetime has not been updated since the shipment was created), nor have the contents of those line item been reconciled.
5. Review the related TSFDETAIL lines.
  a) Line items with non-zero receiving activity are updated in tsfdetail.
  b) Line items which were recieved as "missing" have not been updated/reconciled. Last_update_datetime has not been updated since the shipment was created.
6 . Compare RMS ITEM_LOC_SOH, and SIM STORE_ITEM_STOCK and observe that the items received as "missing" have had their in-transit values correctly decremented by SIM, but RMS has retained the in-transit values.


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.