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

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms



ACTUAL BEHAVIOR
---------------
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.

EXPECTED BEHAVIOR
-----------------------
Expect for this process to take less than a minute

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



Cause

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