My Oracle Support Banner

Why Is the Item in the DAILY_PURGE Table Not Getting Deleted in The ITEM_LOC Table? (Doc ID 3046898.1)

Last updated on SEPTEMBER 11, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Goal

On: MFCS/RMS 19.3.012.29 version

User has marked Items to delete but it is still appearing in ITEM_LOC table.
Item was marked for delete on 7th June yet the users can see that inventory adjustment has been posted on 30th June. Also there are two items those are also marked as Deleted but as it is not purged the item was adjusted across the Virtual Warehouse (VWH) on prorate wise.

Why the item is in the DAILY_PURGE table but there is no log in error log?
 

Solution

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
Goal
Solution
References


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