Blog

Could your organization lose these mission critical EBS assets?

By Geoff Skerrett|January 22nd, 2021|

The case for agile EBS reporting Losing a critical business asset is always hard. It shouldn’t happen. Recently, when discussing our favorite topic, “Oracle EBS Reporting”, an organization confided that they suffered a serious loss. One of their KPI reports was missing. It was [...]

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 Relevant for development or supporting consultants and business users that require fast form export to Excel without waiting for the data to be ready. Introduction The standard EBS form export is useful for small data volumes, but when you have to export large-volume [...]

How to develop proven EBS reports using Oracle Enterprise Command Center SQLs in under 5 minutes

By Glen Whelan|October 22nd, 2020|

Audience Relevant for development or supporting consultants and business users that require reports using the same query logic as ECC dashboards Introduction Oracle Enterprise Command Center Framework provides information discovery, visualization, and exploration capabilities embedded within the Oracle E-Business Suite Dashboards are provided for [...]

Oracle Enterprise Command Center Framework upgrade from V4 to V5

By Alexander Pavlik|October 13th, 2020|

Introduction This post describes Oracle Enterprise Command Center Framework (ECC) upgrade from V2-V4 to V5. It is not meant to replace MOS Doc ID 2495053.1, which is very clear and detailed. We want to share our experience including faced errors and solutions. For installation [...]

Oracle E-Business Suite 12.2.9 upgrade to version 12.2.10

By Alexander Pavlik|October 13th, 2020|

Enginatics always stays up to date with the latest technology. So right after the availability of Oracle E-Business Suite 12.2.10 was announced, our team was eager to upgrade our EBS Demo 12.2.9 instance to the latest release, so anyone can test Blitz Report™ on [...]

Asset tracking integration with Install Base and Inventory

By Glen Whelan|September 23rd, 2020|

Audience: EBS architects, consultants, and business analysts for asset planning and tracking Article Summary: Understanding the asset integrations, including the Enterprise Command Center and troubleshooting transactions with Blitz Report. Prerequisites: 1. Download and install the free version of Blitz Report, this provides full access [...]

Connect Oracle E-Business Suite to Vertica, MySQL and other non Oracle databases

By Alexander Pavlik|September 19th, 2020|

Introduction In this post I will show how to connect Blitz Report to non-Oracle databases like Vertica, MySQL, PostgreSQL using Oracle Database Gateway and Heterogeneous Services. This can be useful if your organization has information stored in databases from different vendors and you would [...]

Oracle Discoverer replacement – importing worksheets into Blitz Report™

By Alexander Pavlik|August 8th, 2020|

Task: Oracle Discoverer replacement Audience: DBA's, IT consultants and business operations Background Oracle de-supported Discoverer in 2017, which poses a significant challenge for EBS users. The Enginatics team has developed an Oracle Discoverer replacement utility with automated functionality to import Discoverer worksheets together with their [...]

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. [...]

Getting all horizontal with ASCP planning

By Glen Whelan|July 27th, 2020|

Audience: EBS architects, consultants and business analysts for advanced supply chain planning (ASCP) Making the Planner Workbench usable Many customers of the Oracle module - Advanced Supply Chain Planning (ASCP) are disappointed or just cannot get the planners to use the Planner Workbench [...]

How to use EBS audit functionality to speed up operations

By Glen Whelan|July 23rd, 2020|

Audience: Master data maintenance, support consultants and operational teams. Related blogs: Can data governance be free? How to track changes using standard audit setup Auditing data in Oracle EBS Auditors are increasingly recommending that high-risk activities be tracked and reported. While Oracle provides functionality to [...]

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! In this post we'll discuss; How to set up a basic remote database connection How to access the remote data from within a Blitz Report SQL query Performance consideration when [...]

Does Oracle Discoverer 11g work with Oracle Database 19c?

By Alexander Pavlik|July 17th, 2020|

Lately we see questions about Oracle Discoverer 11g certification with Oracle Database 19c. Oracle officially confirms that Discoverer is not tested or certified on the Oracle Database 19c. We use Discoverer for development purposes only, but were curious if it will work with the [...]

Blitz Report™ Champion – Quarterly Awards Announcement

By Geoff Skerrett|July 13th, 2020|

Quarterly Award Winners The Program We launched the Blitz Report Champion program in April 2020 to help promote the reporting and communication skills of Oracle EBS professionals. The program has always been designed to be a “win-win” – participants use Blitz Report to create [...]

Can data governance be free?

By Glen Whelan|July 3rd, 2020|

Audience: Master Data Maintenance and data governance teams and support consultants Related Blogs: How to use EBS audit functionality to speed up operations How to track changes using standard audit setup Data Governance and compliance Typically, Oracle E-Business Suite (EBS) implementations have many security, [...]

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 [...]

Introducing the project implementation and upgrade toolkit

By Glen Whelan|June 30th, 2020|

Introduction Managing EBS projects and upgrades can be a challenge at the best of times. Consulting teams with a mixture of functional and technical skills can benefit from having a ready made toolkit to take care of the project tasks such as exporting master [...]

