Saturday, May 9 2026

In this post I have explained how to send Attachments along with notification’s body in OIC Notification action. Knowledge :πŸ‘€ The total size limit on a notification email is 1 MB for Oracle Integration and 2 MB for Oracle Integration Generation 2. Steps overview to send attachment in OIC notification action  : Open the Notification action and click

  News :  πŸ˜‡ This article published in October 2020 Edition of Oracle PaaS Partner Community Newsletter New update in OIC allow us to replace any connection used in an integration with another connection of same Type and Role. Earlier if you want to replace any existing connection of an integration for that you had to delete



In this blog we will test the Integration which we have developed in previous blog
Prerequisite : SoapUI Tool
Lets see the testing steps in detail :
  • Activate the Integration and open the URL which get generated after integration activation.
  • Copy the Endpoint URL 

– Advertisement –




News :  πŸ˜‡

This post featured in June 2020 Edition of Oracle PaaS Partner Community Newsletter



Oracle Integration Cloud Service provides “Global Fault Handler” to catch errors/faults in orchestrated integration and perform actions. In an event of a fault in an integration it goes to “Global Fault Handler” to perform some user define actions like notifying about error by sending email notification etc. and then stops the flow of integration abruptly with an error state i.e. integration will stop and not move to next logical step. We can add fault handling to any integration type (for example: app driven orchestration, scheduled integration etc.). 

Now suppose πŸ‘€ β†’when you have to iterate through multiple conditions and need to continue even if one condition fails i.e. you don’t want your integration flow to stop but move on to the next logical step. To achieve this we have to configure “Default Fault Handler” (at Scope Level).
Scope can catch the error and move ahead to the next logical step in the integration.This does not stop the integration abruptly but rather moves to the next logical step(ex. if there is any Loop, loop will continue to execute).



USE CASE I: [BASIC TYPE] Schedule the integration for every 10 minutes. For this type there is minimum frequency limit of 10 minutes. If you try to define a schedule frequency of under 10 minutes, a validation error occurs. Use iCal to schedule the integration below 10 minutes.
USE CASE II: [ADVANCE TYPE] Schedule the frequency for every 5 minutes using iCal expression. 

– Advertisement –




Please access the previous blog to see integration development steps.

Step 1 :  
Activate the integration and click on endpoint.

Copy the Endpoint URL.

               



Step 2 : 
Open SoapUI tool and click on REST and paste the above copied endpoint URL and click ok.



We use lookups in the integrations to create reusable tables that
map the different terms used to describe the same item across your
applications.
Lookups are exact same as Data
Value Map(DVM)
in SOA.

Lets see how to define a Lookup in OIC  with an example :


Use Case :-


Inside this blog, we see will define a lookup for Country Code & Country Name. For a specific Country Code we will assign one unique Country Name.


Country_Code
Country_Name
USA
United States of America
IS
Israel



development Steps in detail :

– Advertisement –





In the previous blog we have seen how to define Lookups in OIC. In this blog we will use that defined lookups in an Integration.

STEP 1 : create a App Driven Orchestration

                 
                 Enter Below details and click Create :


            *what do you want to call your Integration : Country code to 
              Country Name (you can give any meaningful name)
       

– Advertisement –








Overview : In the previous blog ( click to see the blog ) we have learned basics about OIC Connectivity Agent and the steps to install it in a local machine (personal laptop) Now in this blog we will create an integration to insert records into a database using the installed connectivity Agent. *Make sure your system



Basics about Oracle Database 11g XE (Express Edition) :

πŸ‘‡

Free Oracle Database for Everyone :

Whether you are a developer, a DBA, a data scientist, an educator, or just curious about databases, Oracle Database 18c Express Edition (XE) is the ideal way to get started. It is the same powerful Oracle Database that enterprises rely on worldwide, packaged for simple download, ease-of-use, and a full-featured experience. You get an Oracle Database to use in any environment, plus the ability to embed and redistribute – all completely free!

– Advertisment –





Now lets see the Steps to download and configure database in localhost i.e. in your personal laptop :
1 3 4 5 6 7