Purge Item Batch Job Deletes Data From Item Table and Not From the Rest of the Tables
(Doc ID 2807750.1)
Last updated on OCTOBER 05, 2021
Applies to:
Oracle Retail Enterprise Inventory Cloud Service - Version 19.2 and laterInformation in this document applies to any platform.
Symptoms
Items with a STATUS of D are not completely purged from all the ITEM tables when the Purge Item job is executed.
EXPECTED BEHAVIOR
-----------------------
Items should not exist in tables such store_item, store_item_stock, item_price, purchase_order_line_item,etc.
Steps to Reproduce:
1. Delete the items in MFCS
2. RIB Messages updated status of those items to be "D" in SIOCS
3. Ran Purge Item Job
4. Items were deleted from ITEM tables
5. But Items still exist in rest of tables such store_item, store_item_stock, item_price, purchase_order_line_item,etc.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |