After purging workorders, the Order Id was reset to 1 (Doc ID 1389038.1)

Last updated on JUNE 28, 2013

Applies to:

Oracle Communications Order and Service Management - Version 7.0.3 to 7.0.3 [Release 7.0.0]
Information in this document applies to any platform.
***Checked for relevance on 28-June-2013***

Symptoms

In OSM 7.0.3, if you stop WLS and purge all the work orders.
Then, You restart WLS and provision a workorder. You may notice that the order_id was reset to 1.

This has a high impact on OSM because after the order Id is reset to 1, when we try to create an order id we receive the following error:


<03-Nov-2011 12:01:39,463 EET PM> <ERROR> <core.logSQLException> <ExecuteThread: '22' for queue: 'oms.web'> <SQL Exception 1 : ORA-00001: unique constraint (P
ROVISIONING2.XPKOM_ORDER_FLOW_COORDINATOR) violated

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