Cleanup Items Batch Does Not Remove The Items From The Store_item Tables (Doc ID 3039766.1)

Last updated on AUGUST 07, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
The Cleanup Items batch does not remove the items from the store_item tables.

The business has marked a store-item for deletion in RMS, which marked the item for deletion in SIOCS (store - Item status = "D"). However, upon executing the cleanup item job, the item was still not deleted and appears in the lookup.

According to the AG, we understand that 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.

**Example:**
- Item: 122472831
- Store: 30650


EXPECTED BEHAVIOR
-----------------------
Item in D status should get deleted.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Mark a store-item to delete status in RMS
2. SIOCS store item status is changed to Delete
3. Clean up item batch is executed
4. the store-item status is still seen in SIOCS

Changes

Cause

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