RPM 'ItemLocDeleteBatch' Process Is Not Deleting Records from RPM_FUTURE_RETAIL Table (Doc ID 1100055.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

The Retail Price Management (RPM) batch process 'ItemLocDeleteBatch' handles Retail Merchandising System (RMS) deletions of item locations. When RMS deletes an item/location, RPM uses this process to remove the item/location rows from the RPM_FUTURE_RETAIL table so that pricing events are no longer published out of RPM.

The following scenarios are not being handled appropriately by 'ItemLocDeleteBatch':

1. When the item is deleted from RMS: Under this scenario, all the item/location combinations related to that item should be deleted from the RPM_FUTURE_RETAIL table.

2. When the item/location combination is set to delete status in ITEM_LOC in RMS: Under this scenario, the item/loc combination that was set to delete status in RMS should be deleted from the RPM_FUTURE_RETAIL table.


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