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.
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.
During/shortly after Oracle AI World in Las Vegas, Oracle also released a new version of E-Business Suite EBS: Release 12.2.15!
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.
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.
Simplify HTTPS services via REST calls in Oracle using the new system: keystore – no wallet needed and DevOps-ready.
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.
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.
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.
Find out how to extend Oracle E-Business Suite Natural Language Query to custom data models for smarter, efficient decision-making.
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.
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).
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.
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.
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...
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.
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...
Discover how natural language queries simplify Oracle E-Business Suite usage, enabling complex data queries in everyday language for enhanced efficiency.
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.
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.
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.
In this blog post we will show you how to build better stop scripts for Oracle E-Business Suite.
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”.
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...
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.
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.
This series covers how to run Oracle SOA Suite on Docker.
In this final episode we will cover patching options for the environment.
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.
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.
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.
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.
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.
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.
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.
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...
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.
In this blog post we will give you an overview for Oracle E-Business Suite Workflow Mailer when migrating to Exchange Online.
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.
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.
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.
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.
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.
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.
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".
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.
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...
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.
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.
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.
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.
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.
Last week when reading through the latest Oracle Cloud Infrastructure Release Notes I ran into a new Feature named “Private DNS”.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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!
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.
Have you ever tried to "inject" another archivelog into a backup residing on OCI? See here how we managed to solve this.
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.
Have you ever wondered how to provide or call a REST service with the HTTP "PATCH" verb? Here we go...
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.