ERROR :ORA-00904:invalid identifier for Network Areas and Network System With Name Starting With "IN" (Doc ID 2261675.1)

Last updated on MAY 08, 2017

Applies to:

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

Symptoms

On : 6.0.15 version, Engineering

There is a Network Area .When a user tries  to associate a network system INAB_LET_2 to it , it throws an error as mentioned below. If the user enters a space in front of the short name field then MSS sees the network system just fine. Also , if the Search criteria such as Like INABC_LET_2% is used , then also the correct results are displayed .

 
 





STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open a Network Area .
2. Go to Network Item tab .
3. Try associating a network System , with name starting with "IN".(Enter the full name to see the issue)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Users are not able to associate the NS to the NA if they search using the full NS name in the Short name field .

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