My Oracle Support Banner

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***


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


To view full details, 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 a vibrant support community of peers and Oracle experts.