Techblog

Upgrade E-Business Suite Database to 23ai

Upgrade E-Business Suite Database to 23ai

In December 2024 Oracle certified E-Business Suite on 23ai for platforms, where the 23ai database is already available.

In this blog entry we will show you how to upgrade Oracle E-Business Suite Database to 23ai.

read more
E-Business Suite with Analytics Publisher 12c and ETCC

E-Business Suite with Analytics Publisher 12c and ETCC

Johannes MichlerExecutive Vice President – Head of Platforms & DevelopmentRecently I described in a blog post how and why you want to migrate to Analytics Publisher 12c for your Oracle E-Business Suite built-in reporting. After doing so for two different customers we...

read more
Running Oracle SOA Suite in Docker Blog Post Series

Running Oracle SOA Suite in Docker Blog Post Series

Check out the blog post series of PROMATIS expert Johannes Michler (Executive Vice President – Head of Platforms & Development) and Oracle ACE Director. Here’s a summary of these six blog posts on “Running Oracle SOA Suite in Docker”.

read more
Upgrading E-Business Suite to 12.2.14 - FND_VAULT again

Upgrading E-Business Suite to 12.2.14 - FND_VAULT again

Mid of September Oracle released the latest E-Business Suite 12.2 RUP 12.2.14.

As described in the official release notes, the new release contains tons of new functionalities in almost all application modules as well as a lot of new Enterprise Command Centers. Finally, some technical issues with Analytics Publisher 12c fonts got fixed.

read more
Patching E-Business Suite with more comfort - part 2 notifying with PuTTY

Patching E-Business Suite with more comfort - part 2 notifying with PuTTY

Every quarter Oracle releases a bunch of Critical Patch Updates that have to be applied to (often many) E-Business Suite instances.

The first part of this blog post series covered how we can easily pass the passwords to adop; in this second part I will show how notifications can be brought to your attention quickly once the patching is completed.

read more
Automating Code Signing with latest E-Business Suite Signing Improvements - Part 4

Automating Code Signing with latest E-Business Suite Signing Improvements - Part 4

Last week, Oracle released a major re-work of its article on Signing JAR Files for Oracle E-Business Suite Release 12 (Doc ID 1591073.1). Taking into consideration that all major public Code Signing CAs now require Hardware Security Module (HSM) based storage of the private key this was long awaited. In previous parts of this blog series I've covered how we can workaround the limitations of jarsigning in E-Business Suite.

In this 4th part we'll cover how this procedure can be improved by using these latest patches to E-Business Suite.

read more
Patching E-Business Suite with more comfort - Part 1 Password Passing

Patching E-Business Suite with more comfort - Part 1 Password Passing

Every quarter Oracle releases a bunch of Critical Patch Updates that have to be applied to (often many) E-Business Suite instances.

This first part of this blog post series will cover how we can easily pass the passwords to adop; in the second part I will show how notifications can be brought to your attention quickly once the patching is completed.

read more
Running Oracle SOA Suite on Docker - Part 2: Installing a docker host

Running Oracle SOA Suite on Docker - Part 2: Installing a docker host

Operating – installing and maintaining – Oracle Fusion Middleware, especially Oracle SOA Suite 12.2.1.4 is quite some work. Not only does installation itself consist of a number of steps, but each quarterly critical patch update also requires applying a number of patches and – especially in simple, single server environments quite some downtime.

read more
Running Oracle SOA Suite in Docker - Overview

Running Oracle SOA Suite in Docker - Overview

Johannes MichlerExecutive Vice President – Head of Platforms & Development Operating - installing and maintaining - Oracle Fusion Middleware, especially Oracle SOA Suite 12.2.1.4 is quite some work. Not only does installation itself consist of a number of steps, but...

read more
Accessing EBS APIs from APEX - HR_SECURITY

Accessing EBS APIs from APEX - HR_SECURITY

As you're probably aware, Oracle APEX is a great tool to extend Oracle E-Business Suite. When doing so recently for a customer where I wanted to provide a way to add lines to existing orders using the OE_ORDER_PUB API I ran into a very strange situation.

read more
Automating Code Signing with multiple E-Business Suite instances - Part 3

Automating Code Signing with multiple E-Business Suite instances - Part 3

This third part will look how we can further automate this by installing the Certum tools onto the E-Business Suite Cloud Manager VM. First, we'll cover the latest changes from Certum, then we'll look into some scripts that can be used on multiple E-Business Suite Application servers to send the .jar files for signing to that central signing instance.

