Performance Issue When Running "Delete Item Information" Program Due To Delete Constraint ITM_DEL57 On Table OE_HOLD_SOURCES
(Doc ID 2992155.1)
Last updated on DECEMBER 12, 2023
Applies to:
Oracle Item Master - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
"Delete Item Information" Program to purge unused/old/inactive items from the system is taking long to complete
"Delete Group" for 1 Org with 200 items took 1 hr 50 min to complete.
STEPS
1. Inventory > Items > Delete items
2. Run add items to delete group > Delete.
3. See program launched , takes a long time to complete.
Trace file confirms below query was taking a long time
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 |