Business Data Purge Performance Issues
(Doc ID 1368620.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Transportation Management - Version 6.2.1 to 6.2.4 [Release 6.2]Information in this document applies to any platform.
Symptoms
On OTM version 6.2.1 version data purge is taking a long time to run.
ACTUAL BEHAVIOR
---------------
Business data purge in OTM version 6.2.1 is taking a long time to run. There are long durations for Action Type Mark for Shipment Appointment, Shipment Audit Trail, and Order Release Audit Trail. It take the data purge 7 hours to complete for a purge of approximately 4000 shipments.
EXPECTED BEHAVIOR
-----------------------
Expect purge to run much faster.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the OTM purge.
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 |