Home › Discussions › Questions & Answers › EBS logins geolocation tracking with Blitz Report and Excel Bing Maps

EBS logins geolocation tracking with Blitz Report and Excel Bing Maps

Avatar photoCustomer November 21, 2019 at 7:29 am

We need a visual, map-based representation of where our users are logging into Oracle EBS from, specifically targeting suspicious logins. We know Blitz Report can find the IP address and geolocation, but how do we turn that raw data into an actionable visual map?

Viewing 6 reply threads
  • Author
    Replies
    • Support November 22, 2019 at 3:18 pm  

      This is an excellent application of Blitz Report’s visualization capabilities. You start by running a custom Blitz Report designed to find the IP address and inferred geolocation of client logins by querying the relevant EBS tables. This report is functional for Oracle E-Business Suite version 12.2.10 and higher.

    • Avatar photoCustomer November 23, 2019 at 12:03 pm  

      Once the report generates the Excel file containing the IP and geographical coordinates, what are the next steps within Excel to create the map visualization?

    • Support November 24, 2019 at 8:08 am  

      Because the output is native Excel, you can use built-in visualization features. You integrate the extracted geolocation data directly with a Pivot table and then leverage features like Excel Bing Maps. This combination allows you to transform the raw login data into an easily digestible visual map.

    • Avatar photoCustomer November 25, 2019 at 7:02 pm  

      Does this visualization process need to be set up manually every time the report is run, or can it be automated?

    • Support November 27, 2019 at 3:36 am  

      The workflow is designed for automation. Once the initial steps were completed to set up the report with the map, the map visualization will be refreshed automatically upon the subsequent report runs. This creates a constantly updated security monitoring dashboard right within the familiar Excel interface.

    • Avatar photoCustomer November 29, 2019 at 2:59 am  

      Is this a feature primarily used by Oracle Apps DBAs, given the data source involves session details?

    • Support November 30, 2019 at 3:23 pm  

      Yes, this functionality is a powerful addition to the Oracle EBS DBA toolkit. It allows them to quickly execute and save a custom report using the SQL that queries session information, enhancing system security monitoring without having to access the database command line.

  • Author
    Replies
Viewing 6 reply threads
  • You must be logged in to reply to this post.

Login with:
Popular Posts
How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123744

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 19789

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14609

How to check if a patch is applied in Oracle EBS 12.2 14383

Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3 14071

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11963

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9897

Migration to Java Web Start in Oracle EBS 12.2 instance 9890

Securing sensitive data with Oracle VPD 7793

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6446

Blog Archive
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
Recent Events
2026
2025
2024
2023
2022
2021
2020
2019
2018