My Oracle Support Banner

Performance Issue with OM Order Purge OEXVPURB Program. (Doc ID 417737.1)

Last updated on DECEMBER 21, 2023

Applies to:

Oracle Order Management - Version 11.5.8 to 11.5.10.3 [Release 11.5.8 to 11.5.10]
Information in this document applies to any platform.

Symptoms

On 11.5.8 in Production:
Poor performance in Order Purge program. OM order purge is taking long time to run and is
running for 2-3 days.

EXPECTED BEHAVIOR
Expect is that Order Purge program should complete within expected time.

STEPS
The issue can be reproduced at will with the following steps:
Create the purge set using "Order Purge Selection" concurrent Program.
Order Management Super User -- > Orders, returns --> Order Purge --> Order Purge Selection
This asks for a few parameters. Provided following parameters:--
a)Purge Set Name
b)Purge Set Description
c)Order Number Low
d)Order Number High
e)Creation date Low
f)Creation Date High

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


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