In this blog post we will show you how to build better stop scripts for Oracle E-Business Suite.
Johannes Michler
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...
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
Florian Lösch, Vice President BU NetSuite bei PROMATIS software GmbH, sprach bei DOAG.tv mit Katharina Schraft, DOAG Vorstand Business Solutions und Themenverantwortliche NextGen über das Thema Nachhaltigkeit. Ist die Nachhaltigkeit nur ein Trendthema oder eine...
Signing E-Business Suite / Forms Java Applets using a Cloud based Code Signing Certificate - Part 2
Johannes MichlerExecutive Vice President – Head of Platforms & DevelopmentAs 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 (see...
Signing E-Business Suite / Forms Java Applets using a Cloud based Code Signing Certificate - Part 1
Johannes MichlerExecutive Vice President – Head of Platforms & DevelopmentRecover database fails Recently I ran into a problem when trying to restore a database backup (created with backup database plus archivelog;) that was created onto OCI object storage. Somehow...
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...
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).
Update on July 2023 EBS Issues with OCI Load Balancer
Maybe you've read my recent blog post on issues with using OCI Load Balancers in combination with E-Business Suite July 2023 security patches.
Together with Oracle we found a better workaround than the one mentioned in my previous post.
Securing Mobile Web Application access with OCI Load Balancer and Transport Layer Security (TLS)
Oracle Mobile Supply Chain Application Apps (MSCA) / Mobile Web Applications (MWA) rely on a telnet-style protocol to connect from the client - be it an Android or iOS device or be it a dedicated scanning hardware - to the application server.
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.
Oracle OCI Load Balancer with Lets Encrypt (free) SSL certificates
Johannes MichlerExecutive Vice President – Head of Platforms & DevelopmentE-Business Suite Umgebung mit LetsEncrypt Zertifikat Nowadays, all web traffic through the internet should be encrypted. For this to work, SSL certificates are required. These can be bought from...
Turn off all the lights at night - Reducing costs by automatically pausing EBS@OCI instances
Johannes MichlerExecutive Vice President – Head of Platforms & Development Costs Analysis dashboard in OCI Running services on a public cloud platform, even when running the service 24/7, is often cheaper than running these services on premise regarding Total Cost of...
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...
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...
Exposing NULL values and Booleans in JSON/REST with Oracle SOA Suite
Recently we had a couple of projects where we needed to expose data extracted from an Oracle Database through a simple SQL query as a REST service producing JSON. Let’s have a look at how it is possible to control the JSON produced in such a scenario.
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
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.
First Experience with E-Business Suite Cloud Manager 22.2.1
Oracle recently released E-Business Suite Cloud Manager Release 22.2.1. There is an official blog post on the new features, but let’s have a look at my experience while migrating to this latest version for one of our customers.
Initializing E-Business Suite Context for a Read-Only-User
Recently I described how a read-only user can be created for Oracle E-Business Suite. This works great, however, when trying to access the pre-built views of E-Business Suite, many of them do not show any data. Let’s see how we can remedy this.
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.
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.
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).
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.
E-Business Suite Cloud Manager 21.1.1.1 can finally discover environments
As described in many of my previous posts, Oracle E-Business Suite Cloud Manager tooling allows for a convenient management of your Oracle E-Business Suite environments on OCI.
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).
New Compute Shape E4.Flex available on OCI in Frankfurt
While upgrading one of our customers from 12.1.3 to 12.2.10 I realized (by chance) that Oracle made available the latest E4.Flex (AMD EPYC) shapes in the Frankfurt OCI data center last week.
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.
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).
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.