read more
Solving intermittent errors with adop fs_clone on OCI File Storage Service (FSS)

Solving intermittent errors with adop fs_clone on OCI File Storage Service (FSS)

Recently for multiple customers I ran into issues while running "adop phase=fs_clone".

Analyzing the error further I realized that this is around the (rather old) version of Oracle Installer trying to find the available space on the disk. With E-Business Suite running on OCI File Storage Service (FSS) this amount of available disk storage is basically "unlimited"; df reveals 8 Exabyte of free storage.

read more
(Fully) Automating Cloning with E-Business Suite Cloud Manager REST API

(Fully) Automating Cloning with E-Business Suite Cloud Manager REST API

As you're probably aware, Oracle E-Business Suite Cloud Manager is a great tool to automate the operation of Oracle E-Business Suite.

This is especially true for cloning, e.g. creating Production-to-Test (P2T) copies. In the old days, for some of my customers it was a multi-week project to create such a P2T copy. Or alternatively, it resulted in a 50 days+ project to fully automate this with traditional infrastructure.

read more
Increasing Database Patching Performance

Increasing Database Patching Performance

Johannes MichlerExecutive Vice President – Head of Platforms & Development While applying the October 2023 Critical Patch Update (CPU) - that contains various critical fixes as can be found over there https://www.oracle.com/security-alerts/cpuoct2023.html - I realized...

read more
Monitoring Free Disk Space on Oracle E-Business Suite Instances in Oracle Cloud Infrastructure (OCI)

Monitoring Free Disk Space on Oracle E-Business Suite Instances in Oracle Cloud Infrastructure (OCI)

Oracle E-Business Suite (EBS) is a critical application that requires careful monitoring to ensure optimal performance and prevent potential disruptions. One crucial aspect of monitoring EBS instances is keeping track of free disk space. In this guide, we will explore how to effectively monitor the free disk space on Oracle E-Business Suite instances running on Oracle Cloud Infrastructure (OCI).

read more
E-Business Suite July 2023 CPU breaks OCI Load Balancer Health check

E-Business Suite July 2023 CPU breaks OCI Load Balancer Health check

On Tuesday Oracle released the quarterly security patch set, which contains a bunch of security related patches for both the Tech Stack and the Application Tier of E-Business Suite. While applying the patch for some of our customers running E-Business Suite on OCI I realized that access to the environment was no longer possible: Instead, a "502 Bad Gateway" error is shown.

read more
First impression on E-Business Suite Cloud Manager 23.1.1

First impression on E-Business Suite Cloud Manager 23.1.1

Johannes MichlerExecutive Vice President – Head of Platforms & DevelopmentThis week, the Oracle E-Business Suite on OCI team released the latest release 23.1.1 of E-Business Suite Cloud manager: “Getting Started with Oracle E-Business Suite on Oracle Cloud...

read more
wireguard into Oracle Cloud Infrastructure using docker

wireguard into Oracle Cloud Infrastructure using docker

Johannes MichlerExecutive Vice President – Head of Platforms & Development Wireguard Windows Client Connecting to OCI When setting up Oracle Cloud Infrastructure (OCI) environments, it is often helpful to have a lightweight VPN from your local machine to the newly...

read more
Migrating E-Business Suite to File Storage Service

Migrating E-Business Suite to File Storage Service

Recently, I described that starting with Release 22.2.1, the Oracle E-Business Suite Cloud Manager now supports OCI File Storage Service (FSS) besides block storage. Furthermore, the usage of FSS is mandatory for (new) multi-node environments: First Experience with E-Business Suite Cloud Manager 22.2.1

read more
Oracle Integration Cloud Hybrid integrations with Oracle Connectivity Agent

Oracle Integration Cloud Hybrid integrations with Oracle Connectivity Agent

In integration projects, it is often needed to integrate cloud applications with on-prem systems running in the clients network. In most cases, the client network is not accessible from the internet. This situation makes the task of integrating this system for a cloud integration platform, such as the Oracle Integration Cloud (OIC), almost impossible.

read more
Automating DNS Management for E-Business Suite on OCI

Automating DNS Management for E-Business Suite on OCI

When automating operations of Oracle E-Business Suite using OCI and especially Oracle Cloud Manager – which is now even easier and faster with the latest release 22.1, as described in my previous blog post –, it is often necessary to modify DNS entries.

read more
Creating a Read-Only APPS User

Creating a Read-Only APPS User

