Enginatics Blog

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 1 Introduction 2 Benefits 2.1 Reports available 2.2 Further articles 2.3 Pre-requisites 3 Functional setup 4 Summary 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. 1 [...]

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

By Glen Whelan|October 22nd, 2020|

Audience 1 Introduction 2 Benefits 2.1 Reports available 2.2 Further articles 2.3 Pre-requisites 3 Enterprise Command Center query import 4 Import button and report creation 5 Summary Audience Relevant for development or supporting consultants and business users that require reports using the same query [...]

Oracle Enterprise Command Center Framework upgrade to V5

By Alexander Pavlik|October 13th, 2020|

Introduction 1 References 2 Requirements 2.1 Supported OS versions 2.2 Required OS resources 3 Perform backups 3.1 Shutdown ECC 3.2 Compress ECC installation directory 3.3 Export Oracle Enterprise Command Center Framework Schema 3.4 Startup ECC 4 Run upgrade script 4.1 Verify the upgrade 5 [...]

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|

About Oracle Asset Tracking 1 Oracle Installed Base integration 1.1 Asset Processing 1.2 Asset Processing Options 2 Identifying asset processing errors 2.1 How to find out the root cause of the pending transactions? 3 Enterprise Command Center - Asset Tracking reports 4 User report [...]

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

By Alexander Pavlik|September 19th, 2020|

Introduction 1 Install Oracle Database Gateway for ODBC 1.1 Reference 1.2 Download Gateway Installer 1.3 Install Gateway 1.4 Create a Gateway Environment File 2 Install the unixODBC Driver Manager on the Gateway Server 3 Configure Connection to a Vertica Database 3.1 Importing a Vertica [...]

Oracle Discoverer replacement – importing worksheets into Blitz Report™

By Glen Whelan|August 8th, 2020|

Task: Oracle Discoverer replacement Audience: DBA's, IT consultants and business operations Background 1 Customers Facing Oracle Discoverer Replacement Challenges 2 Discoverer Analytical Reports 2.1 Here's an Example for the Business Areas 3 Import Procedure 3.1 Discoverer Worksheet Import Option 3.2 Mass Import Using [...]

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 1 Planner Workbench Reports 2 A better way to review the Horizontal Plan 3 Planning by Exception 4 User report layouts 5 Pegging report example 6 [...]

Previous 4 567 8 Next