My Oracle Support Banner

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

Last updated on MARCH 12, 2021

Applies to:

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


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.




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.