EBS logins geolocation tracking with Blitz Report and Excel Bing MapsBy Alexander Pavlik|December 30th, 2021| 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 [...]
EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536By 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™ outputBy 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 minutesBy 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 [...]
Hyperlinks in Blitz Report™By Artem Nesterko|August 17th, 2019| Hyperlinks can be embedded in Blitz Report excel output files using the syntax: HYPERLINK("URL to the location", "alternate text") Here is an example: select hp.party_number, 'HYPERLINK("'||case when hp.url like 'http%' then null else 'https://' end||hp.url||'","'||replace(hp.party_name,'"','""')||'")' party_name, hp.party_type from hz_parties hp where hp.url is not [...]
