Recent Posts by Juergen Kress

In this blog we describe the implementation of an EAN / GTIN code validator in een Decision Model Service. As a Pizzeria that wants to treat the customer like a king, we think it is very important that we can always serve the customer with our full range of pizzas. For this it is necessary that we have a good stock management policy. Every pizza we make must be processed accurately in the system. To simplify this processing, we provide each pizza box with an EAN barcode that...

Simplifying Cloud Native Development This spring Oracle plans to deliver more tools for cloud native development, networking, and security that developers can use to write containerized applications. Microservices and containers make it faster and simpler to add new features to an application, because developers need to change and test only portions of their code, not the entire application. Learn more about this offering. How the Cloud Is Powering Deep Science Scientific work...

In this second part of the ML in Digital Process Automation article series, we focus on how to consume a Machine Learning Model created in Autonomous Data Warehouse (ADW) for scoring in Integration Cloud Processes. It is assumed that the reader is familiar with the content of Part I. For this article we assume an existing ML model stored on Object Storage. We will give step-by-step instructions on how to bring such models into Oracle Integration Cloud and use them in...

In part one, showed how to implement a SQL IN clause in ADF. Now I show how to use this technique in a ViewCriteria or directly in a query of a view object. We have to solve a couple of problems before we can really use the technique from part one in a ViewCriteria. As you know, when using a ViewCriteria, you select an operator which in turn is translated into SQL code. So, we have to find a way to create a new operator which will then be used to create the needed SQL code. The...

Let's look at this excerpt to find out what API-led means and explore the architectural decisions, implementation patterns, and more. As APIsopen doors to information and functionality, they move well beyond being merely technical interfaces to becoming central actors in new digital business models. However, for such business models to be effective and successful, technical teams are confronted with the unique challenge of API-enabling systems that weren't necessarily built to...

JavaScript has been around since 1995. But a lot has changed in nearly a quarter-century. No longer limited to the browser, JavaScript has become a full fledged programming language, finding increasing use in enterprise application development. In this program a panel of experts explores the evolution of JavaScript, discusses how it is used in modern development projects, and then takes a close look at Oracle JavaScript Extension Toolkit, otherwise known as JET. Listen to the...

Queue Setup in Oracle Advanced Queuing First step was to set up the Q in AQ. CREATE type Message_typ as object ( subject     VARCHAR2(30), text        VARCHAR2(80));  EXECUTE DBMS_AQADM.CREATE_QUEUE_TABLE (queue_table => 'objmsgs80_qtab',queue_payload_type => 'Message_typ'); EXECUTE DBMS_AQADM.CREATE_QUEUE (queue_name => 'msg_queue',queue_table => 'objmsgs80_qtab'); EXECUTE DBMS_AQADM.START_QUEUE (queue_name => 'msg_queue'); I then created a procedure to create a message – Read ...

Learn how to use Oracle's JavaScript Extension Toolkit (JET) as a solution to the all too common problem of internal back office and intranet applications that are typically ugly, clunky, and cumbersome to use. JET simultaneously provides you with a JavaScript toolkit that is cutting-edge while being stable enough for enterprise development in an ecosystem that is notorious for its fast-paced rate of change. Practical Oracle JET walks through the process of developing a...

This is a frequent requirement to call Business Intelligence (BI) service in Oracle Integration Cloud (OIC). This article focuses on how to call BI SOAP API in OIC scheduler process and extract data. See useful links How to create a SOAP connection How to create a Scheduled Integration First, have a look at the sample request and response of BI SOAP API BI SOPA Endpoint: https://ef-dev1.af.em1.oraclecloud.com/parser/services/v2/ReportService?wsdl Method: runReport Read the...