My Oracle Support Banner

The OTM Purge Process Appears To Have A Limit On The Number Of Records That Can Be Purged At One Time. (Doc ID 1407344.1)

Last updated on OCTOBER 02, 2018

Applies to:

Oracle Transportation Management - Version 6.2.1 and later
Information in this document applies to any platform.
***Checked for relevance on 29-Jul-2013***

Goal


I am currently testing the "Mark for Purge" process, trying to first delete all shipment records older than 6 months, and then delete all order release records older than 6 months.

I find that the "Mark for Purge" does not work with a large number of records however when I limit the number of records in the query by changing the query, the "Mark for Purge" works fine.

Is there a limit on the number of records that can be Marked for Purge?


Solution

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
Goal
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.