In Oracle E-Business Suite environments it is often necessary to query data. Typically, all data can be accessed through the APPS user. However, that user is highly privileged and, when in use, can easily “break things”. This is obviously a big compliance issue. Having a dedicated read-only user is thus a much better approach.

read more
Lessons learned while upgrading APEX and ORDS to 22.1

Lessons learned while upgrading APEX and ORDS to 22.1

We recently upgraded a great amount of customer instances, both on the APEX and on the ORDS layer. The general procedure for Oracle APEX is more or less unchanged in comparison to previous versions. On the ORDS layer however, the upgrade to 22.1 contains many changes. Additionally, we encountered a couple of issues, which are (along with their solutions) described below.

read more
Critical Patch Update – April 2022

Critical Patch Update – April 2022

Recently Oracle released the Critical Patch Update for April 2022.

We analyzed the security patches published and first of all: There is a lot of highly critical stuff in this quarter’s release, especially for E-Business Suite (incl. Cloud Manager -maximum CVSS base score of 9.8), Fusion Middleware (a whole bunch of 9.8 ratings with more Log4J as well).

read more
Benchmarking CPUs for Oracle E-Business Suite (Database)

Benchmarking CPUs for Oracle E-Business Suite (Database)

Together with our friends from Enginatics, we recently performed a bunch of performance benchmarks, especially of the CPU performance in the context of an Oracle E-Business Suite on various Oracle Database Releases. This blog will give an overview on the results we measured.

read more
E-Business Suite Cloud Manager 21.1.1 available

E-Business Suite Cloud Manager 21.1.1 available

Last week Oracle released the latest version of E-Business Suite “Cloud Manager” that can be used to conveniently create and manage E-Business Suite 12.1 or 12.2 environments running on Oracle Cloud Infrastructure (OCI).

read more
Latest E-Business Suite Cloud Manager 20.2.1.1

Latest E-Business Suite Cloud Manager 20.2.1.1

Oracle released a new release of the E-Business Suite last week (on April 23, to be more exact). While so far there are no official announcements in the Oracle Blog, the My Oracle Support Note describing Cloud manager (2517025.1) gives an overview of the new features – so let’s have a closer (first) look at the new release.

read more
Application Performance Monitoring on OCI

Application Performance Monitoring on OCI

At the beginning of March, Oracle released the OCI “edition” of an Application Performance Monitoring Service (APM). The service is even available free of charge for smaller applications (up to 1,000 Events per hour).

read more
Using an AVM Fritz!Box to connect to Oracle OCI IPSEC VPN

Using an AVM Fritz!Box to connect to Oracle OCI IPSEC VPN

I recently set up a new “E-Business Suite on OCI” environment for a customer. During the initial setup, the customer was not able to set up a Site-2-Site Tunnel between their on premise Data Center and the Oracle Cloud Infrastructure Data Center in Frankfurt. To make my initial setup and testing more convenient, I decided to set up a separate VPN tunnel to my own development network.

read more
Using a Raspberry Pi to connect to Oracle OCI IPSEC VPN

Using a Raspberry Pi to connect to Oracle OCI IPSEC VPN

I recently set up a new “E-Business Suite on OCI” environment for a customer. During the initial setup, the customer was not able to set up a Site-2-Site Tunnel between their on-premise Data Center and the Oracle Cloud Infrastructure Data Center in Frankfurt. To make my initial setup and testing more convenient, I decided to set up a separate VPN tunnel to my own development network. I first tried libreswan on a Raspberry Pi.

read more
Get away with that paper using SOA Suite and E-Post/Docuguide

Get away with that paper using SOA Suite and E-Post/Docuguide

A customer recently told me they would like to get away from having to print, envelope and post mark thousands of invoices manually every month. Even though we have changed their invoicing process to an electronic one for most of their customers years ago by sending out emails through Oracle SOA Suite, they still had a considerable amount of customers insisting on printed invoices delivered by post.

read more
First Hand-On Experience with Cloud Manager 20.2.1

First Hand-On Experience with Cloud Manager 20.2.1

Last week, Oracle released the latest version of E-Business Suite’s Cloud Manager tool. I took a quick look at the features and upgraded two Cloud Manager instances to the latest release. Let’s have a look at how this went.

read more
OCI I/O-Performance with E-Business Suite (Part 3/3) - LVM

OCI I/O-Performance with E-Business Suite (Part 3/3) - LVM

