Showing posts with label LookUps. Show all posts
Showing posts with label LookUps. Show all posts

Sunday, March 1, 2020

Retry using OIC

How to add retry logic in OIC


In a regular JCA adapter, there are properties for setting the number of retries.  

OIC as of now doesn’t allow retry options for Synchronous service but it does allow retry options in Asynchronous service.

In Asynchronous service the errors can be resubmitted. As per OIC documentation
Resubmitting the failed instances can be done as 
§  Single failed message resubmissions
§  Bulk failed message resubmissions


Retry can be done at integration level as well. I am providing the steps below which can be applied to the integration. This example is for SOAP Trigger. Ensure that Trigger has optional element as a RetryCounter-

Step 1: Create Integration. Create a Stage and drag an Invoke (example an external SOAP service). 
Step 2: Create an Invoke Connection with URL and Security details from integration created in Step1.  
Step 3: Set the retry counter value in OIC LookUp
Step 4: In Stage Error Handler create a SwitchCase, drag the above connection and map parameters from the main flow. 
Step 5: In the switch condition, the retry counter value should be less than the LookUp value created in Step3. 
Step 6: In Case 1 – Update the retry counter, In Case2 – Invoke the connection created in Step2. 

Thursday, February 27, 2020

Using LookUps in OIC

Here is an demo for using a LookUp in OIC



Browse OIC IntegrationDesignerLookUpsCreate

Step1: You can select respective adapters. I have chosen as per the adapters that I am using for this integration.








Step2: Once Lookup is created. Go the Integration Mapper, then drag the lookupvalue function to the input literal (blank space)









Follow the instructions. Provide default text and map the source. Once done - The integration is good to be activated. 

Note – A csv file can also be used for importing values.

FBDI Introduction

FBDI  stands for File Based Data Import. It is a pattern provided by Oracle to have the data loaded into Oracle ERP Cloud. Its usually u...