RPM_PROMO_ITEM_LOC_EXPL deletion issue for Items Purged in RMS

Good afternoon !!!

We are currently running Item Purge in RMS and one of the issue we face is after the Items are Purged from RMS, the data gets populated into RPM_STAGE_DELETED_ITEM_LOC and RPM_STAGE_DELETED_ITEM_MASTER. Now when we run the RPM Itemloc delete batch our expectation is that the deleted Items should be purged from all RPM tables but in actual part the RPM_PROMO_ITEM_LOC_EXPL table still retains some records for the deleted items in the table after the batch completion.

On further analysis on the package RPM_ITEM_LOC_DELETION_SQL , it was found that RPM_PROMO_ITEM_LOC_EXPL deletes based on the join between RPM_STAGE_DELETED_ITEM_LOC and RPM_STAGE_DELETED_ITEM_MASTER with deletion keys set at ( item,dept,location). The table RPM_STAGE_DELETED_ITEM_LOC populates when records are deleted from ITEM_LOC table , since there are certain locations missing for particular styles those item,loc combinations were not inserted into   RPM_STAGE_DELETED_ITEM_LOC and because of this those mismatch records were not deleted from RPM_PROMO_ITEM_LOC_EXPL table .