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

Last updated on JUNE 07, 2016

Applies to:

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

Symptoms

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.

Cause

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