Generate PDF of Blitz Report™ output

By Rakesh Devalapally|June 26th, 2020|

How to generate PDF of Blitz Report output? Blitz Report™ now offers a postprocessing feature that allows users to perform additional actions on the Blitz Report output files, e.g. scp them to a different server, transform them to a .pdf via external tools and [...]

Oracle Enterprise Command Center administration and enriched dashboard data export to Excel

By Glen Whelan|June 16th, 2020|

Introduction Oracle Enterprise Command Center Framework provides information discovery, visualization, and exploration capabilities embedded within the Oracle E-Business Suite Dashboards are provided for functional areas such as Supply Chain, Financials, Manufacturing and Procurement. This article provides instructions for using the EBS form-based reporting tool [...]

Ungarbling Oracle EBS Financial Accounting

By Glen Whelan|April 23rd, 2020|

Garbled Accounts Reporting in the midst of unprecedented events gives new accounting challenges for finance teams. With pressure mounting on financial officers to provide up to the minute Profit and Loss reporting; now is the time to focus on reporting. Standard Oracle reporting tools [...]

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

By Glen Whelan|April 23rd, 2020|

Introduction Creating new Oracle EBS reports with formatted Excel output can be time-consuming, especially given the complexities around BI Publisher and the necessary formatting requirements. In this article, we create an Inventory item change tracking report in less than 10 minutes. We will assign [...]

A simpler way to work with Automatic Workload Repository (AWR)

By Glen Whelan|April 21st, 2020|

Analyzing the AWR Report The Oracle Automatic Workload Repository (AWR) collects and maintains performance statistics for problem detection and self-tuning purposes.The report generated by AWR is typically large and requires significant years of experience to fully understand all aspects. The process is made harder [...]

Blitz Report Champion – Absence Visualization in Oracle EBS

By Geoff Skerrett|April 16th, 2020|

A unique solution for Oracle EBS users We are really excited to highlight one of our initial entries in the Blitz Report Champion program, showcasing creative solutions from Oracle EBS Professionals using Blitz Report. This submission is by John Keymer, an Oracle Specialist from [...]

Oracle E-Business Suite – Concurrent Request Monitoring and Alert Reporting

By Glen Whelan|April 15th, 2020|

Concurrent Request Management Critical concurrent requests should be monitored at all times to prevent problems in downstream processes. The standard method is to use Oracle Alert and email the output to the support or database teams. Other techniques involve running SQL with time based [...]

Oracle Enterprise Command Center Framework upgrade from V3 to V4

By Alexander Pavlik|April 14th, 2020|

Introduction This post describes Oracle Enterprise Command Center Framework (ECC) upgrade from V3 or V2 to V4. It is not meant to replace MOS Doc ID 2495053.1, which is very clear and detailed. We want to share our experience including faced errors and solutions. [...]

How to quickly create or modify Oracle E-Business Suite BI Publisher based reports

By Glen Whelan|April 9th, 2020|

BI publisher is used extensively in Oracle E-Business Suite. The standard Oracle design for the report layout often prevents the report from being exported to Excel in a usable format. Making changes to the displayed columns or parameters usually requires the submission of time [...]

How to replace Oracle ASCP exceptions with Blitz Report

By Glen Whelan|April 5th, 2020|

Planning by Exception The daily job of planners is responding to the endless stream of exception messages, and then working out which are important and need to be addressed immediately and or be dealt with later. This is far from easy with the standard [...]

How to add Blitz Report™ to your favorite form

By Glen Whelan|March 31st, 2020|

Adding Blitz Report to an Oracle form To optimize the user experience, it is possible to add Blitz Report to any form menu using a forms personalization. Follow the screen shots below to perform the necessary form personalization. This is generic setup and the [...]

How to create a Delivery in Full On Time metric in Oracle E-Business Suite using Blitz Report™

By Glen Whelan|March 31st, 2020|

Why measure your supply chain performance? The delivered in full on time, or DIFOT, metric quantifies the number of successfully fulfilled sales orders. It is important to monitor this metric to quantify the performance of your supply chain. There are several factors that causes [...]

Oracle E-Business Suite Inventory Period-End Optimization / Close

By Glen Whelan|March 25th, 2020|

Inventory period close - speed-up The inventory period close process can often be challenging with the volume of stuck transactions typically faced. Oracle provide a pending transactions view with mandatory recommended resolutions. Inventory is generally towards the end of the closure process, and can [...]

Oracle Supply Chain Hub that takes simplicity to another level

By Glen Whelan|March 23rd, 2020|

Objective: Inventory supply chain planning optimization Audience: IT consultants, Sales & Operations Planning, Buyers and Customer Service teams Supply Chain Hub overview A key issue faced by Oracle supply chain users is the sheer number of forms and responsibilities to navigate to reach the [...]

How to track master data changes using Oracle EBS Audit function and Blitz Report™

By Glen Whelan|March 21st, 2020|

Tracking master data changes via standard EBS Audit functionality Audience: Master data, Support Consultants, and Operational teams. Related Blogs: How to use audit functionality to speed up operations for error-free transactions Can data governance be free? This article explains the Oracle EBS system admin [...]

