A Call Submitted With a New Trouble Code Is Not Created Correctly, Code Column Is Blank and Power Type Is OUT when It Should Be ON (Doc ID 1075436.1)

Last updated on JULY 12, 2016

Applies to:

Oracle Utilities Network Management System - Version 1.7.1.1 and later
Oracle Network Management for Utilities - DMS - Version 1.7.1.1 and later
Information in this document applies to any platform.

Symptoms

There are currently five choices under the 'Emergency' category in the Trouble Call Entry screen including N/A.  Six more choices were added for a total of 11 choices.

All 11 items appear in the Emergency list and any one of them can be selected however, only the first ten work properly.  More specifically, the trouble codes with CODE_NUM in the range of 0 to 9 (in the SRS_TROUBLE_CODES table) work properly.

When the last item in the list (CODE_NUM=10) is selected, and a call submitted, the event is created with the following characteristics:

1) The 'Code' column in the Work Agenda is blank (for example, it should display 'Elec Cont' for example).

2) The power type is automatically set to 'OUT' even when selecting the power type to be 'On'.

3) The event is not treated as if it is an emergency (no 'E' in the E column).

Changes

For example, the following were added to <project>_srs_trouble_codes.sql file:

insert into srs_trouble_codes values
('Emergency', 2, 'House Fire', 'default', 5, 2, '', 'H Fire', 0, 1, 140100, '');
insert into srs_trouble_codes values
('Emergency', 2, 'House Fire2', 'default', 6, 2, '', 'H Fire2', 0, 1, 140100, '');
insert into srs_trouble_codes values
('Emergency', 2, 'Vehicle Accident', 'default', 7, 2, '', 'Veh Acc', 0, 1, 70100, '');
insert into srs_trouble_codes values
('Emergency', 2, 'Vehicle Accident2', 'default', 8, 2, '', 'Veh Acc2', 0, 1, 70100, '');
insert into srs_trouble_codes values
('Emergency', 2, 'Vehicle Wires', 'default', 9, 2, '', 'Veh Wire', 0, 1, 280100, '');
insert into srs_trouble_codes values
('Emergency', 2, 'Electrical Contact', 'default', 10, 2, '', 'Elec Cont', 0, 1, 210100, '');

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