User Lookup in Oracle Integration Cloud Service

In my blog, I have explained about lookup in Oracle Integration Cloud Service. This blogs shows how to create and use lookup in any integration.

Follow below steps to create and use lookup in the integration

Create Lookup

• Click on the Lookups tile from ICS home page

• Click Create button from upper corner
• Enter Lookup Name & Description and click Create button

• Edit domain names by clicking on the Domain_name_1 and select Edit Domain Name

• Enter domain name as per choice. Same ways we can edit the name of Domain_name_2
• Enter Values as shown in the below screen shot and click + sign to add more values

• Click Save and Close button

With the above steps we have seen how to create lookup in ICS. Now let's see how to use lookups in integration.

Use Lookups

• Open any existing Integration
• Drag and Drop Assign Activity from Actions on the Integration canvas

• Enter Name and click Create button

• Click + Sign to add variable and enter Name of the variable

• Click on Edit button to open expression builder from the right side below Value column
• Seach Lookup and Drag & Drop lookupValue function on Expression

• Select CountryLookup and click Next button

• Click Select Source Column and select Country Code

• Same ways, click on Select Target Column and select CountryName and click Next button

• Enter any default value. This allows lookupValue function to set default value if none of the CountryCode is found from the lookup. Click Next button and Done

• srcValue value need to replace with any variable or set any hard coded value as of now. This will allow lookup to search entered value in lookup against CountryCode and return corresponding Country Name. If Country Code is not found then it returns default value(in our case default value is Not Found)

That's it !