My Oracle Support Banner

Getting Exception For Google Maps After Applying 9570908 (Doc ID 1098988.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Field Service - Version 12.0.4 to 12.0.6 [Release 12]
Information in this document applies to any platform.

Goal

  1. Launch Google Map from the Dispatch Center.
  2. The map launches successfully.
  3. Select any query or tasks and click on refresh.
  4. The error is thrown
    Error Page You have encountered an unexpected error. Please contact the System Administrator for assistance.
  5. Select any task at Dispatch Center and click on view-selected task at Google Map.
  6. Same issue is observed.

Exception Details.



As part of  Bug 7421904, any of the four address lines could be used and the column in the query was changed to be ADDRESS_LINE. But the result set pertaining to one flow where  Resource Trips are plotted is still using ADDRESS1. This is the reason for the issue.

Patch 9570908:R12.CSF.A includes SpatialAMImpl.java 120.5.12000000.9

SpatialAMImpl.java 120.5.12000000.9 changes the column name from address1 to address_line
But the Location class still refers to address1.

This is be fixed in SpatialAMImpl.java 120.5.12000000.10 2009/01/06 where the location class refers to the new name address_line.

Solution

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
Goal
Solution
References


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