Recent Posts by Juergen Kress

ATP = Autonomous Transaction Processing from Oracle. Oracle Autonomous Transaction Processing delivers a self-driving, self-securing, self-repairing database service that can instantly scale to meet demands of mission critical applications. More details about ATP here First step was to get access to an ATP service. I then connected to this via SQLDeveloper - here I created a new table – Read the complete article here. PaaS Partner Community For regular information on Oracle...

In one of my current bigger ADF projects (yes, there are still big ADF projects!) I had a problem with the ‘executeWithParams’ operation binding called from a bean. To understand the problem I first give a brief description. Problem We have a special string column in some of our VOs. For this column, there is a bind parameter which is added to the where clause of the VO. Getter and setter for this bind parameters are generated to be able to set this parameter safely. In the...

This is the second part of transferring the secured file over SFTP in Oracle Integration Cloud. In the previous blog, we showcased how to create encrypted files using Pretty Good Privacy (PGP) mechanism. In the article, we'll process the encrypted file, decrypt it and print the records into the logs. I'll recommend you to check the previous article before going ahead. To decrypt the file, we would be needing the PGP private key along with the password.The PGP key private key...

In this short post I am going to show a simple approach to make sure that your ADF application running inside a Docker container is a healthy Java application in terms of memory utilization. I am going to use a standard tool JConsole which comes as a part of JDK installation on your computer. If there is a problem (i.e. a memory leak,  often GCs, long GCs, etc.) you will see it with JConsole. In an effort to analyze the root of the problem and find the solution you might want...

Are you scared the data can be hijacked during transmission of the files if we are doing transactions using the Integration Cloud? Do not scare, read the article and feel comfortable to transmit the files in a secured manner.Oracle Integration Cloud provides Pretty Good Privacy (PGP) mechanism to encrypt or decrypt the files which allow us to read/write files in a secure manner. So, we only required PGP public and private keys to transfer files in a secure manner. Do you want...

We are using Nginx web server for Oracle ADF WorkBetter hosted demo hosted on DigitalOcean cloud server. Nginx helps to serve web application content fast and offer improved performance. One of the important tuning options - content compression, Nginx does this job well and is simple to setup. Content compression doesn't provide direct runtime performance, a browser would run the same code, doesn't matter it was compressed or not. But it brings improved perceived performance...

The stage file action can process each file downloaded by the FTP Adapter. The stage file action can read, write, zip, unzip, and list files in a staged location known to Oracle Integration Cloud. For example, you may include a stage file action in an integration as follows: Configure an FTP Adapter with the following settings: Download File operation Unzip the File option Input directory and download directory path Because the ZIP file may contain multiple files, configure...

Back in 2015 I wrote a blog entry to help our customers get a clear picture about the Oracle ADF vs Oracle JET "debate", over the years I kept pointing people to this writeup as a simple summary of what we are aiming to do and as a guideline for picking the technology you should use. However, the technology world is an ever changing place, and I believe that it is time to do a bit of an update of that entry to reflect the current status. While the basic distinctions between...

  In this article, we are going to describe how to capture Events in Oracle Integration Cloud of Enterprise Business Suite (EBS) using the Oracle EBS adapter. For example, if an Account Payable (AP) transaction closes for the period the AP raises the event “oracle.apps.ap.CloseProcess.period”. The status of the closed transaction can be sent to the downstream application once it is captured in the Oracle Integration Cloud. During design time, we need to create an integration...