My Oracle Support Banner

RMS Item Deletion Process Incorrectly Stages Non Transactional Items for Deletion in RPM (Doc ID 2228934.1)

Last updated on APRIL 15, 2021

Applies to:

Oracle Retail Merchandising System - Version and later
Information in this document applies to any platform.


RMS Item deletion process incorrectly stages non- transaction items for Retail Price Management (RPM) deletion process.
Since RPM is not concerned with such items, the items keep accumulating in staging tables and can cause performance issues with RPM deletion batch.

Steps To Reproduce:

  1. Create a New Item in RMS (Tran level 2 and associate EAN/Barcodes).
  2. Verify that Item is integrated with RPM and note that EAN information is not sent to RPM.
  3. Delete the parent Item using RMS Item Maintenance [itemmaster] screen.
  4. Execute Dlyprg batch and check RPM staging tables : RPM_STAGE_DELETED_ITEM_MASTER and RPM_STAGE_DELETED_ITEM_LOC.
  5. Note that the RPM_STAGE_DELETED_ITEM_MASTER table also contains EAN item information corresponding to the item deleted.
  6. Run RPM batch and verify the data in staging table again.


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.