My Oracle Support Banner

Schedule Order Request OEXCSCHB.pls - Performance Issue (Doc ID 2187456.1)

Last updated on AUGUST 14, 2018

Applies to:

Oracle Order Management - Version to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.


When Scheduling an order or a group of orders, the performance is poor. The performance of this function has never been acceptable. It is taking over a minute and sometimes up to an hour to complete. Gather stats are run every weekend, at 10% on all schema.

Expect for this process to take less than a minute

The issue can be reproduced at will with the following steps:
1. Log in to Order Management responsibility
2. Go to Reports, Requests > Run Request
3. Select Schedule Orders program and submit this with Operating Unit parameter
4. Alternatively, query a Booked Order that is eligible for Scheduling
5. Either way of Scheduling takes longer than expected.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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