HTML Contact Center - Unexpected Error When Searching for Closed SR's with the View By Contact
(Doc ID 2765112.1)
Last updated on APRIL 05, 2021
Applies to:Oracle Field Service - Version 12.2.8 and later
Information in this document applies to any platform.
In HTML Contact Center page, when searching for "Closed" SR's for a contact, an unexpected error occurs.
You have encountered an unexpected error. Please contact your System Administrator for assistance.
JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM
FROM cs_incident_types_tl type
WHERE type.incident_type_id = inc.incident_type_id
AND type.LANGUAGE = userenv('LANG')
Steps to Reproduce
Customer Support > Customer Management > HTML Contact Center
View By Contact
Select All and Refresh - Both open and closed SR's are returned
Select Closed and Refresh -Receive the error message:
You have encountered an unexpected error.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document