Error:'APP-JTF-210604: Program Error' In Oracle Contact Center (Doc ID 2099879.1)

Last updated on MARCH 22, 2016

Applies to:

Oracle Customer Care - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Contact Center

When attempting to perform a search in Contact Center, the following error is seen

ERROR
-----------------------
APP-JTF-210604: Program error: Please inform your system administrator or support representative that:

jtf_grid.populate package reports error:

An unexpected error occured in jtf_grid.populate

grid: <CUSTOMER_RESULTS.LIST>
datasource: <CSC_SEARCH_RESULTS>

Click OK

The error stack is (first 1000 bytes)

ORA-1790: expression must have the same datatype as
corresponding expression
ORA-06512 at "APPS.JTF_GRIDDB", line 837
ORA-06512 at "APPS.JTF_GRIDDB", line 878


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
(R) Customer Support
(N) Customer Management > Contact Center
Search

The error above is displayed


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use the Contact Center form to search.

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