Schedule Order Request OEXCSCHB.pls - Performance Issue

(Doc ID 2187456.1)

Last updated on MARCH 08, 2017

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.


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 hundreds of Community platforms