Universal Work Queue HTML JBO-27122: SQL Error (Doc ID 2173370.1)

Last updated on SEPTEMBER 13, 2016

Applies to:

Oracle Field Service - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Dispatch Center

JBO-27122: SQL error during statement preparation.

Statement: SELECT INCIDENT_NUMBER INCIDENT_NUMBER , SUMMARY SUMMARY , MODIFIED_DATE MODIFIED_DATE , OWNER_NAME OWNER_NAME , OWNER OWNER , INCIDENT_COUNTRY INCIDENT_COUNTRY , PROBLEM_CODE PROBLEM_CODE , CONTACT_TYPE CONTACT_TYPE , CONTACT_NAME CONTACT_NAME , CONTACT_NUMBER CONTACT_NUMBER , CONTACT_ADDRESS CONTACT_ADDRESS , CONTACT_COUNTRY CONTACT_COUNTRY , CREATION_DATE CREATION_DATE , SR_TYPE SR_TYPE , STATUS STATUS , SEVERITY SEVERITY , CUSTOMER_TICKET_NUMBER CUSTOMER_TICKET_NUMBER , MODIFIED_BY MODIFIED_BY , LANGUAGE_CODE LANGUAGE_CODE , CREATED_BY CREATED_BY , PRODUCT_NAME PRODUCT_NAME , PROJECT_NUMBER PROJECT_NUMBER , CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER , SR_CREATION_CHANNEL SR_CREATION_CHANNEL , RESOLUTION_CODE RESOLUTION_CODE , SERIAL_NUMBER SERIAL_NUMBER , TAG TAG , PERSON_ORG PERSON_ORG , ESCALATED ESCALATED , RESOURCE_ID RESOURCE_ID , IEU_MEDIA_TYPE_UUID IEU_MEDIA_TYPE_UUID , RESOURCE_TYPE RESOURCE_TYPE , SERVERITY SERVERITY , COVERAGE_LEVEL COVERAGE_LEVEL , COVERAGE_NAME COVERAGE_NAME , INCIDENT_ID INCIDENT_ID , EXPECTED_RESOLUTION_DATE EXPECTED_RESOLUTION_DATE , OBLIGATION_DATE OBLIGATION_DATE , URGENCY URGENCY , COVERAGE_TYPE COVERAGE_TYPE ,1, 2, 3, 4 FROM CS_SR_UWQ_EMP_COUNT_V where RESOURCE_ID = 100509734 AND RESOURCE_TYPE NOT IN ('RS_GROUP','RS_TEAM') AND RESOURCE_ID = 100509734 AND RESOURCE_ID IS NOT NULL order by CREATION_DATE

ERROR
-----------------------
JBO-27122


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Customer support specialist ==> customer support ==> Universal Work Queue HTML
root node ==> service requests (Note: 2nd node) ==> My Service Request

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