Field Service - EBS (MOSC)

MOSC Banner

How to get customer location, possibly latitude and longitude

edited Sep 3, 2013 12:43AM in Field Service - EBS (MOSC) 4 commentsAnswered ✓
Hi,
i am trying to get the customer location information from oracle ebs 12.1.1. What i want is to get the location information in the form of latitude and longitude data. Is it possible to get this data somehow by writing PL/SQL query on any other way. I found that the "geometry" column in my "hz_locations" table is empty. i also have trouble viewing map in the field service dispatch center about which i had posted another question earlier under the subject "field service dispatch center map not displaying properly". But, setting that aside, is it possible to get this location

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center