By Glen Whelan|2020-05-07T07:44:48+02:00April 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 [...]
By Glen Whelan|2020-05-28T18:59:53+02:00April 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 [...]
By Glen Whelan|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 [...]
By Geoff Skerrett|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 [...]
By Glen Whelan|2020-05-28T19:09:34+02:00April 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 [...]
By Alexander Pavlik|2020-05-28T19:10:56+02:00April 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. [...]
By Glen Whelan|2020-05-28T19:12:09+02:00April 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 [...]
By Glen Whelan|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 [...]
By Glen Whelan|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 [...]
By Glen Whelan|2020-05-28T19:20:47+02:00March 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 [...]
By Glen Whelan|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 [...]
By Glen Whelan|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. [...]
By Glen Whelan|2020-05-28T19:20:30+02:00March 21st, 2020|
Tracking master data changes via standard EBS Audit functionality This article explains the Oracle EBS system admin setup required to implement Audit track changes to supplier or bank tables. Additionally, we cover the limitations of the standard Audit reporting, e.g. how to readily evaluate [...]
By Glen Whelan|2020-05-28T19:20:21+02:00March 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 [...]
By Glen Whelan|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, [...]
By Alexander Pavlik|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 [...]
By Alexander Pavlik|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 [...]
By Rakesh Devalapally|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 [...]
By Alexander Pavlik|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 [...]
By Alexander Pavlik|2020-05-25T05:14:04+02:00June 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 [...]
By Rakesh Devalapally|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 [...]
By Alexander Pavlik|2020-05-25T05:01:47+02:00March 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. If you're looking for Oracle Discoverer replacement, please consider Blitz Report. [...]
By Alexander Pavlik|2020-05-31T19:14:34+02:00January 12th, 2019|
After the news that Oracle Discoverer support had ended, the Enginatics team was working on a solution to help EBS customers migrating their Discoverer reports automatically into Blitz Report. And now it's ready! The new Blitz Report's Discoverer report import feature allows automated migration of [...]
By Alexander Pavlik|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 [...]
By Alexander Pavlik|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™ [...]
By Artem Nesterko|2019-10-16T15:44:29+02:00May 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 [...]
By Andy Haack|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 [...]
By admin|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 [...]
By Artem Nesterko|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 [...]
By admin|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.
