My Oracle Support Banner

Business Data Purge Performance Issues (Doc ID 1368620.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 6.2.1 to 6.2.4 - Release: 6.2 to 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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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