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
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.
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 22.214.171.124 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 126.96.36.199
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).
Oracle APEX vs. Oracle VBCS: Comparison of the two front-end technologies / Part 1
Oracle Application Express (APEX) and Oracle Visual Builder Cloud Service (VBCS) are two low-code platforms by Oracle that can both be used for creating web applications. But what are the differences and similarities between the two front-end technologies?
ORACLE APEX Cloud Service – inexpensively available in the Oracle Cloud
Oracle Application Express (APEX) is a popular low code platform for developing database-driven web applications. When previously wanting to operate such applications in the Oracle Cloud, there were two real alternatives.
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.
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.
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.