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

(Doc ID 2399846.1)

Last updated on MAY 21, 2018

Applies to:

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

Symptoms

TN MOVE SCENARIO USING XML API


Move Order being rejected error ORA-00001: unique constraint (ASAP.PK_TEL_NUM_INV) violated 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.

Changes

 

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