Oracle Trading Community Architecture (TCA) eLocations Spatial Data Integration lets you retrieve spatial information from Oracle eLocations. Oracle eLocations provides mapping, geocoding, and driving directions for the US and supports a range of applications, from mapping, asset management, and transportation applications to wireless location services and location-enabled e-business.

The spatial data that eLocations provides through the TCA integration contains the latitude and longitude for any location within the US. You can acquire and store this information for your addresses in the TCA Registry.

You run the Spatial Information for Locations Batch Update program in eLocations Spatial Data Integration to retrieve spatial data from eLocations into the TCA Registry. See: Spatial Information for Locations Batch Update.

The program starts a PL/SQL script to generate a spatial data request that is sent to eLocations via an HTTP query post. An API parses the response from eLocations and, if the results are successful, updates the HZ_LOCATIONS table with the latitude and longitude for the requested locations.

Your administrator can set up eLocations Spatial Data Integration. See: Setting Up eLocations Spatial Data Integration.