Bug on Performance on Serial Number Searching in 12.1.3 Service Request Form

This is just a note to make everyone aware of Bug 12982111 PERFORMANCE ISSUE WHEN QUERYING SRS BY SERIAL NUMBER that has recently been discovered in version 12.1.3

Development is currently reviewing. 

The issue seems isolated to this query:

Performance shows the problem is with the following SQL statement:

SELECT /*+ first_rows */ INCIDENT_NUMBER COL1, SUMMARY COL2, PRODUCT_DESCRIPTION COL3, CURRENT_SERIAL_NUMBER_NV COL4, COMPANY_NAME COL5, CUSTOMER_ALIAS COL6, ACCOUNT COL7, NULL COL8, NULL COL9, NULL COL10, NULL COL11, NULL COL12, NULL COL13, NULL COL14, NULL COL15, STATUS_CODE COL16, INCIDENT_DATE COL17, SEVERITY COL18, INCIDENT_TYPE COL19, URGENCY COL20, CONTRACT_NUMBER COL21, NULL COL22, EXPECTED_RESOLUTION_DATE COL23, NULL COL24, NULL COL25, NULL COL26, GROUP_TYPE COL27, COUNTRY COL28, SR_CREATION_CHANNEL COL29, NULL COL30, CALLER_TYPE_NAME COL31, CUSTOMER_NUMBER COL32, NULL COL33, NULL COL34, NULL COL35, INCIDENT_NUMBER_N COL36, PRODUCT_NAME COL37, NULL COL38, TIME_ZONE_NAME COL39, NULL COL40, INCIDENT_ID COL41, CONTRACT_SERVICE_ID COL42, OWNER_GROUP_ID COL43, INCIDENT_OWNER_ID COL44, NULL COL45, RESOURCE_TYPE COL46, CUSTOMER_ID COL47, CUSTOMER_PRODUCT_ID COL48,