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.


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 ) .

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


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

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


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