Creating New Order That Uses New Partition Results In Web Client Error ORA-01013

(Doc ID 1298357.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle Communications Order and Service Management - Version 6.3 to 7.3.0.0.0 [Release 6.3 to 7.3.0]
Information in this document applies to any platform.
***Checked for relevance on 05-July-2013***
***Checked for relevance on 04-March-2015***
***Checked for relevance on 20-Sept-2017***

Symptoms

After orders start going into a new partition, creating a new order in the web client leads to the following:

Error Ora-01013: User Requested Cancel Of Current Operation

After restarting the database, and trying to connect to OSM, we are not able to connect:

Please use the navigation buttons located above to proceed
Message Type: Warning
Message Code: 500
Message: ORA-01013: user requested cancel of current operation ORA-06512: at "PROVISIONING1.OM_ORDINST_VALUE_PKG", line 1363 ORA-06512: at "PROVISIONING1.OM_ORDINST_VALUE_PKG", line 1394 ORA-06512: at "PROVISIONING1.OM_ORDINST_VALUE_PKG", line 1514 ORA-06512: at "PROVISIONING1.OM_ORDINST_VALUE_PKG", line 1572 ORA-06512: at line 1 : ORA-01013: user requested cancel of current operation ORA-06512: at "PROVISIONING1.OM_ORDINST_VALUE_PKG", line 1363 ORA-06512: at "PROVISIONING1.OM_ORDINST_VALUE_PKG", line 1394 ORA-06512: at "PROVISIONING1.OM_ORDINST_VALUE_PKG", line 1514 ORA-06512: at "PROVISIONING1.OM_ORDINST_VALUE_PKG", line 1572 ORA-06512: at line 1

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