RMS Item Deletion Process Incorrectly Stages Non Transactional Items for Deletion in RPM

(Doc ID 2228934.1)

Last updated on FEBRUARY 06, 2017

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 itemLocDeleteBatch.sh batch and verify the data in staging table again.




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms