Items Being Deleted From RPM_FUTURE_RETAIL Table For Active Items (Doc ID 3081384.1)

Last updated on APRIL 11, 2025

Applies to:

Symptoms

Items seem to have been deleted from RPM_FUTURE_RETAIL table. They continue to exist on all the other tables, including RPM_ITEM_LOC.

1)- This is affecting some Items that were migrated (through the Data Conversion application), which had the records on RPM_FUTURE_RETAIL, but were deleted from RPM_FUTURE_RETAIL - although the Items still exist and active in MFCS;
 
2)- This is also affecting Items that were created in the meantime through Integration Merch Items REST API - which had the records created in RPM_FUTURE_RETAIL but later the records seem to have been deleted.

 Confirmed that the item records were present in the RPM_FUTURE_RETAIL table following Lift & Shift to Prod.


The following SQL query displays all affected Items;

/* Check all transactional Level 1 items that don't have a record in RPM_FUTURE_RETAIL */
/* This excludes items created today, since those will only be processed in the Merch Night Batch */
select im.item, im.item_desc, im.create_id, im.create_datetime, im.last_update_datetime
from item_master im
where im.item_level = im.tran_level
and im.item_level = 1
and not exists (select 1 from rpm_future_retail fr where fr.item = im.item)
and exists (select 1 from rpm_item_loc ril where ril.item = im.item)
and trunc(im.create_datetime) <> trunc(sysdate)
order by im.create_datetime desc;

The number of records is growing 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.