Blitz Report™

Find an IP address and geolocation of EBS clients’ logins

By Alexander Pavlik|October 8th, 2021|

Introduction 1 Setup 1.1 Choosing a geolocation API 1.2 Configuring http requests from Oracle Database 1.2.1 Create a new Access Control Entry (ACE) 1.2.2 Obtain the geolocation API website certificate 1.2.3 Import the certificate into an Oracle Wallet 2 Create a geolocation function 3 [...]

Simplifying DBA tasks with Blitz Report

By Alexander Pavlik|January 11th, 2021|

I am an EBS Apps DBA. When I talk with other DBA.s, it is clear that every one of us EBS DBAs has their own set of cool queries helping us complete our day-to-day tasks. I have such a toolkit too. Sometimes I borrow a [...]

Enhancing the Blitz Report™ library: commitment to service and support

By Geoff Skerrett|December 23rd, 2020|

Team commitment to service and support Blitz Report has a number of great features that help our EBS customers get the answers they need to make better decisions more quickly. Features like delivering the required data as native Excel files, reduced processing overhead so [...]

Hands-on tutorial – Oracle EBS – SQL to Excel reporting for non-developers

By Geoff Skerrett|December 14th, 2020|

Hands On Tutorial Many Oracle EBS end users are intimidated by the thought of creating their own reports. At the same time, users are often frustrated about having to wait for their IT team to fulfill their requests. In order to help demystify the [...]

How to seamlessly integrate reports into EBS forms using Zoom

By Glen Whelan|October 27th, 2020|

Audience 1 Introduction 2 Benefits 2.1 Reports available 2.2 Further articles 2.3 Pre-requisites 3 Functional setup 4 Summary Audience Relevant for development or supporting consultants and business users that require fast form export to Excel without waiting for the data to be ready. 1 [...]

EBS SQL to Excel reporting with Blitz Report for non-developers

By Geoff Skerrett|July 28th, 2020|

Getting Started with Blitz Report for non-developers We recently hosted a webinar with OATUG that was designed to introduce Oracle EBS users to Blitz Report for non-developers and the power of using SQL to get the answers they needed from their EBS data into Excel. [...]

Accessing external data sources with Blitz Report™

By Geoff Skerrett|July 21st, 2020|

Can I access external databases with Blitz Report? The short answer: Yes you can! 1 Creating a Remote Database Connection - Database Links 2 Accessing Data Through a Database Link 3 Performance Considerations 4 SQL Query from Remote Tables or Functions Only 5 SQL [...]

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

By Alexander Pavlik|July 1st, 2020|

We have seen many questions how to generate BI Publisher XLSX output in EBS 12.1.3 using Excel templates. Here are the examples: Link1, Link2, Link3, Link4, Link5, Link6, Link7 The following MOS Documents confirms that it's not possible generate an XLSX output in Oracle [...]

Generate PDF of Blitz Report™ output

By Glen Whelan|June 26th, 2020|

How to generate PDF of Blitz Report output? 1 Install Libre Office 1.1 Uninstall the previous version of Libre Office 1.2 Download and install Libre Office for Linux 2 Post Processing template setup 3 Test your Report 4 Optional - Enable Excel cell borders 5 [...]

Discover the secret of perfectly formatted Oracle EBS Excel report creation in under 10 minutes

By Glen Whelan|April 23rd, 2020|

Introduction 1 Steps 2 Blitz Report Installation 3 Development Process 4 Assignments 5 User Layouts 5.1 Concurrent Scheduling and Emailing of Output 5.2 Example Output 6 Summary Introduction Creating new Oracle EBS reports with formatted Excel output can be time-consuming, especially given the complexities [...]

Previous 123 Next