My Oracle Support Banner

No Batch Process Available In SIM to Purge Items in Status D (Doc ID 2643697.1)

Last updated on NOVEMBER 01, 2021

Applies to:

Oracle Retail Store Inventory Management - Version 16.0 to 16.0.2 [Release 16.0]
Information in this document applies to any platform.


When data from the ITEM LOCATION table is purged from Retail Merchandising System (RMS), the messages flow to Retail Store Inventory Management (SIM) and set the item's status to D in the STORE_ITEM table. However, there is no purge program in SIM to delete these item records from the SIM STORE_ITEM table.

Steps to Reproduce:


Item exists in the ITEM table with STATUS A and D in the STORE_ITEM table

1. Run script

No data is deleted from the STORE_ITEM table.




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.