My Oracle Support Banner

MSS Throwing Constraint Error FK_DE_GL_AS_SE__CI when Closing the DD Task of Cancelled Orders for Virtual Circuits (Doc ID 2335976.1)

Last updated on DECEMBER 05, 2017

Applies to:

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

Symptoms

PROBLEM STATEMENT

MSS is throwing a Constraint Error at DD task when closing Cancelled Orders for Virtual Circuits: FK_DE_GL_AS_SE__CI

CURRENT BEHAVIOR

MSS is not removing the information in the design_glr_assgnmt_segment Table when a Cancel Change command is executed to process a RID-like task after an order is Supp Cancelled.

MSS allows users to Supp Cancel the order, execute the Cancel Change, but when completing the DD task, it throws a Constraint Error for FK_DE_GL_AS_SE__CI error.

At this point, the Circuits are in Read Only Mode and there is nothing that can be done.

This appears to be similar to other SR I opened for NS_CON_REL_CA_VAL Cancel Issue opened on SR 3-12640866901.

EXPECTED BEHAVIOR

MSS should remove this info at time of Cancel Change for the Design. If not, it should at least not allow Cancel Change to occur and
throw an error that this info needs to be removed. I would really expect Cancel Change to take care of this.

STEPS

The issue can be reproduced with the following steps:

1. Find open PSR orders for New Installation of Virtual Circuits (%TQW /EVC%) with connections In Progress status,
and with information in the design_glr_assgnmt_segment table.
2. Supp Cancel the order and process supplement
3. Open a RID-behavior task and execute Cancel Change in the Service Request Connections window
4. Complete this task
5. Complete the DD task

6. MSS throws the following error.

ERROR

Error in PSR Due Date. Contact your System Administrator.
of_cancel_circuit: 20:ORA-2290: integrity constraint
(ASAP.FK_DE_GL_AS_SE__CI) violated - child record found.

ADDITIONAL INFORMATION

To replicate the error, you should find a New Install Order in your system that has info in the Table: design_glr_assgnmt_segment.
Any of these orders should allow you to cancel PSR, cancel Design, then throw error at DD closure about the GLR Segment.

BUSINESS IMPACT

This issue is causing significant impact on ordering.


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.