My Oracle Support Banner

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

Last updated on MARCH 05, 2020

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.

Symptoms

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:


PreRequisties:

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

1. Run PurgeItem.sh script

No data is deleted from the STORE_ITEM table.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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