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 MARCH 07, 2019
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.
It this point, the Circuits are in Read Only Mode and there is nothing that can be done.
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.
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!
