Recent Posts by Juergen Kress

I share my main returns as part of a client request to extract the payloads of the instances in a given time interval, with payloads of instances in CLOB format. It’s an opportunity to explore the main SOA dehydration stores and queries the most used in 12c, and share them with you for such requests, I hope it will be useful, I. Description  of the principal’s tables  used Below mentioned tables are the important ones that will be used to locate the instances. CUBE_INSTANCECOMPOS...

Oracle Integration Cloud provides a File adapter to deal with the files which reside on the local server. File adapter allows following operations on an on-premise location, using Integration Cloud connectivity agent: File polling Write The in and out directories should be locally accessible from the server where ICS connectivity agent is installed. Refer the blog to understand the difference between File and FTP adapter. Use Case: For the particular article, we'll leverage the...

Oracle OpenWorld 2019 is just around the corner. We look forward to seeing you in San Francisco from September 16-19, 2019. Whether you are looking to learn about Oracle’s latest technologies, product roadmaps, customer implementations, get hands-on learning, dive into product demonstrations and/or networking with your peers, we are confident that this year’s conference will not disappoint! Thanks for spending the week with Oracle.  Good trip to San Francisco Jürgen Kress   Cloud...

As businesses move to the cloud there is a high demand for securing/protecting their HTTP resources from unauthorized access. There are several approaches to protecting these resources which include SAML for SOAP service, OAuth for REST services, HTTP basic for both, and sometimes home grown proprietary mechanisms. It may not be widely known yet, but all Oracle Integration Cloud (OIC) REST endpoints are OAuth protected and can be triggered from a client using OAuth 2.0...

This article talks about programmatic approach of creating dvt components or charts, using Java objects, and more importantly, without ADF bindings. This is quite helpful when you deal with data which does not change often and can be pre-loaded into Java objects. The biggest advantage of this is of course, performance, since you do away with any database interaction. The sample code has a table based on Department pojo. Each department object has a List of Employee pojo. On...

In one of my article, I have showcased how to install the on-premise agent on the Linux machine. This article will show you how to upgrade the existing on-premise agent. In this blog, we are upgrading the agent from 18.1.3.0.0 to 18.4.3.0.1 Below are the steps to upgrade the on-premise agent Login into the ICS console and move to the Designer -> Agents page Click on the Download -> Connectivity Agent A file will be downloaded with name ics_conn_agent_installer_181022.0000.1074.z...

This week I was working on a task to integrate Jasper Visualize.js into Oracle ADF application JSF page fragment. I must say integration was successful and Jasper report renders very well in Oracle ADF screen with the help of Visualize.js. Great thing about Visualize.js - it renders report in ADF page through client side HTML/JS, there is no iFrame. Report HTML structure is included into HTML generated by ADF, this allows to use CSS to control report size and make it...

Oracle OpenWorld will take place September 16th-19th in San Francisco USA. We highly recommend to register for the Partner Advisory Councils, visit the Exchange (demo grounds) and sessions you should attend: · Oracle Digital Assistant · Oracle Content and Experience · Oracle Cloud Platform for Oracle SaaS · Visual Builder Cloud Service · Oracle Integration For more Oracle OpenWorld information please visit the registration page here.   Developer Partner Community For regular...

Want the ability to add an Create Error activity at any point in the execution of an integration flow?  Now you can.  You will need to enable "oic.ics.console.integration.throw-action" feature flag to enjoy this feature. · Create or Edit an Integration · Drag the 'Create Error' action · Notice the gray plus icons that appear over the connector lines · The error can be Dropped on any of those plus icons · Once dropped enter a Name and Description (optional) for the error · Read the...