Cancel Order Web Service Request Required about 30 seconds on a System. (Doc ID 1332582.1)

Last updated on AUGUST 13, 2013

Applies to:

Oracle Communications Order and Service Management - Version: 7.0.2 and later   [Release: 7.0.0 and later ]
Information in this document applies to any platform.

Symptoms


Cancel order web service request spent about 30 seconds running on a production system. A full table scan on the biggest table OM_ORDER_INSTANCE was running during this request.


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