Friday, November 29, 2019

OIC - Enrichment in basic routing integration

I am going to add a service to get the department name from depart id which will further be enriched to the existing SOAP to DB employee insert integration.

Drag and drop the invoke or another integration. Here i used a Invoke connection to get the department Name for a respective department id.




Map the department id input

Map the department name response






Activate and test





Thursday, November 28, 2019

OIC - Use of Lookup

A lookup associates values used by one application for a specific field to the values used by other applications for the same field. This provides the capability to map values across vocabularies or systems. For example, you can map country codes, city codes, currency codes, and so on.

First create a lookup - country codes
Designer⇾Lookups⇾Create











 Use the created look up in the map of a integration.

















 Activate and test



Featured Post

OIC - how can I use XSLT functions to remove leading zeros from numeric and alphanumeric fields?

To remove leading zeros from an numeric field in Oracle Integration Cloud (OIC) using XSLT, you can Use number() Function The number() funct...