Cleanup Items Batch Job Does Not Purge Items in Status D from STORE_ITEM Table
(Doc ID 3048155.1)
Last updated on NOVEMBER 11, 2024
Applies to:
Oracle Retail Enterprise Inventory Cloud Service - Version 24.0 and laterInformation in this document applies to any platform.
Symptoms
Cleanup Items batch does not remove the items from the store_item tables. When items are marked for deletion at the location level in MFCS, items are marked to status D in SIOCS STORE_ITEM table but there is no option to purge them.
Steps to Reproduce:
1. Mark an item for deletion in MFCS and let the message flow into SIOCS via RIB
2. Item is marked to status D in STORE_ITEM table
3. Run Cleanup Items batch
Items not deleted from STORE_ITEM.
According to the Administration Guide, this batch program deletes items with a status of Delete (D) if the following conditions are met:
1. SOH (Stock on Hand) of the item, item parent, and item grandparent is 0.
2. No transfers exist for the item, item parent, and item grandparent.
3. No RTV (Return to Vendor) exists for the item, item parent, and item grandparent.
4. No inventory adjustment exists for the item, item parent, and item grandparent.
5. No item basket exists for the item.
6. No product group exists for the item.
7. No stock count exists for the item.
8. No store order exists for the item.
9. No item request exists for the item.
10. No direct store delivery exists for the item.
11. No warehouse delivery exists for the item.
Cause
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
Symptoms |
Cause |
Solution |
References |