RPM 'ItemLocDeleteBatch' Process Is Not Deleting Records from RPM_FUTURE_RETAIL Table
Last updated on FEBRUARY 13, 2018
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.
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