My Oracle Support Banner

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.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM
(SELECT distinct
    inc.incident_number incident_number,
    tl.summary summary,
    FROM cs_incident_types_tl type
    WHERE type.incident_type_id = inc.incident_type_id
    AND type.LANGUAGE           = userenv('LANG')
    ) type,


Steps to Reproduce

Customer Support  > Customer Management > HTML Contact Center

Query Account

Select Contact

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.