My Oracle Support Banner

Order Purge Exhibiting Poor Performance (Doc ID 3003158.1)

Last updated on FEBRUARY 12, 2024

Applies to:

Oracle Order Management - Version 12.2.10 and later
Information in this document applies to any platform.


Order Purge Program exhibiting poor performance after upgrading to Release 12.2.10 from Release 12.1.3.

For example, in Release 12.1.3, 1.8 million order lines could be purged in 16 hours.
Release 12.2.10, only 531,904 order lines can be purged in 42 hours.

Records are growing exponentially given the inability to purge as many records after the upgrade.

The issue can be reproduced at will with the following steps:

1. OM Super User Responsibility
2. Run Order Purge Program


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

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