Getting Error "APP-JTF-210604" By Querying for Alphanumeric Postal Code Using Flashlight On Dispatch Center

(Doc ID 2196779.1)

Last updated on OCTOBER 31, 2016

Applies to:

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

Symptoms

On : 12.1.2 version, Dispatch Center

Users are getting an error by querying postal codes using the flashlight ( search) on the Dispatch Center form (specially when the postal code is alphanumeric ) .



ERROR
-----------------------
See the error
ORA-00907:missing right paranthesis
ORA-06512 :at "APPS.JTF_GRIDDB",line837
ORA-06512:at "APPS.JTF_GRIDDB",line 878

Followed by
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:<TASK_GRID.TASK_BEGAN>
datasource:<CSF_DC_TASK_GRID>

The error is most likely in the form or the metadata definition.Please check the following alert for the error code.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Open Dispatch Center form
2.Click search icon
3.Click Base Button
4.Choose Postal code and click 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