My Oracle Support Banner

nms_schema_customer_sum_view.sql Fails If Values In the CU_SERVICE_LOCATIONS.SERV_REVENUE_CLASS Column are Not Null (Doc ID 2870724.1)

Last updated on MAY 19, 2022

Applies to:

Oracle Utilities Network Management System - Version 2.5.0.1.0 to 2.5.0.2.0 [Release 2.5]
Oracle Network Management for Utilities - DMS - Version 2.5.0.1.0 to 2.5.0.2.0 [Release 2.5]
Information in this document applies to any platform.

Symptoms

On : 2.5.0.1.0 version, Installation

nms_schema_customer_sum_view.sql fails when cu_service_locations.serv_revenue_class is populated

The nms_schema_customer_sum_view.sql errors out when the cu_service_locations.serv_revenue_class is populated. This is because serv_revenue_class is defined as a VARCHAR2(30) and the SQL to build the customer_sum view tries to do an AVG on that value, which is not a number. I suspect this hasn't been caught because the OPAL customer population has serv_revenue_class as NULL.
 

ORA-01722: invalid number



The issue can be reproduced at will with the following steps:
1. Run "nms-setup -clean" on a system that has non-null values for cu_service_locations.serv_revenue_class
2. Observe the errors

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
 Fix Description
 Migration
References


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