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
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
Million Knowledge Articles and hundreds of Community platforms