Automating Multi-Domain Let's Encrypt Certificates with OCI – learn how to validate SAN domains via HTTP-01, Object Storage, and dynamic security for full automation.
Techblog
Bulletproof EBS on OCI (Episode 4/4)
In the finale of our series on securing E-Business Suite, we are stepping out of the pure OCI bubble. Many of our customers operate in a Hybrid reality - keeping their primary EBS instance on-premise while looking to the cloud for Disaster Recovery (DR) and (ransomware) protection.
Bulletproof EBS on OCI (Episode 3/4)
Learn how to secure immutable, ransomware-proof Oracle EBS backups on OCI when running the database on a standard Compute instance, without Base DB Service.
Google Gemini Now Live in Oracle OCI Frankfurt: Powering Enterprise AI Across the European Union
Earlier this week (January 21), Oracle officially enabled Google Gemini 2.5 endpoints in the Frankfurt (Germany Central) region.
The Missing Manual: Downloading Oracle Patches from the Command Line (replacing the lost wget.sh)
If you are an Oracle DBA or System Administrator, you probably remember the "good old days." You'd find a patch on My Oracle Support (MOS), click a button that said "Wget Options," and Oracle would generate a handy, pre-authenticated wget.sh script for you. You’d copy it to your server, run it, and walk away.
Bulletproof EBS on OCI (Episode 2/4)
In this second episode, we detail the actual "Broadpin Fire Drill" – the technical process of restoring this immutable environment to a clean subnet to prove our Disaster Recovery (DR) capability. In this scenario we restored to a dedicated, highly isolated restore-subnet that has only very limited connectivity.
Bulletproof EBS on OCI (Episode 1/4)
This article introduces our fortress‑style approach to creating immutable backups for Oracle E‑Business Suite on OCI. We break down how to protect EBS environments from ransomware by designing backup architectures that cannot be modified or deleted – even with admin access. Episode 1 outlines the strategy and foundational setup behind truly tamper‑proof backups.
Migrating Oracle Content & Experience (CEC) to WebCenter Content (WCC)
With the End of Life (EoL) for Oracle Content and Experience (CEC) set for December 31, 2025, organizations face a critical deadline. This guide outlines the strategic imperative for migration, emphasizes the urgency of data extraction, and details the technical steps required to transition to Oracle WebCenter Content (WCC) on OCI.
Migrating to Oracle SQLcl 25.3 (with JavaScript)
In a bunch of Broadpin customer projects we're leveraging Oracle SQLcl in combination with JavaScript to implement DevOps pipelines.
With the recent SQLcl 25.3 release this caused us a bunch of issues – here are our workarounds should you run into similar trouble.
New version of NLQ for E-Business Suite
Last week, in addition to publishing E-Business Suite EBS 12.2.15 and Enterprise Command Centers ECC v15, a new version of the "Enabling Natural Language Query of Oracle E-Business Suite Release 12.2, Leveraging OCI Generative AI" solution was released.
E-Business Suite 12.2.15 - Installation Experience
During/shortly after Oracle AI World in Las Vegas, Oracle also released a new version of E-Business Suite EBS: Release 12.2.15!
Secure Your Patch Future: The Technical Path to Oracle Linux 8 for E-Business Suite (on OCI)
Upgrade Oracle E-Business Suite Apps and DB Tier from Oracle Linux 7 (OL7) to OL8 using leapp for self-managed environments on Oracle compute nodes.
Oracle EBS Cloud Manager Release 25.2.0 - DR but a big "but be aware"
A new Oracle EBS Cloud Manager Release 25.2.0 is now available, introducing significant enhancements for disaster recovery. This update provides robust support for Oracle E-Business Suite 12.2 environments with Oracle Database 19c on Base DB Systems in the Commercial Cloud.
Accessing HTTPS Services via REST Calls in Oracle: From Wallets to the system: Keystore
Simplify HTTPS services via REST calls in Oracle using the new system: keystore – no wallet needed and DevOps-ready.
Why You Should Upgrade from Oracle Linux 7 to 8 With Oracle CPUs of April 2025
Let’s talk about why upgrading from OL7 to OL8 should now be a top priority – and how tools like Leapp can make it less painful than you might think.
Build a Secure Oracle APEX App with Microsoft Azure AD Login and Delegated Calendar Access
Learn how to build a secure Oracle APEX app with Azure AD login and least-privilege access to Microsoft 365 calendars via Microsoft Graph API.
Docker Compose for Oracle SOA Suite
In a recent blog series, we explored how to run Oracle SOA Suite in Docker environments in general, and later how things change with SOA Suite 14c. During a recent PROMATIS customer project, where multiple SOA instances had to be started and stopped regularly, I took a closer look at Docker Compose to automate and streamline the entire process even further.
Extending E-Business Suite Natural Language Query (NLQ) to Support Custom Data Models
Find out how to extend Oracle E-Business Suite Natural Language Query to custom data models for smarter, efficient decision-making.
Automating Deployment of SOA Suite with OCI Marketplace image
Let's have a look how you can provision such SOA instances in a fully automated way as we've done as part of a moving E-Business Suite and SOA Suite to OCI project for one of our PROMATIS customers.
Running E-Business Suite "Select AI" (NLQ) on-premises
Learn how to set up an on-premises system for internal demos where you can deploy and integrate a local AI-powered database (DMBS Select AI).
Solving issues with new E-Business Suite APEX integration for existing users
Find out how to overcome issues while implementing E-Business Suite to Oracle APEX extension when running an adop cycle after running the ADAPEXSCHREG.sql.
Restoring a single table from a OCI Cloud Manager backup
In this blog post we will show you how to restore a single table from a OCI Cloud Manager backup in Oracle E-Business Suite.
Migrating E-Business Suite with Cloud Manager to a private subnet
Johannes MichlerExecutive Vice President – Head of Platforms & Development Sometimes during the initial setup of E-Business Suite on OCI the setup is done with a public load balancer subnet for both the Cloud Manager web interface as well as the E-Business Suite...
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.
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...
EBS Natural Language Query – Ask your E-Business Suite anything with AI
Discover how natural language queries simplify Oracle E-Business Suite usage, enabling complex data queries in everyday language for enhanced efficiency.
SOA Suite on Docker - 14c edition
In this article learn how to get a SOA Suite 14c up and running on Windows with the Windows Subsystem for Linux v2 within 10 Minutes.
Preparing for DB 23ai: Modifying the parameter _pdb_name_case_sensitive
In this blog article we'll show you how to prepare Oracle E-Business Suite (EBS) for DB 23ai by modifying the parameter _pdb_name_case_sensitive.
Hello-World from Llama 3.1 GenAI with OCI and LangChain
This first blog post shows how to use a Google Colab Python notebook with LangChain to leverage the model running in the Chicago region of OCI.
Building better stop scripts for Oracle E-Business Suite - gracefully stopping managers
In this blog post we will show you how to build better stop scripts for Oracle E-Business Suite.
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”.
Upgrading E-Business Suite 12.2 to use Analytics Publisher 12c
Johannes MichlerExecutive Vice President – Head of Platforms & DevelopmentFor almost a year already, it has been possible to change the document generation engine of an Oracle E-Business Suite 12.2 instance from BI Publisher 10g to Analytics Publisher 12c. Since so...
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.
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.
Running Oracle SOA Suite on Docker - Part 6: Patching
This series covers how to run Oracle SOA Suite on Docker.
In this final episode we will cover patching options for the environment.
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.
Running Oracle SOA Suite on Docker - Part 5: Interactively Creating Repository (RCU) and Domain
This blog post series will cover how to run Oracle Fusion Middleware - especially Oracle SOA Suite on Docker. In this 5th episode I'll demonstrate an alternative and show how the graphical RCU and config utility can be used within docker.
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.
Running Oracle SOA Suite on Docker - Part 4: (Quick-)starting an environment
This series covers how to run Oracle SOA Suite on Docker. This 4th shows you how to quickly create a metadata repository, configure and then start a SOA Suite environment in a headless mode.
Connect from OIC to OCI Database with private endpoint
In this blog post we cover how to connect from Oracle Cloud Infrastructure (OCI) to Oracle Integration Cloud (OIC) Database by using a private endpoint.
Running Oracle SOA Suite on Docker - Part 3: Starting a database
This series covers how to run Oracle Fusion Middleware on Docker. This third shows you how to provision an Oracle Database instance to hold the meta data of Oracle SOA Suite.
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.
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...
Migrating to Exchange Online - Overview for Oracle SOA Suite
In this article we'll show you how to create an OAuth-Sign-In Flow after migrating from MS Exchange on Premise to Exchange online.
Migrating to Exchange Online - Overview for Oracle E-Business Suite Workflow Mailer
In this blog post we will give you an overview for Oracle E-Business Suite Workflow Mailer when migrating to Exchange Online.
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.
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.
Accessing E-Business Suite Cloud Manager APIs - IDCS Token Management
In a previous post, we got hold of a "OAuth Bearer Token" that is needed to call those APIs in a very manual way "through the browser". In real life, this does not really come in handy. This blog post will describe how a bearer token (including a refresh token) can be received through the command line.
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.
(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.
Accessing SYS, EBS_SYSTEM, APPS and weblogic password in Cloud Manager Post-Clone scripts
Oracle E-Business Suite Cloud Manager provides a powerful way to run and manage E-Business Suite environments on Oracle Cloud Infrastructure OCI.
While the tooling covers many parts of the usual cloning steps, it is sometimes necessary to add some "custom stuff", e.g. modifying the ALLORACLE password, registering monitoring solutions, pausing some concurrent requests and so on.
Solving issues with Weblogic-Password change of Cloud Manager 23.3.1
This week, Oracle released the version 23.3.1 of Cloud Manager.
The new release finally provides the possibility to change the apps, ebs_system and weblogic password during cloning. This is great, and for most of my customers it works "out-of-the box".
New E-Business Suite Cloud Manager Release 23.3.1
I've just realized, that Oracle today released Cloud Manager release 23.3.1. I'll give you a first overview of new features I've discovered at first glance.
First Experience with E-Business Suite 12.2.13 / ECC V11 Upgrade
Johannes MichlerExecutive Vice President – Head of Platforms & Development Last week, I've upgraded the E-Business Suite of a first customer to the latest E-Business Suite RUP 12.2.13, Enterprise Command Centers V11 as well as Database 19.21. A comprehensive list of...
Signing E-Business Suite / Forms Java Applets using a Cloud based Code Signing Certificate - Part 1
As you're probably aware by now, since June 1st 2023 all well-known / public Certificate Authorities (CA) no longer provide Code Signing Certificates using pure software based private keys.
Since I prefer using such a trusted / public CA to sign Java Applets (that are still crucial for Oracle E-Business Suite or Oracle Forms), I've recently had a look into how we can now sign those Java JAR files.
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.
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.
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.
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.
Private DNS
Last week when reading through the latest Oracle Cloud Infrastructure Release Notes I ran into a new Feature named “Private DNS”.
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.
Checking for E-Business Suite 12.2 Online Patching Readiness in BI Publisher Data Templates
When upgrading Oracle E-Business Suite from Release 12.1 (or earlier) to 12.2.X one of the first steps to perform is to make sure that all custom development does not violate Online Patching prerequisites.
Latest E-Business Suite Cloud Manager 20.1.1.1 Improvements
Recently Oracle released version 20.1.1.1 of E-Business Suite Cloud Manager. What seems to be a very small step in the version number brings a lot of improvements based on Enhancement Requests I've created in the past years.
Backing up E-Business Suite instances on OCI
Oracle Cloud Infrastructure (OCI) is used by many of our customers to run their Oracle E-Business Suite workload. This needs a solid concept for backing up (and restoring) the environment in the event of a disaster – be it user or system errors.
Quickstart to running E-Business Suite on OCI with Terraform
When recently bringing one of our customers to Oracle Cloud Infrastructure (OCI) with their Oracle E-Business Suite Environment I quickly scrolled through the latest My Oracle Support Note 2434500.1, describing the procedure – mainly looking for changes.
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.
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.
E-Business Suite Cloud Manager 20.1.1 available
Oracle recently released version 20.1.1 of the E-Business Suite Cloud Manager. The main new feature of this release is support for the Oracle Database 19c.
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.
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!
Monitoring and Managing EBS@OCI environments with Cloud Control
The Oracle E-Business Suite Cloud Manager provides only very basic management and no monitoring functions for E-Business Suite environments: essentially for creating, restoring, deleting and backing up the environment. The underlying hosts (including storage and network) can also be conveniently monitored with the OCI console. However, when it comes to the application (and especially database) itself, these tools do not really help. This is where Oracle Cloud Control comes into play - as it was on premise as well. This article describes how easy it is to setup a Cloud Control environment on OCI and to connect all E-Business Suite Apps- and DB-Tiers to it.
RMAN: Manually cataloging a file from OCI object storage
Have you ever tried to "inject" another archivelog into a backup residing on OCI? See here how we managed to solve this.
Building a minimal Progressive Web App (PWA) on Autonomous APEX
Recently my colleague Yves Chassein and myself setup a small Proof of Concept on how to implement a Progressive Web App (PWA) on top of the Autonomous Database (ATP) and APEX.
HTTP PATCH using Oracle SOA Suite
Have you ever wondered how to provide or call a REST service with the HTTP "PATCH" verb? Here we go...
Experiences while Upgrading to E-Business Suite Cloud Manager 19.3.1(.1)
Oracle recently made the release 19.3.1 available. For one of our customer using E-Business Suite on Oracle Cloud Infrastructure (OCI) I just upgraded to this latest release. This post gives an overview on the experiences seen.





