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:

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.
.

Changes

Cause

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