CKTID Task for Some Orders is Displaying a Blank Service Request Connection Window

(Doc ID 2081246.1)

Last updated on NOVEMBER 23, 2015

Applies to:

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

Symptoms

PROBLEM STATEMENT
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
When double-clicking to open CKTID task, there is nothing there....


1. MSS is duplicating the PRILOC or SECLOC location in the srsi_sr_loc table.
2. There's also another flavor of this error where the srsi_sr_loc table only has one PRILOC or SECLOC, but the location_id had 2 rows in the end_user_location.location_id_sr table resulting in the same error.

No errors are displayed in the GUI.

EXPECTED BEHAVIOR:
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
We are expecting the circuits on the order to appear.

STEPS
-----------------------
The issue can be reproduced following steps:

1. Open the Work Queue Mgmt
2. Double-click the CKTID task for an order that has CKTID task with one or more circuits to be identified.
3. MSS displays a blank Service Request Connections window


BUSINESS IMPACT
-----------------------
Due to this issue, users cannot work the task.

WORKAROUND
¯¯¯¯¯¯¯¯¯¯¯¯¯
The work around is to delete the location off the PSR, which will delete the offending rows, and then add a new one.
The problem is finding which one it is, as there is no indication in the GUI there is a problem with the locations.
One needs to query the database in the following tables.columns to identify the duplication:
  a. srsi_sr_loc » location_id for the same service_item_id - related to Problem (1) above
  b. end_user_location » location_id_sr - relative to Problem (2) above.


ADDITIONAL INFORMATION:
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
We saw the following error in the trace file.

ORA-01427: single-row subquery returns more than one row (trace file attached)

No errors are displayed in the GUI.
The following query revealed that one of the PRILOCs had 2 rows. This was causing the error since there should only be 1 row.

      select * from srsi_sr_loc where document_number = 11939578

We are not able to determine how 2 rows are being inserted. The last modified indicates a user did this and not any custom code.
This began with the latest Efix of 6.2.1.804.3.
.

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