Google Map in Oracle EAM (GIS Integration)

Geographic Information System (GIS) is an information system for storing, analyzing, managing and presenting digital data such as geographic features present on the Earth's surface using spatial references. Some of the GIS solutions available in the market are ESRI, Google Maps, Oracle Spatial, etc.

A Geocode (Geospatial Entity Object code) is a representation format of a geospatial coordinate measurement used to provide a standard representation of an exact geospatial point location on the earth. For example, the format (41°54'12"N, 87°37'35"W) indicates latitude, longitude of a unique location on earth.

Latitude gives the location of a place on earth north or south of the equator. Lines of Latitude are the horizontal lines shown running east-to-west on maps. Latitude is given as an angular measurement ranging from 0° at Equator to +90° at North Pole and -90° at South Pole. An example of a latitude in DMS (Degrees Minutes Seconds) format is 41°54'12"N

Longitude is the east-west geographic coordinate measurement. Longitude is given as an angular measurement ranging from 0° at the prime meridian to +180° eastward and −180° westward.
An example of a longitude in DMS (Degrees Minutes Seconds) format is 87°37'35"W

Release 12.1.1 enables GIS Integration using web based source map viewer of Google maps and provision is given to allow assets/ instances to be geocoded so that they can be spatially located on the map viewer. All item instances, i.e. EAM Assets and OAT instances are eligible to be geocoded and viewed in the Asset map viewer

Release 12.1.1 provides ability so that item instances can have a provision to capture their geocodes i.e. Latitude and Longitude. This can be done either manually through a mass data entry page or automatically through an API.

In Enterprise Assets Maintenance, users can search for any EAM assets using simple/ advanced search, enter geocodes for the assets using the 'Mass Geocode Entry' form, then locate the resulting asset on the map viewer by invoking the 'Map All' button. Alternatively, users can navigate to the Asset details page and locate the particular asset on the map viewer.

When a user selects any asset icon on the map viewer, details such as Asset Number, Description, Asset Group, Owning Department, Asset Location and Geocodes are displayed in a pop up. Also, hyperlinks are displayed for performing the following actions:
1. View asset details page
2. Create work request
3. Create work order
4. View open work requests
5. View open work orders
6. View Graphical Asset hierarchy.

When user selects any of the above actions, the page control is transferred to the appropriate tab in EAM responsibility with the context of the asset number selected. All other details corresponding to the selected asset number are defaulted when the page is rendered

Setup Steps

To enable the GIS Integration using Google Map feature, follow these instructions:

1. Set the following profile options:

• (R) System Administrator
• (N) Profile > Systems
• 'CSI: Mapviewer Name' = Google

Profile value can be set at any level.

• 'CSI: Google Registration key'

This profile hold the complete registration key (license key) for the Google Maps and can be set at any level

• 'CSI: Google Map Client ID'

This profile hold the client ID for the licensed copy of

Google Maps and can be set at any level,

Contact Google to obtain Map Registration Key and Map Client ID

In R12.1.1, 'Google' and 'Custom' are the seeded values for 'CSI: Mapviewer Name' profile option. However, more look up values might be added in future releases based on other supported map viewers. If no value is set for this profile, then it is assumed that GIS integration is not intended. If it is set to 'Google', then GIS Integration with Google map is activated. If it is set to 'Custom', then GIS Integration with custom map viewer is activated. Custom source maps usually show details to a greater extent compared to the default images provided. Custom source maps can be either made by a tool if geocodes are available or a satellite imagery can be taken. Each source map viewer supports few specific formats of the custom source maps like Oracle Spatial supports 1 or 2 ESRI formats. Custom source maps in case of Utility industry can be entire stretch of utilities with associated information

2. Associate the function 'Map All' to the responsibility meant for accessing Maintenance user's menu.

• (R) System Administrator
• (N) Application > Menu
• Query for "EAM_MAINTENANCE_UNIT_SEARCH" menu.
• Add the function 'Map All'

Associating the 'Map All' function to the responsibility will enable 'Map All' button and 'Map' button to EAM/ OAT responsibilities.

3. Enter geocodes for assets/instances manually using the 'Mass Geocode Entry' form:

• (R) Maintenance Super User responsibility
• (N) Assets > Mass Geocode Entry
• Query for an Asset Number
• Enter geaocodes for the Asset
• Save 

Note: Geocode information capture can be allowed of all item instances, both customer and enterprise owned. except for Non-serial Rebuildables, Asset Routes and Systems

Geocode API: Geocodes can be entered for assets/instances using CSI_GIS_INSTANCE_LOC_PUB. IMPORT_INSTANCE_GEO_LOCATION Import API. This will enable mass entries for goecodes and save time. This Import API has been included in csipgilb.pls & csipgils.pls and meant to populate the CSI_II_GEOLOC_INTERFACE interface table

4. View the EAM Assets on Google Map:

•   (R) Maintenance Super User
•   (N) Assets > Capital
• Query for an Asset Number
• Click 'Map All' button to locate the asset in the Google Map Viewer

Note: Function 'Map All' need to be associated to the responsibility meant for accessing Maintenance user's menu. By default, this function is not associated to any Maintenance responsibility