A more optimal way to work with Automatic Workload Repository (AWR)

By |2020-05-28T19:07:44+02:00April 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 |2020-05-07T07:43:26+02:00April 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 [...]

How to replace Oracle ASCP exceptions with Blitz Report

By |2020-05-28T19:13:56+02:00April 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 |2020-05-07T07:46:36+02:00March 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 [...]

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

By |2020-05-28T19:20:39+02:00March 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 |2020-05-28T19:20:33+02:00March 23rd, 2020|

Supply Chain Hub overview At Enginatics, we believe that inventory supply planning should be supported by intuitive tools that allow the handling of large amounts of supply chain data with the ability to analyse order backlog and take actions in a more optimal way. [...]

How to Optimize Order Management form exports in Oracle EBS

By |2020-05-28T19:20:28+02:00March 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 |2020-05-25T05:14:32+02:00October 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 |2020-03-18T20:35:32+01:00August 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 |2020-03-18T20:35:56+01:00August 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 |2020-03-18T20:36:42+01:00June 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 [...]

Securing sensitive data with Oracle VPD

By |2020-05-08T10:42:02+02:00May 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 [...]

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

By |2020-03-18T20:40:25+01:00November 22nd, 2018|

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

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8

By |2020-04-18T20:38:19+02:00November 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™ [...]

Conference Planning 2018

By |2019-10-16T15:44:35+02:00January 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 |2019-10-16T15:44:42+02:00November 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 |2019-10-16T15:44:49+02:00September 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 [...]

SAOUG-Connect Africa 2017

By |2019-10-16T15:44:59+02:00August 25th, 2017|

Our MD Andy Haack attended SAOUG-Connect Africa 2017 where he explained how to analyze and tune an Oracle E-Business Suite system using the free DBA Blitz Reports. Watch the presentation below or download the slides here.