Recent Posts by Juergen Kress

I will talk about expert mode View Object (with hand written SQL), this View Object is created based on SQL join. So, thats my use case for today example. I will describe issue related to generated SQL statement and give a hint how to solve it. This is in particular useful, if you want to expose complex VO (SQL with joins and calculating totals) over ADF BC REST service and then run queries against this REST resource. Code is available on my GitHubrepository. Here is SQL join...

A quick recap on schedule parameters Schedule Parameter feature supports adding scalar variables for Scheduled Orchestration Integrations. These parameter values are available across scheduled runs for the particular Integration and can be overridden by downstream actions like Assign. A maximum of five schedule parameters can be defined per Integration. Requirements like the following can be achieved by using schedule parameters: Maintaining the Last Run Time (position) of the...

In my previous post I showed the steps you have to take to create your first ADF REST resource. You can find it here: First steps with REST services on ADF Business Components. I will continue my exploration in the world of ADF REST. We are now going to configure the URL and test the new service. After you run your application, you will see the endpoint in your JDeveloper log: The first thing you will probably notice is the structure of the URL and there is little chance you...

In this short blog, I'd like to show you how easy it is to enable tracing in OIC Integration and start tracing your integration flows. When Tracing is enabled, OIC Integration prints detailed info before and after each action that is executed (optionally the payload if needed). Hence care should be taken to make sure that it is enabled only for debugging purposes and turned off before going production. Global Tracing Let's assume that you have a requirement where you would like...

Join Link Consulting, eProseed & Oracle for a Meetup in Porto Every now and then there’s a paradigm change in how we interact with computers. Chatbots have already conquered their own market place but, as usual, technology never ceases to amaze us! Unlike a simple chatbot, a Virtual Digital Assistant can be equipped with multiple skills covering a wide set of domains and scenarios all from one conversational interface.There’s no need to have and separately orchestrate the...

Introduction A library is a file or a collection of multiple files bundled in a JAR that contain Javascript functions. Library is used within an integration and is executed by a Javascript engine on the server as part of an integration flow. This document describes the following: 1. Requirements that a Javascript function needs to meet to be used within integration. 2. How to create Javascript file or collection of Javascript files that are suitable to be used in creating a...

  Few months ago I had a post about Oracle Offline Persistence toolkit, which integrates well with Oracle JET (JavaScript toolkit from Oracle) - Oracle JET Offline Persistence Toolkit - Offline Update Handling. I'm back to this topic with sample application upgraded to JET 5.1 and offline toolkit upgraded to 1.1.5. In this post I will describe how to control online replay by filtering out some of the requests, to be excluded from replay. Source code is available on GitHub. Belo...

  In this blog, I'd like to show you how easy it is to use Oracle Litmus, a new feature added to Oracle Integration Cloud for creating unit tests automatically with a few clicks and run those tests to catch regressions. Litmus supports the following use cases: · Enable Integration Cloud users to create unit tests automatically and play them back to catch regressions when they modify their integrations (typically when they enhance an already created integration before making it...

  Join Contribute and Oracle for a Developer Meetup in Brussels During this meetup, 2 topics will be presented to you by a product manager of Oracle. Afterwards you will receive an invite to be able to test these solutions on your own pace. Have fun. Running WebLogic Server in Kubernetes Many organizations are adopting Kubernetes as a platform for managing container-based applications and want to leverage Oracle WebLogic Server in these environments.Attend this session to learn...