Performance Slow During Bulk Plan Screen Refresh (Doc ID 979865.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Operational Planning - Version: 5.5 to 6.0 - Release: 5.5 to 6
Information in this document applies to any platform.
***Checked for relevance on 01-Aug-2011***

Symptoms


Bulk plan milestones are turned on by setting the number of orders for which it should be triggered to a low value in the planning parameter set, and the bulk plan milestone is loaded with a few thousand records in order to test real life performance instead of empty table performance.

When running a bulk plan and then clicking refresh, a query will be run but will perform poorly, which is admittedly more a nuisance than an actual fault. But it does contribute to a poor subjective impression and doubts whether the system is performing properly.

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