Some time ago I wrote a post about finding an IP address and geolocation of logins to an EBS instance. It can be used to create custom Blitz Reports for Oracle E-Business Suite version 12.2.10 and higher. In this post I will show how to visualize the output of such a report using Pivot table and Excel upload features.

Enginatics EBS demo instance is used by many people across the world, so it is a good example for creating a map of logins. The FND User Login History with Geolocation report returns the city and country from which a login was performed. It is time to perform some analytics with the Blitz Report Pivot functionality.

Click on the Options field and create a new template.