EBS logins geolocation tracking with Blitz Report
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 and higher. In this post I will show how to visualize the output of such a report using Pivot table and Exc...
Updated DBA AWR Blitz Reports now work with pluggable databases
With introduction of container databases Oracle changed the way AWR data is stored and accessed. You can read about that in more detail in this article from Franck Pachot. As we used AWR data in our Diagnostic Pack reports we also had to make some adjustments due to various issues. The first issue w...
Find an IP address and geolocation of EBS clients' logins
Introduction Sometimes I see questions how to obtain an IP address for EBS logins. Before EBS it wasn't an easy task. But starting from EBS a new column "clientip" was added to fnd_logins table. So getting this information is very easy now. Many existing and potential customers connect to our EBS D...
New Release Blitz Report 3.1.8
Ten (10) new features, 50 minor enhancements/improvements Release contains a number of new features and many enhancements and improvements. We'll also cover some of the enhancements in as this was an interim maintenance release. Global multi-language support Blitz Report supports multi-languages in...
Simplifying DBA tasks with Blitz Report
I am an EBS Apps DBA. When I talk with other , 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 query from another DBA’s blog, sometimes I find something useful in a MOS Doc or a bo...
Asset tracking troubleshooting
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 ...
Bringing ASCP into a usable state
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 (PWB). ...
How to use EBS audit functionality to speed up operations
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 Ora...
Can data governance be free?
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 m...
Oracle Discoverer Replacement
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...
Does Oracle Discoverer 11g work with Oracle Database 19c?
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 19c version. Recen...
Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3
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 are looking for Discoverer replacement - Blitz Report is the right cho...
Launching EBS forms with Java Web Start on MacOS Big Sur and later
In my previous post on Java Web Start I outlined the required EBS patches and basic cofiguration for Windows end users. But after one of our partners tried to connect to our EBS demo instance from a Mac it turned out that some additional steps are required for MacOS users. So this article will help...
Could your organization lose these mission critical EBS assets?
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 a complex SQL s...
Enhancing the Blitz Report Library, committed to support and service
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 performance is incredibly ...
Hands On Tutorial - Oracle EBS - SQL to Excel Reporting for Non-developers
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 report creation process, we recently hosted an on...
Simplifying your ECC Upgrade to v7
Introduction This post describes Oracle Enterprise Command Center Framework (ECC) upgrade from versions V2 and later to V7. It is not meant to replace MOS Doc ID , which is very clear and detailed. We want to share our experience including faced errors and solutions. For installation instructions o...
Simplifying your ECC Upgrade to v6
Introduction This post describes Oracle Enterprise Command Center Framework (ECC) upgrade from versions V2 and later to V6. It is not meant to replace MOS Doc ID , which is very clear and detailed. We want to share our experience including faced errors and solutions. For installation instructions o...
How to create 220 Oracle standard EBS Excel reports in less than 5 minutes
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 Or...
Simplifying your ECC Upgrade to v5
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 , which is very clear and detailed. We want to share our experience including faced errors and solutions. For installation instructions of ECC V2 please ...
Oracle ECC administration and exports to Excel
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 ...
A more optimal Supply Chain Hub
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 ri...
Adding the advanced features to ASCP planning
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 Workbench (PWB). Often several sheets togethe...
How to create 220
