Oracle E-Business Suite

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 [...]

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 [...]

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 [...]

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536

By Alexander Pavlik|July 1st, 2020|

We have seen many questions how to generate BI Publisher XLSX output in EBS 12.1.3 using Excel templates. Here are the examples: Link1, Link2, Link3, Link4, Link5, Link6, Link7 The following MOS Documents confirms that it's not possible generate an XLSX output in Oracle [...]

Oracle E-Business Suite – concurrent request monitoring and alert reporting

By Glen Whelan|April 15th, 2020|

Concurrent Request Management1 Blitz Report - FND Concurrent Requests2 Blitz Report Output and Scheduling3 Evaluation of Blitz ReportConcurrent 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 [...]

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9

By Alexander Pavlik|August 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 [...]

Migration to Java Web Start in Oracle EBS 12.2 instance

By Alexander Pavlik|June 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 on [...]

Securing sensitive data with Oracle VPD

By Artem Nesterko|May 14th, 2019|

What is VPD? 1 Why VPD? 1.1 Scalability 1.2 Simplicity 1.3 Security 2 How does VPD work? 3 Securing HR data 3.1 Example 1: Row Level VPD 3.2 Example 2: Column Level VPD 3.3 Securing data while using Blitz Report 4 Which data to [...]

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

By Alexander Pavlik|November 22nd, 2018|

In this article different methods of getting information about applied Oracle EBS 12.2 patches are reviewed. 1 Oracle Applications Manager 2 Database Query 2.1 Query Parameters 2.2 Improving the Query 3 Blitz Report 4 Older EBS Versions 5 Conclusion 1 Oracle Applications Manager [...]

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8

By Alexander Pavlik|November 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™ [...]

Previous 12