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.


-- Problem Statement:
On 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 */
SF_PARTY_NAME(ASAP.sr_loc.party_id) , ASAP.asr_srsi.local_serving_office,
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.


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