While moving a customer from On-Premises to Oracle Cloud Infrastructure, we recently conducted some performance testing before the final cutover. For the E-Business Suite database server, a physical box with 16 CPU cores was migrated to a VMStandard E3.Flex VM with 12 OCPU. From a CPU performance perspective, the new VM was much faster than the old box. Unfortunately, this was not the case on the I/O performance side.

read more
OCI I/O-Performance with E-Business Suite (Part 2/3)

OCI I/O-Performance with E-Business Suite (Part 2/3)

While moving a customer from On-Premises to Oracle Cloud Infrastructure, we recently conducted some performance testing before the final cutover. For the E-Business Suite database server, a physical box with 16 CPU cores was migrated to a VMStandard E3.Flex VM with 12 OCPU. From a CPU performance perspective, the new VM was much faster than the old box. Unfortunately, this was not the case on the I/O performance side.

read more
OCI I/O-Performance with E-Business Suite (Part 1/3)

OCI I/O-Performance with E-Business Suite (Part 1/3)

While moving a customer from On-Premises to Oracle Cloud Infrastructure, we recently conducted some performance testing before the final cutover. For the E-Business Suite database server, a physical box with 16 CPU cores was migrated to a VMStandard E3.Flex VM with 12 OCPU.

read more
Private DNS

Private DNS

Last week when reading through the latest Oracle Cloud Infrastructure Release Notes I ran into a new Feature named “Private DNS”.

read more
SOA Suite 12.2.1.4 on Oracle Cloud Infrastructure (OCI)

SOA Suite 12.2.1.4 on Oracle Cloud Infrastructure (OCI)

Recently we have seen a lot of our customers implementing Oracle SOA Suite on Oracle Cloud Infrastructure - some upgrading from earlier releases of the SOA Suite, others doing a new implementation of an integration platform based on SOA Suite. This blog will have a look at typical customer situations and how we brought them onto a new SOA integration platform on OCI from a high level perspective.

read more
Backing up E-Business Suite instances on OCI

Backing up E-Business Suite instances on OCI

Johannes MichlerSenior Vice President – Head of Platforms & DevelopmentOracle Cloud Infrastructure (OCI) is used by many of our customers to run their Oracle E-Business Suite workload. Especially when not just running development and testing systems on OCI obviously...

read more
Using latest flexible OCI E3 shape with E-Business Suite on OCI

Using latest flexible OCI E3 shape with E-Business Suite on OCI

Recently Oracle announced the availability of a new CPU shape E3. Flex in its Oracle Cloud Infrastructure - see here. The announcement promises an increase in performance of around 50% compared to the current Intel CPU (e.g. in VMStandard2.x) at the same cost. Reason enough for me to take a closer look at this in the area of operating the E-Business Suite on such instances.

read more
Moving Oracle Configurator Development Environment to a new P2T-Copy (on OCI)

Moving Oracle Configurator Development Environment to a new P2T-Copy (on OCI)

When using the Oracle Configurator of Oracle E-Business Suite usually a dedicated “development” environment is used to create and update the configuration models. From this Configurator Development environment the configuration projects (called models) can be published to different E-Business Suite instances – usually first to a testing and then to the production environment.

read more
E-Business Suite Cloud Manager 20.1.1 available

E-Business Suite Cloud Manager 20.1.1 available

Johannes MichlerSenior Vice President – Head of Platforms & DevelopmentOracle recently released version 20.1.1 of the E-Business Suite Cloud Manager – see their blog https://blogs.oracle.com. The main new feature of this release is support for the Oracle Database 19c....

read more
Horus Business Modeler and Horus 3.0 are now certified on Oracle Autonomous Cloud

Horus Business Modeler and Horus 3.0 are now certified on Oracle Autonomous Cloud

The business process management tool Horus Business Modeler as well as the new Tool Horus 3.0, which is currently in development by our friends and partners @Horus, are now both certified to run on an Oracle Autonomous Database Cloud instance. This comes in handy if you do not have a spare database instance or if you do not want to perform the management of an ordinary (Oracle) Database.

read more
Some notes on licensing EBS@OCI

Some notes on licensing EBS@OCI

When doing my OCI Architect Associate certification it came to my mind that I never wrote anything on licensing on my blog - probably since this is a technical blog and I don’t want to deal with legal topics. Nevertheless I think it makes sense to write some basics on licensing E-Business Suite on OCI and cover two aspects a bit more in detail. Note: I'm not a lawyer, so please take this post just as a overview and refer to your license contracts for binding information!

read more