How to put the Advanced functions into Oracle EBS Supply Chain Planning (ASCP)

By Glen Whelan|March 17th, 2020|

The Planners Workbench (PWB) is the daily tool for the planners but it lacks the basic functions needed to make planning analysis optimal. A common problem faced by Oracle ASCP planning users, is how to export large volumes of plan data from the Planner [...]

How to Optimize Order Management form exports in Oracle EBS

By Glen Whelan|March 16th, 2020|

Exporting Order Organizer efficiently in Oracle Order Management A common challenge faced by customer service teams, is how to export large volumes of order line and header information from the Order Organizer. The Oracle Form Export function often takes several minutes and worst case, [...]

Oracle Enterprise Command Center Framework upgrade from V2 to V3

By Alexander Pavlik|October 9th, 2019|

Introduction This post describes Oracle Enterprise Command Center Framework (ECC) upgrade from V2 to V3. It is not meant to replace MOS Doc ID 2495053.1, which is very clear and detailed. We want to share our experience including faced errors and solutions. For installation [...]

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9

By Alexander Pavlik|August 30th, 2019|

Enginatics always stays up to date with the latest technology. So right after the availability of Oracle E-Business Suite 12.2.9 was announced, our team was eager to upgrade our EBS Demo 12.2.8 instance to the latest release, so anyone can test Blitz Report™ on [...]

Hyperlinks in Blitz Report™

By Rakesh Devalapally|August 17th, 2019|

Blitz Report™ now offers the capability to embed hyperlinks directly in the excel sheet while building a report. Let us show you a very simple example of this: Build a sample report with the following code and run it: select asu.vendor_id, asu.vendor_name, '=HYPERLINK("www.google.com","google")' hyperlink_column from [...]

Migration to Java Web Start in Oracle EBS 12.2 instance

By Alexander Pavlik|June 28th, 2019|

Oracle recommends Oracle E-Business Suite customers to migrate from Java Plug-In to Java Web Start technology. Java Web Start allows to run EBS forms in browsers that ended support for the Netscape Plug-in Application Programming Interface. In this post we will share our experience on [...]

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

By Alexander Pavlik|June 3rd, 2019|

Introduction This post describes Oracle Enterprise Command Center Framework (ECC) installation and configuration steps. It is not meant to replace MOS Doc ID 2495053.1, which is very good and detailed. We want to share our experience including faced errors and solutions. And good news [...]

Securing sensitive data with Oracle VPD

By Rakesh Devalapally|May 14th, 2019|

What is VPD? Virtual Private Database (VPD) is a database security feature that is built into an Oracle database server, as opposed to being part of an application that is accessing the data. The user is only allowed to see the data they have [...]

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

By Alexander Pavlik|March 22nd, 2019|

Since we recently developed automated Discoverer report migration into Blitz Report and our development team needed test environment, we had to integrate Discoverer with Oracle EBS. In this post we share our experience. Please refer to the Blitz report user guide for more information [...]

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

By Alexander Pavlik|November 22nd, 2018|

In this article different methods of getting information about applied Oracle EBS 12.2 patches are reviewed. Oracle Applications Manager Login to Oracle EBS as a user that has access to Oracle Applications Manager. For purposes of this tutorial Enginatics EBS demo instance has [...]

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8

By Alexander Pavlik|November 15th, 2018|

Enginatics always stays up to date with the latest technology. So right after Oracle E-Business Suite 12.2.8 has been reported to be available, our team was eager to upgrade our EBS Demo 12.2.7 instance to the latest release, so anyone can test Blitz Report™ [...]

Vegas, Baby! – Enginatics is showcasing Blitz Report at Collaborate 18

By Artem Nesterko|May 6th, 2018|

Over the course of four action-packed days in the entire year, more than 200 exhibitors and 5000 users attend OAUG’s COLLABORATE. They are all attending North America’s largest Oracle user conference to both network and learn from the plethora of discussed topics. Such topics [...]

Conference Planning 2018

By Andy Haack|January 11th, 2018|

The new year offers a series of events to meet us personally. We will be showcasing Blitz Report at RMOUG Training Days in Denver from the 20th - 22nd of February and the OAUG Collaborate in Las Vegas at the end of April. If you [...]

DOAG 2017 – German Oracle User Group Conference in Nuremberg

By admin|November 27th, 2017|

From November 21 to 23, 2017 Enginatics GmbH made its debut at the German Oracle User Conference and Exhibition (DOAG). The conference, held this year in Nuremberg, Germany, is considered a prestigious event among the Oracle Germany scene. Marking the 30th anniversary of this [...]

Case Study – The MYTOYS GROUP chooses Blitz Report™

By Artem Nesterko|September 10th, 2017|

The MYTOYS GROUP is one of the most successful e-commerce companies in Germany for family shopping and has been working with Oracle E-Business Suite from their first day of operation. After upgrading from version 11.5.10 to version 12.2.5 in spring 2016, myToys selected Enginatics [...]