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:

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

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