How to Synchronize Physical Purge Between RMS and SIM at Transaction Item (SKU)/Location Level (Doc ID 2723255.1)

Last updated on FEBRUARY 22, 2023

Applies to:

Goal

When a transaction level Item (SKU)/Location is marked for Deletion (Status D) on RMS Cloud same information is passed to Store Inventory Management (SIM) where, it also marked for Deletion.
Now when you run the batch process to physically delete, SKUs may not be purged on both RMS and SIM on the same day.
RMS batch process may find pending some transactions pertaining to that SKU which will prevent the SKU from being purged from RMS.
Whereas on the SIM side it could get deleted if there are no pending transaction items.
In a typical scenario an item/location which is marked for Deletion in RMS may stay in that state for couple of months, whereas on the SIM side, it could get deleted sooner.
This is the current status of the way purging works, and this could lead out of Sync between RMS and SIM with respect to SKUs.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.