Enginatics Blog

Installing Oracle Discoverer Administrator and Desktop on 64-bit Windows

By Andy Haack|August 17th, 2026|

Oracle's Discoverer Administrator and Desktop client is still required to export workbooks from an existing End User Layer, but its 32-bit installer fails in a non-obvious way on 64-bit Windows. This post covers the installation and the errors that stop it.

AI Skills for Blitz Report in Excel

By Ashish Saklani|July 20th, 2026|

A free library of Blitz Report skills that drive the Blitz Report Excel add-in conversationally through Claude for Excel — period-close readiness, subledger reconciliation, duplicate-payment recovery, collections and more. Download and import them into Claude.

Creating a read-only apps_query database user for Oracle EBS

By Andy Haack|May 9th, 2026|

Audience: Oracle EBS DBAs, developers, and consultants Introduction 1 The script 2 Why the logon trigger matters 3 The R12.2.x editioning trap 4 Does current_schema=apps grant additional access? 5 Granted privileges explained Introduction Almost every Oracle EBS site eventually needs a read-only database account — [...]

Discoverer replacement with Blitz Report

By Andy Haack|March 24th, 2026|

Introduction 1 Discoverer analysis 1.1 Worksheet execution history 1.2 Workbook consolidation 1.3 Blitz Report license estimate 2 Migration process 2.1 Generate export commands 2.2 Execute export commands 2.3 Create ZIP file 2.4 Configure EUL (if applicable) 2.5 Upload ZIP to Blitz Report 2.6 Select [...]

How to configure hugepages for Oracle EBS

By Andy Haack|March 18th, 2026|

1 Stop EBS applications 2 Calculate the number of required hugepages 3 Update /etc/sysctl.conf 4 Update the limits configuration file 5 Check/change the parameter to force the instance to use large pages 6 Set the SGA parameters 7 Restart the database in open mode [...]

Upgrading Oracle Apex on Windows

By Alexander Pavlik|February 26th, 2026|

Introduction 1 Prerequisites 2 Check the Current Apex Version 3 Stop Tomcat 4 Download the Latest Apex and Patch Set Bundle 5 Unzip Apex 6 Run Upgrade Script 7 Recheck the Upgraded Apex Version 8 Copy Images 9 Apply the Latest Bundle Patch 37366599 [...]

Standalone ORDS installation

By Alexander Pavlik|February 20th, 2026|

IntroductionPlatform certification1 Test environment2 Install Java 173 Install ORDS3.1 Create ords config and logs directories3.2 Create an environment file3.3 Create a self signed certificate3.4 Convert the private key to DER format3.5 Apply the environment file3.6 Run the ords installer4 Create ORDS startup and shutdown scripts5 [...]

Upgrading an Oracle E-Business Suite server from Oracle Linux 7 to Oracle Linux 8

By Alexander Pavlik|August 5th, 2025|

Introduction 1 References 2 Test environment details 3 Take a backup 4 Apply the required EBS patches 4.1 Apply FMW Patch (Oracle Linux 8, RHEL 8 and SLES 15 only) 4.2 Apply Oracle Web Tier Pre-install check patch (Oracle Linux 8, RHEL 8, SLES [...]

How to clear the Oracle EBS cache in a script

By Alexander Pavlik|June 11th, 2025|

Introduction 1 Clearing the Cache from the Backend 2 Conclusion Introduction In Oracle EBS 12.1 and 12.2 cache is cleared according to the following document: How To Clear The Cache Using Functional Administrator? (Doc ID 759038.1) Functional Administrator>Home>Core Services>Caching Framework>Global Configuration>Clear All Cache But [...]

Sending files from Linux to SharePoint online using a Python script

By Alexander Pavlik|April 17th, 2025|

Introduction 1 Install python 1.1 Create a test python script 2 Identify the target Sharepoint document library 3 Create an app registration 4 Create API permissions 5 A python script for uploading files to sharepoint Introduction Blitz Report is primarilly installed in Linux systems. [...]

Previous 123 4 Next