ERROR ORA-02292: integrity constraint (ASAP.PFXFK_DL_NS_RE_CA_VA__NS_CO_RE) violated On Cancel Change (Doc ID 2206338.1)

Last updated on NOVEMBER 23, 2016

Applies to:

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

Symptoms

In MSS 6.2.1 Connection Design

CURRENT BEHAVIOR:

When we have a Pending Special Circuit on a Cancelled Order that has info in the NS_CON_REL_CA_VAL, we are unable to successfully cancel the design. When we hit Cancel Change, it gives us this error:

TBS is stuck at this point:


1. Circuit Cancels
2. Issues are removed
3. NS_CON_REL_CA_VAL info remains in database
4. NS_CON_REL info remains in database
5. PORT_ADDRESS info remains in database
6. Unsure on Facility Assignments as these types of orders don’t normally have them.
Basically at this point, TBS will not allow us to access Circuit and no way to remove design. Actually cant even get into Circuit even in Read only to view it.

EXPECTED BEHAVIOR:

We would expect the system at point of Cancel Change to remove NS_CON_REL_CA_VAL/NS_CON_REL/PORT_ADDRESS/CIRCUIT_POSITION if there is any. Also would expect the Circuit to cancel, Issue to remain but Activity in that table to reflect Cancelled, and atleast allow us to view Cancelled Circuit via Read Only Mode like we normally can.

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