ERROR ORA-02292: integrity constraint (ASAP.PFXFK_DL_NS_RE_CA_VA__NS_CO_RE) violated On Cancel Change
Last updated on JANUARY 02, 2018
Applies to:Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.
In MSS 6.2.1 Connection Design
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.
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.
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