My Oracle Support Banner

Move Order Rejected with Error ORA-00001: Unique Constraint (ASAP.PK_TEL_NUM_INV) Violated (Doc ID 2399846.1)

Last updated on JULY 09, 2018

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.

Symptoms

MSS 6.2.1   |  Telephone Number Move Using API Move Order

========================================


 When users try to move a Telephone number by disconnecting a TN and creatingit under another service item using the CreateOrderByValueRequest XML API, the application returns the below error if the suffix that is getting created is 10 or higher.

ERROR:

=====

Error ORA-00001: unique constraint (ASAP.PK_TEL_NUM_INV) violated

Cause

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.