On-Going Issue Where The User Is Locking Up. (Doc ID 753457.1)

Last updated on DECEMBER 04, 2008

Applies to:

Oracle Communications MetaSolv Solution - Version: 6.0.13 to 6.0.16
This problem can occur on any platform.

Symptoms

-- Problem Statement:
On 6.0.15.345 in Production:
Users are locking up when they try to access the circuit section of an ASR


-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. query for an ASR order.
2. go to the circuit section
3. click the add new button
4. you get the following error:


The SQL statement that caused the error is: SELECT /*+ FIRST_ROWS */
ASAP.end_user_location.end_user_location_id,
ASAP.end_user_location.end_user_location_type,
SF_PARTY_NAME(ASAP.sr_loc.party_id) , ASAP.asr_srsi.local_serving_office,
ASAP.end_user_location_usage.access_tel_number,
ASAP.end_user_location_usage.working_telephone_number FROM
ASAP.end_user_location, ASAP.asr_srsi, ASAP.end_user_location_usage,
ASAP.srsi_sr_loc, ASAP.sr_loc, ASAP.serv_req_si WHERE
ASAP.serv_req_si.document_number = ASAP.asr_srsi.document_number (+) AND
ASAP.serv_req_si.serv_item_id = ASAP.asr_srsi.serv_item_id (+) AND
ASAP.srsi_sr_loc.document_number = ASAP.serv_req_si.document_number AND
ASAP.srsi_sr_loc.serv_item_id = ASAP.serv_req_si.serv_item_id AND
ASAP.srsi_sr_loc.location_id = ASAP.sr_loc.location_id (+) AND
ASAP.srsi_sr_loc.document_number = ASAP.sr_loc.document_number (+) AND
ASAP.srsi_sr_loc.document_number =
ASAP.end_user_location_usage.document_number (+) AND
ASAP.srsi_sr_loc.serv_item_id = ASAP.end_user_location_usage.serv_item_id (+)
AND ASAP.srsi_sr_loc.serv_loc_use = ASAP.end_user_location_usage.usage_type
(+) AND ASAP.end_user_location.location_id_sr = ASAP.srsi_sr_loc.location_id
AND ASAP.end_user_location_usage.end_user_location_id_eul =
ASAP.end_user_location.end_user_location_id AND ? =
ASAP.srsi_sr_loc.serv_loc_use AND ? = ASAP.serv_req_si.document_number AND 1
= ROWNUM AND ? = ASAP.srsi_sr_loc.document_number

 


-- Business Impact:
The issue has the following business impact:
You are now stuck, focus is lost on the screen and you have to kill the
session to close it.


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