Service Request form (CSXSRISR): Search By Instance Number Is Very Slow On Instance Search Form (Doc ID 1575984.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Teleservice - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On 12.1.3:

When searching on the Instance Search form opened from the Service Request Form Header and search for an instance number, the search takes several minutes.

When doing the same search on serial number the performance is ok.

This is statement which is causing the problem:

SELECT REFERENCE_NUMBER COL1, PRINCIPAL_PARTY_NAME COL2, ACCOUNT_NUMBER COL3,
 RELATIONSHIP_TYPE_CODE COL4, PRODUCT_DESCRIPTION COL5,
 CURRENT_SERIAL_NUMBER COL6, REVISION COL7, CURRENT_ADDRESS COL8,
 INSTANCE_NAME COL9, SYSTEM COL10, PRODUCT_NAME COL11, CP_LOT_NUMBER COL12,
 EXTERNAL_REFERENCE COL13, MOST_RECENT_FLAG COL14, SERVICED_STATUS_FLAG
 COL15, ORIGINAL_ORDER_NUMBER COL16, ORIGINAL_LINE_NUMBER COL17,
 ORIGINAL_ORDER_DATE COL18, SHIPPED_DATE COL19, QUANTITY COL20,
 PURCHASE_ORDER_NUM COL21, PARENT_CP_ID COL22, CUSTOMER_PRODUCT_STATUS_ID
 COL23, TYPE_CODE COL24, CUSTOMER_ID COL25, CUSTOMER_PRODUCT_ID COL26,
 ACCOUNT_ID COL27, LOCATION_ID COL28, LOCATION_TYPE_CODE COL29
FROM
CS_SR_NEW_FIND_PROD_MAINT_V WHERE -1=-1 and organization_id = :org_id and
 upper(reference_number) = upper(:reference_number) ORDER BY COL2 ASC



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