My Oracle Support Banner

CKTID Task for Some Orders is Displaying a Blank Service Request Connection Window (Doc ID 2081246.1)

Last updated on MARCH 14, 2019

Applies to:

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


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.

We are expecting the circuits on the order to appear.

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

Due to this issue, users cannot work the task.

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.

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




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

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