PaaS Community Blog

Use Oracle Integration to Connect E-Business Suite with Financials Cloud

Moving Oracle E-Business Suite to the cloud brings many opportunities to modernize and integrate with other cloud services. Many times, these projects relate to the adoption of new SaaS applications which add more functionality and business processes.

One example is modernizing the infrastructure of EBS running the manufacturing operations by bringing to Oracle Cloud and connecting with a new implementation of Oracle Financials SaaS.

Oracle Integration is an Oracle Cloud regional service with a powerful set of adapters, providing connectivity and integration for Oracle E-Business Suite, cloud services and technologies, and SaaS applications as Oracle Financials Cloud. This architecture presents a topology for connecting an EBS instance on Oracle Cloud Infrastructure (OCI) with Oracle Financials SaaS using Oracle Integration.

Architecture

This architecture shows the deployment of Oracle E-Business Suite in a single availability domain inside an OCI region, along with integrations built using Oracle Integration. Oracle Integration is connected to Oracle E-Business Suite using Oracle E-Business Suite Adapter deployed with the Oracle Integration Connectivity Agent.

The architecture includes two compartments, both of which have Cloud Guard enabled to provide maximum security based on Oracle’s security best practices. In addition, the compartment where the database system and the autonomous database private endpoint are deployed is a security zone compartment. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

Blog Twitter LinkedIn Facebook Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Tips and Tricks for handling numbers in BPEL or OIC by Pranav Davar

While integrating with multiple systems and moving data from one system to the other, we generally come across scenarios, wherein we need to change the format of the number or perform operations like floor, ceil, round, divide, multiply, add, etc. on numbers. We will be going through various mathematical functions available in XSLT 1.0, which would be helpful in such scenarios, and also some generic errors which we encounter usually.

– Mathematical Operations

1. Divide

2. Multiply

3. Add

4. Subtract

5. Square-root

6. Round

7. Floor

8. Ceil

9. Advanced Number formatting

– Common Errors

Mathematical Operations

1. Divide

To divide 2 numbers, we can use the div operator to divide two numbers.

Syntax:

    $num1 div $num2

Example:

    Let us assume we want to divide 120 by 7. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

Blog Twitter LinkedIn Facebook Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Convert JSON to String Oracle Integration by Ankur Jain

I have seen multiple target applications which accept the JSON data as a String in a single element. So, it is necessary to convert the JSON to String before you call the target endpoint.

Convert JSON to String Oracle Integration

For example:

Below is the JSON which you may get from the source system:

{

"firstname": "ankur",

"lastname": "jain"

}

and you need to map the above JSON as a string in the following single element:

{

"data" : "{\n \"firstname\" : \"ankur\",\n \"lastname\" : \"jain\"\n}"

}

So, in order to achieve this, first, you have to write the JSON to the temporary location using the Stage File action and read it using the opaque schema as a String.

Here is the opaque.xsd code which you need to use to read the JSON from the stage: Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

Blog Twitter LinkedIn Facebook Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Leverage Oracle MySQL Database Service (MDS) with Oracle Integration Cloud by Arpit Narula

The primary objective of this blog is to detail out how Oracle’s MySQL DB can be provisioned on OCI Gen -2 and integrate it with Oracle Integration Cloud. MySQL Database Service on Oracle Cloud might prove out to be a very cost effective and performance enhancing solution for many use cases. A few such use cases are

· Custom Logging and Error Handling Frameworks

· Implementing Parking Lot Patterns for Integrations

· Building Data Stage for VBCS applications

So let’s jump into the fun sections where we will cover the following topics in detail.

a) Create an MDS Cloud Instance

b) Setup compute instance (that will connect to MDS)

c) Create an OIC Instance and Agent Setup

d) Build a sample integration read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

Blog Twitter LinkedIn Facebook Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Ways to download connectivity agent Oracle Integration by Ankur Jain

The connectivity agent is used to establish the communication between SaaS and on-premises applications. Before you create the connection with on-premises applications in Oracle Integration, you must have to download the connectivity agent and install it on the host machine.

There are various ways to download the connectivity agent. So, in this short article, we’ll describe various options to download the connectivity agent of Oracle Integration.

1. Using Oracle Integration Console

The easiest way to download the connectivity agent is using the Oracle Integration console. To download it using the Oracle Integration console follow the below steps:

1. Login into the Oracle Integration Console.
2. Navigate to the Integrations -> Agents page
3. Click on the Download -> Connectivity Agent option from the upper right corner of the page. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

Blog Twitter LinkedIn Facebook Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

OIC Activity Stream to OCI Log analytics by Shreenidhi Raghuram

OIC Activity Stream to OCI Log analytics

Introduction

We know that Oracle Integration Activity stream logs can be downloaded from OIC using the Monitoring console. Here is the reference link – Monitoring OIC
A commonly implemented solution by customers is to automate the download of activity stream logs periodically using monitoring REST API and store them in repositories like FTP servers or Object storage for offline analysis and diagnosis.

However the Activity stream download  is governed by size of the activity stream log file. Refer – activity stream logs retention.
Due to this size limitation, customers could have an issue with the ability to reliably download activity stream logs for a definite period of time, say last 1 hour. For instance, during periods of heavy activity on the OIC instance the log file may only cover a portion of the period due to the size limitation.

Solution

Good news ! This requirement has now been addressed as part of the August 2021 release of Oracle Integration.
OIC now allows activity streams to be sent to OCI Logging service. OCI Logging service provides persistence as well as real time analysis on the OIC activity stream messages. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

Blog Twitter LinkedIn Facebook Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Business Identifiers in Oracle Integration by Ankur Jain

A Business identifier in Oracle Integration helps you to track the messages from the monitoring dashboard quickly and easily.

Without enabling the Business identifiers, you can not activate the integrations.

Max 3 business identifiers can be assigned during the design time. One is primary and the other two are secondary.

To understand how to enable Business Identifiers and how to use them to track the runtime integration, read the complete article here

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

Blog Twitter LinkedIn Facebook Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Oracle Integration Update Webcast September 2021 on-demand

Watch to get the latest updates and innovations on Oracle Integration release. Our Oracle Integration Product Manager Team will present new features, product roadmaps, discuss upcoming innovations and provide guidelines to help you adopt these quickly within your organization. Topics include:

• Welcome & announcements

• August release update Oracle Integration

• ERP / SCM Integration Best Practices from the A-Team

• Questions & Answers

Watch the on-demand webcast here and subscribe to the newsletter here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

Blog Twitter LinkedIn Facebook Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress