My Oracle Support Banner

Records Not Getting Purged from RPM_STAGE_DELETED_ITEM_MASTER Table (Doc ID 1928270.1)

Last updated on JANUARY 02, 2018

Applies to:

Oracle Retail Price Management - Version 13.0.6 and later
Information in this document applies to any platform.


In Oracle Retail Price Management (RPM) 13.0.x, the Item Purge batches do not delete records from the RPM_STAGE_DELETED_ITEM_MASTER table.

Steps to Reproduce:

  1. In Oracle Retail Merchandising System (RMS), run DLYPRG.PC to delete an item that exists in RPM.
  2. Note that a record gets populated in RPM_STAGE_DELETED_ITEM_MASTER.
  3. After running the RPM item purge batches, note that records still exist in RPM_STAGE_DELETED_ITEM_MASTER.




To view full details, 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 a vibrant support community of peers and Oracle experts.