Terminating Information is Lost When Connection Spec Was Changed for Connections Created by EWO Order (Doc ID 2039224.1)

Last updated on MARCH 02, 2019

Applies to:

Symptoms

An EWO was issued for a mixture of circuits – some of which are Ethernet (template-based).

When a given circuit was first built, the spec used was Let say A (because Spec B was not available):

The engineers then went and added elements to a network and they wanted the TLM (Bandwidth) reassigned between the elements.
As such, they created connection spec B.

The process we were advised to follow to ‘change the spec’ for the existing bandwidth was to go into the network and assign it to the connection we wanted.

We did this and it updated the network system information but it lost its terminating location. There are probably several in this category.

So, my question is – does this look familiar? Is it a hole in the code? Is there a hung Z location somewhere in the tables that thinks this is still associated to an end user location?

Please provide an answer as well as a SQL script to clean/update these items.

Looking in the database, there is Customer Site that is still in the database, with Status 1 - Pending status.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.